On Tue, 22 Mar 2005, Jeff McCune wrote:
Index creation took 20 minutes, and dbcheck -f ran for 27 hours before I killed it and wiped the entire machine to upgrade to RHEL4.
Soething's wrong with your setup then.
Currently, a Full backup of my /home volume is 480GB in just over 4 million files. That's just /home. In addition, I have 15 other servers doing special things and about 40 workstations to backup. I'll estimate a full backup of our site at 2500 to 3000 GB of data in 10 *million* files.
I'm currently backing up about 10TB across 2 servers with around 8 million files, plus another 16 machines with relatively trivial amounts (less than 500Gb and 2 million files). Dbcheck takes about 15-20 minutes, even with ~90 million record in there.
Have you tried a MySQL check database command?
The bacula/MySQL server has 2GB ram and dual 2GHz xeons but for the most part would be happy on 1Gb. i have made it hit swap _once_
I do recommend you increase your /etc/my.cnf deafults though. DBcheck is _painfully_ slow if you don't allowcate enough memory for sort buffers, and may die altogether (whcih is what clued me to increasing it)
The usual distributed default my.cnf limits are for a 128Mb multipurpose machine. I multiplied everything by 50 for the server here - it's not really an issue for us to have MySQL instances growing to 600Mb RSS as the box is Bacula and NFS serving only.
AB
------------------------------------------------------- This SF.net email is sponsored by Microsoft Mobile & Embedded DevCon 2005 Attend MEDC 2005 May 9-12 in Vegas. Learn more about the latest Windows Embedded(r) & Windows Mobile(tm) platforms, applications & content. Register by 3/29 & save $300 http://ads.osdn.com/?ad_id=6883&alloc_id=15149&op=click _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
