On 03/02/11 13:18, Kern Sibbald wrote:
> On Wednesday 02 March 2011 18:57:37 Phil Stracchino wrote:
>> 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.
>
> I'll be interested to see what you come up with. Don't forget to do multiple
> simultaneous backups where they are trying to create the same indexes.
> Simply removing a lock can create chaos.
Of course, this would be a lot easier to benchmark if batch update were
a configuration-time, rather than compile-time, option. But, oh well
... I'll do what I can when I find time. I actually suspect that my
recent Bacula performance nosedive isn't anything to do with the DB so
much as that the new, larger disks I added to the array on the server
are increasing the memory required by ZFS to the point that MySQL is
starved for memory.
> Generally catalog performance problems have are caused by either not adapting
> the conf file for the SQL engine to the size of your operation, or someone
> added an index that should not be there. Bacula did this in the past, so you
> should check that your indexes correspond *only* to what Bacula has in the
> latest make_mysql_tables file, as there may be some old indexes left around
> from older scripts.
I'll check that.
--
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
