Bacula-users

Re: [Bacula-users] MySQL slowness when initializing new disk volume

2014-04-18 18:55:04
Subject: Re: [Bacula-users] MySQL slowness when initializing new disk volume
From: Lloyd Brown <lloyd_brown AT byu DOT edu>
To: bacula-users AT lists.sourceforge DOT net
Date: Fri, 18 Apr 2014 16:49:56 -0600
On 04/18/2014 04:44 PM, Martin Simmons wrote:
> The second query is related to pruning (probably autoprune unless you are
> using the prune command on the console).  This is normal while jobs are
> running.

Autoprune.  Definitely autoprune.

> Are the tables in MyISAM or InnoDB format?

At the moment, MyISAM.  I'd wondered if I could safely convert to
InnoDB, since that's generally going to have better locking
characteristics, etc. (I think MyISAM does table-level locking only, for
example).  I just wasn't sure if this was supported, a good idea, etc.
Since I haven't dug into the code of Bacula itself very much, I didn't
want to make any big assumptions there.

Are people generally using InnoDB now for Bacula?  If I were designing a
DB-driven application, I'd definitely start out with that over MyISAM,
but I wasn't sure if that was the generally-accepted approach with Bacula.

Lloyd

------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users