-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Tilman Schmidt wrote:
> Prompted by several postings here on the list I thought it might be a
> good idea to run dbcheck on my Bacula DB and see what it will find.
> But tests 9 (orphaned Path records) and 10 (orphaned Filename records)
> are inacceptably long to complete.
>
> Configuration: dual Intel Pentium 4, 1 GB RAM, Linux 2.6.22.13,
> running Bacula 2.2.8 director with MySQL database
> and Bacula 2.2.8 storage daemon driving an LTO-1 tape drive,
> doing daily backups for 12 servers for a total data volume of about
> 70 GB. The catalog size reported by the catalog backup job is 300 MB.
>
> When started individually, dbcheck tests 3-8 and 11-15 run rather
> quickly (at most a few minutes). Check 9 finally completed after
> about 15 hours, pushing the nightly backup into the day and causing
> a lot of complaints. Check 10 has been running over the weekend for
> 40 hours now with no sign of getting anywhere. During that time,
> top shows mysqld constantly at 100% CPU while the second processor
> is basically idle.
>
> Is that normal? If so, how can I check my database without disrupting
> my regular backup cycle? If not, how can I find out what's wrong?
I was involved in a thread about 9 months ago that had to do with this.
There was a lot of back and forth between another person on this list
and me about what to do. It came down to indexes in the catalog database
and making sure your database was configured properly for the machine it
was on. For example, my machine was for some reason using my-small.cnf's
defaults (it is a relatively powerful machine, or was in its day, and
does almost exclusively Bacula). Having changed both at the same time,
I'm not sure which change did it.
For specifics though, you should really check the archives. If you
search my name, you'll probably turn something up.
- --
---- _ _ _ _ ___ _ _ _
|Y#| | | |\/| | \ |\ | | |Ryan Novosielski - Systems Programmer II
|$&| |__| | | |__/ | \| _| |novosirj AT umdnj DOT edu - 973/972.0922 (2-0922)
\__/ Univ. of Med. and Dent.|IST/AST - NJMS Medical Science Bldg - C630
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFJRmJAmb+gadEcsb4RAt2gAJ9dmcv8VCaVgw+0oI8agGBs0GgIQACfb3pI
E5h+/uZjjrEmX0bWFfTYSeQ=
=qTSV
-----END PGP SIGNATURE-----
novosirj.vcf
Description: Vcard
------------------------------------------------------------------------------
SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada.
The future of the web can't happen without you. Join us at MIX09 to help
pave the way to the Next Web now. Learn more and register at
http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ _______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
