On 04/02/2012 06:06 PM, Stephen Thompson wrote:
>
>
> First off, thanks for the response Phil.
>
>
> On 04/02/2012 01:11 PM, Phil Stracchino wrote:
>> On 04/02/2012 01:49 PM, Stephen Thompson wrote:
>>> Well, we've made the leap from MyISAM to InnoDB, seems like we win on
>>> transactions, but lose on read speed.
>>
>> If you're finding InnoDB slower than MyISAM on reads, your InnoDB buffer
>> pool is probably too small.
>
> This is probably true, but I have limited system resources and my File
> table is almost 300Gb large.
Ah, well, sometimes there's only so much you can allocate.
>> --skip-lock-tables is referred to in the mysqldump documentation, but
>> isn't actually a valid option. This is actually an increasingly
>> horrible problem with mysqldump. It has been very poorly maintained,
>> and has barely developed at all in ten or fifteen years.
>>
>
> This has me confused. I have jobs that can run, and insert records into
> the File table, while I am dumping the Catalog. It's only at the
> tail-end that a few jobs get the error above. Wouldn't a locked File
> table cause all concurrent jobs to fail?
Hmm. I stand corrected. I've never seen it listed as an option in the
man page, despite there being one reference to it, but I see that
mysqldump --help does explain it even though the man page doesn't.
In that case, the only thing I can think of is that you have multiple
jobs trying to insert attributes at the same time and the last ones in
line are timing out.
(Locking the table for batch attribute insertion actually isn't
necessary; MySQL can be configured to interleave auto_increment inserts.
However, that's the way Bacula does it.)
Don't know that I have any helpful suggestions there, then... sorry.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years, it's the mileage.
------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
