* Manuel Wolff schrieb am 22.05.07 um 22:20 Uhr: > 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. > > 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
Perhaps you should try to use a PostgreSQL database as it is often much faster than mysql. Especially with many inserts. -Marc -- 8AAC 5F46 83B4 DB70 8317 3723 296C 6CCA 35A6 4134 ------------------------------------------------------------------------- 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
