I was looking into what Bacula was doing in the DB this morning, with a
MySQL catalog, to see why last night's backup jobs stalled. As a result
of my investigations, I have two questions:
1.
If dbcheck finds that either of the two indices it needs are missing,
why does it only offer to create temporary indices, instead of offering
to create the indices once and have done with it? Perhaps this could be
a command-line option to dbcheck, 'Create any required indices if not
found'.
2.
Why in the name of little green fishes does Bacula issue explicit table
locks? This might have once been a good idea when MySQL implied MyISAM,
byt MyISAM has been increasingly (if unofficially) deprecated for years.
The general wisdom in MySQL circles is that the answer to "My usage
case is foo, what storage engine should I use?" is "InnoDB" for
essentially all possible values of 'foo', and issuing a 'LOCK TABLE' on
InnoDB is almost without exception a bad idea. Bacula should at least
check what the storage engine is before issuing any table locks. (This
can be checked very quickly on a table-by-table basis by parsing 'SHOW
CREATE TABLE `tablename`'.) I would guess that if there is not a strong
rationale for doing this other than "It was needed on MyISAM", it is
probably badly hurting Bacula catalog throughput on InnoDB.
--
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.
------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in
Real-Time with Splunk. Collect, index and harness all the fast moving IT data
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business
insights. http://p.sf.net/sfu/splunk-dev2dev
_______________________________________________
Bacula-devel mailing list
Bacula-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-devel
