Hi, On 5/22/2007 10:20 PM, Manuel Wolff wrote: > Hi List > > One of our servers with about 3.5 millions of files produces a > spool file for the attributes of about 1GB. > > "status storage" at 20:30 > Attr spooling: 1 active jobs, 523,898,883 bytes; 10 total jobs, > 1,078,726,662 max bytes. > At 17:30 it was about 720MB > > Somewhere seems to be a bottleneck.
Just the right time :-) I'm sure that Kern, Eric, and probably others will be very glad to have a real-life catalog insertion test case. If this is too cryptic for you - which I absolutely understand :-) the current beta version 2.1.10 has some improvements that should speed up catalog inserts *a lot*. I'd recommend to give it a try if you dare running a beta version on a production system. As far as I know, there is neither a tape format change, nor a catalog schema change between 2.0 and 2.1.10, so if you keep a catalog dump and use new tapes you could revert to your existing installation without any problems. > The version of bacula is 2.0.3 The director the storage-daemon and > the catalog (mysql 5.0.32) are running on the same machine. > The OS is debian etch on a Xeon 1,8 GHz 1,5 GB RAM 10krpm Disks SCSI. > > Perhaps its the mysqld. The actual Parameters are: > table_cache = 256 > sort_buffer_size = 1M > read_buffer_size = 1M > read_rnd_buffer_size = 4M > key_buffer = 256M > max_allowed_packet = 16M > thread_stack = 128K > thread_cache_size = 8 > table_cache = 8 > thread_concurrency = 3 > query_cache_limit = 1M > query_cache_size = 16M > --- > > Any ideas? TIA Don't ask me for the MySQL related stuff, I'd have to read lots of documents :-) but I'd really give Bacula 2.1.10 a try. Arno > Manuel -- IT-Service Lehmann [EMAIL PROTECTED] Arno Lehmann http://www.its-lehmann.de ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
