On 03/02/11 12:29, Kern Sibbald wrote:
> On Tuesday 01 March 2011 14:58:04 Phil Stracchino wrote:
>> 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'.
>
> As far as I know dbcheck does not need indexes and does not create any.
> Perhaps if you explained the context better I could understand.
dbcheck wants a single-field index on PathId over the Path table, and on
FilenameId over the Filename table. It warns that the check will take
much longer if these are not present, and offers to create them if they
are not present ... but only offers to create them temporarily, and
deletes them afterward. Refer to tools/dbcheck.c lines 857-862 and
907-912, or the output of grep -C 5 -i -n index tools/dbcheck.c.
> To the best of my knowledge, Bacula only locks tables during batch insert,
> and
> this is essential. If you want to know how batch insert works (very clever
> and a bit complicated), you can read
> docs/techlogs/batch_insert_documentation.odt.
I think I will do some benchmarking with/without batch insert on InnoDB,
then, and see if I can determine whether it is actually helping or
hurting performance overall if the catalog is 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
