-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all,
I upgraded my system from Bacula 2.2.8 to 5.0.3 awhile back and upgraded MySQL from 5.0 to 5.5 if I'm not mistaken. Since that time, I've been having reliability problems. My schedule is to run incrementals every day except for the 2nd and 4th Tuesday and fulls on those days instead. When I tend to have trouble is on the 2nd and 4th Tuesday. The backups on those days hang -- I need to restart the storage daemon and the director it seems like to clear the hang. That is another problem. However, I believe the cause of the hang is a slow delete when the director goes to purge the "full" tape. I have tried running 'status dir' right before one of these backups is to take place and there is a pause for probably more than a minute. MySQL at that time grows to 20% of the system in CPU use. I checked 'mysqladmin processlist' and I see what is taking so long is the following: | 1063 | bacula | localhost | bacula | Query | 71 | updating | DELETE FROM File WHERE JobId IN (14485,14486,14487,14488,14489) | ...this seems to be the real issue. I have the indices referred to here: http://www.bacula.org/en/dev-manual/main/main/Catalog_Maintenance.html#SECTION004292000000000000000 ...can anyone suggest to me what I might do? - -- ____*Note: UMDNJ is now Rutgers-Biomedical and Health Sciences* || \\UTGERS |---------------------*O*--------------------- ||_// Biomedical | Ryan Novosielski - Sr. Systems Programmer || \\ and Health | novos...@rutgers.edu - 973/972.0922 (2x0922) || \\ Sciences | OIT/EI-Academic Svcs. - ADMC 450, Newark `' -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iEYEARECAAYFAlJU7CEACgkQmb+gadEcsb7jSwCcCmY6Za/f+yISgqLNhPIuVezW UxcAoMi3/kYrzE3VS1eeA8ILps6GXww8 =OH+k -----END PGP SIGNATURE----- ------------------------------------------------------------------------------ October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register > http://pubads.g.doubleclick.net/gampad/clk?id=60134071&iu=/4140/ostg.clktrk _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
