>>>>> On Fri, 18 Apr 2014 09:18:55 -0600, Lloyd Brown said:
> 
> Hi, all.
> 
> I'm trying to diagnose some overall slowness issues with some of our
> backups.  In this case, the SD, FD, and Dir, are all running on one
> host.  The storage being backed up from is NFS (or similarly) mounted,
> and the backup destination is some SAS-attached disks on this particular
> host.
> 
> What I'm seeing is that when a new disk volume is initialized/created,
> the output of "show storage" hangs up for several minutes, just after
> the "Used Volume Status:" line.  It will return eventually, but it does
> take 3-5 minutes at least.  During the same time, a "show full
> processlist" on my mysql server (also the same host), shows one of the
> connections cycling through a lot of queries that look like one of these
> examples:
> 
> "SELECT 1 FROM JobMedia WHERE MediaId=11622 LIMIT 1"
> "SELECT DISTINCT JobMedia.JobId FROM JobMedia,Job WHERE MediaId=11569
> AND Job.JobId=JobMedia.JobId AND Job.JobTDate<1382281720"
> 
> Now, it's possible that the timing of the volume being initialized is
> just coincidental with these queries.  The second query above has what
> appears to be a timestamp that's approximately 180 days ago (which is
> our overall retention period), so I assume it has something to do with
> volume recycling.
> 
> Any thoughts here?  Any pointers that the Bacula gurus here want to pass
> along, that might help me figure out what's going on?  Honestly, I'm not
> sure what the right questions to ask are, let alone what config
> information to share with you, etc.

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.


> For reference, this is on a RHEL 6.4 server with a couple of 8-core Ivy
> Bridge EP processors, about 128 GB of RAM, and about 75 TB of disk.
> Bacula version 5.2.13.

Are the tables in MyISAM or InnoDB format?

__Martin

------------------------------------------------------------------------------
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