Re: [Bacula-users] Optimized mysql settings for CentOS 6 64bit

On 10/05/11 05:07, Uwe Schuerkamp wrote:
> Hi folks,
> 
> I'm wondering about the best mysql settings for our new bacula
> installation which will be taking over from an older setup. 
> 
> Current bacula db size is 55G, we have around 14TB backup data from
> ca. 100 clients on disk storage ATM but this is expected to double in
> the next year or so.  the new machine has 6GB memory and reports 12
> CPU cores. The bacula db is stored on an 8-drive RAID 5.
> 
> Backups will be going to an lto 5 library (24 Tapes) and 2 additional
> 16TB RAID devices which have yet to be installed (and I've not thought
> up a good backup strategy yet ;-)
> 
> Would you recommend spooling and using bacula's batch insert in such a
> setup?

I'm actually starting to question the value of batch insert for large
installations, because of the resulting table-level locks.  We're seeing
jobs waiting hours to get their turn to do inserts.  With InnoDB the
default storage engine in MySQL 5.5, I'm wondering whether overall
performance would be better with batch insert disabled and InnoDB
configured to allow interleaved auto-increment IDs.

Unfortunately, all the "enterprise" Linux distributions will probably
still be shipping MySQL 5.1 five years after MySQL 6.0 ships...


-- 
  Phil Stracchino, CDK#2     DoD#299792458     ICBM: 43.5607, -71.355
  alaric AT caerllewys DOT net   alaric AT metrocast DOT net   phil AT 
co.ordinate DOT org
  Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
                 It's not the years, it's the mileage.

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users