On 2/19/2010 2:52 PM, Steve Ellis wrote:
> I don't know if this is specific to mysql or not. My system: Fedora 12
> x86-64, Bacula 5.0.0 (installed from fedora's rawhide), mysql 5.1.42.
> I've been happily running bacula 3.0.3 on this particular machine and
> config for several months without issue (and earlier bacula releases,
> but without Accurate for several years), but after trying an upgrade to
> 5.0, I've noticed that accurate backups are now dreadfully slow (at
> least a differential is, I assume the same applies to incrementals). If
> I turn off Accurate, backups proceed fine, but with accurate on,
> mysqladmin processlist will eventually show this query taking hours (or
> perhaps days, I haven't waited that long):
The best way to get more data about what's going on is to use the 'explain'
mysql command. First, get the complete SQL query that's taking too long to
run by using the 'show processlist full' command - that way the results won't
get truncated.
Then, run the query manually, but prefixed with the 'explain' command:
explain SELECT Path.Path, Filename.Name, ...
This should give you more data about exactly how mysql is going about
executing the query, which should hopefully in turn point to why it's taking
so ridiculously long and how that might be fixed.
--
Frank Sweetser fs at wpi.edu | For every problem, there is a solution that
WPI Senior Network Engineer | is simple, elegant, and wrong. - HL Mencken
GPG fingerprint = 6174 1257 129E 0D21 D8D4 E8A3 8E39 29E3 E2E8 8CEC
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
