This reminds me of the talks we used to have after hilly USCF bike races..."My cog is smaller than your cog". :)

We had a DB that exceeded 50G...backups were roughly 3G in size. This was until JAMF took a look and saw we were inventorying UNIX tools, fonts, etc. We made a few changes and the database is 5% of it's original size, and 500% snappier.

Don

Hi Damien,

How many systems do you have? I have roughly 500 systems and our database is
currently peaking at a backup size of 210MB. We were having some issues with
deleting systems if we got a around 280MB.

However, there are sites that deal with much larger databases, and I'm sure
they can tell you the issues they deal with.

Craig E

Criss Myers
Senior IT Analyst (Mac Services)
iPhone / iPad Developer
Apple Certified Technical Coordinator v10.5
LIS Development Team
Adelphi Building AB28
University of Central Lancashire
Preston PR1 2HE
Ex 5054
01772 895054

when you say size, where are you getitng this from

The DB that gets backed up every night is big

but the memory used is less

Total Memory is 1,328 MB Used Memory is 287 MB Max Memory is 8,171 MB

Criss

Criss Myers
Senior IT Analyst (Mac Services)
iPhone / iPad Developer
Apple Certified Technical Coordinator v10.5
LIS Development Team
Adelphi Building AB28
University of Central Lancashire
Preston PR1 2HE
Ex 5054
01772 895054

We have just under 1200 managed machines.

- Damien.

Our database size is a little under 800mb, and have had no issues with the database or restoring from the database backups.

Hasaan Herrington
Technical Support II
Information Technology
Anchorage School District
(907) 742-4615

We're still in the implementation phase and only been using Casper since about June, so not sure if there will be issues, but we're at 3987 computers with a 1.2GB database.

Jeff Dyck | Analyste de reseaux - Mac OS X
Conseil Scolaire Francophone de la Colombie-Britannique (SD 93)
3550 Wellington Street, Annexe B - Port Coquitlam, BC - V3B 3Y5
Tel: 778-284-0902 - Cell: 778-990-7960 - http://support.csf.bc.ca


Our live database is 7.4GB and the backup sits around 620MB or so. We have
logs expire at 6 months with an environment of ~4200 managed computers.

Every day recons seems a bit excessive unless you're mid-way through rolling
some software out that you need to keep close tabs on. We currently do a
weekly recon for our Macs and will soon be rolling in our Windows computers
as non-managed computers for inventory purposes.

John

8,000 to 9,000 clients. Database is around 12 to 14 gigs, no policy log is kept longer than 30 days with the exception of usage logs. had to manually index a few logs to make performance better.

2 year old top of the line dual quad core Xserve with 24 gigs of RAM. 16gigs allocated to Tomcat in 64bit mode. Modified mysql to have a process pool of 300 connections, 128meg max packet size, plus a few other small tweaks I am probably not thinking of at the moment.

My server definitely is using 300 simultaneous mysql connections too.

I do weekly back ups and dump those back ups into a zip file and that folder that contains those zips is copied to a FW drive ever week as well. Only had to wipe and reload once and the back up went through with out a hitch.

-Tom