-----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 | novosirj AT rutgers DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
