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

2011-10-05 Thread Uwe Schuerkamp
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.

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

2011-10-05 Thread Phil Stracchino
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

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

2011-10-05 Thread Rory Campbell-Lange
On 5 Oct 2011, at 14:23, Phil Stracchino ala...@metrocast.net wrote: 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

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

2011-10-05 Thread Uwe Schuerkamp
On Wed, Oct 05, 2011 at 02:37:37PM +0100, Rory Campbell-Lange wrote: I've been using non-batch insertion with postgres (following your dare, I think, Phil) for about a year. Backups are only about 8TB, but it works extremely well for us. Hi folks, thanks for your recommendations and

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

2011-10-05 Thread Phil Stracchino
On 10/05/11 10:25, Uwe Schuerkamp wrote: On Wed, Oct 05, 2011 at 02:37:37PM +0100, Rory Campbell-Lange wrote: I've been using non-batch insertion with postgres (following your dare, I think, Phil) for about a year. Backups are only about 8TB, but it works extremely well for us. Hi

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

2011-10-05 Thread Phil Stracchino
On 10/05/11 09:37, Rory Campbell-Lange wrote: I've been using non-batch insertion with postgres (following your dare, I think, Phil) for about a year. Backups are only about 8TB, but it works extremely well for us. So, I just built bacula-5.1.14 from git, with batch disabled. And we'll see

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

2011-10-05 Thread Ben Walton
Excerpts from Phil Stracchino's message of Wed Oct 05 14:51:57 -0400 2011: Hi Phil, Side note: It was unreasonably difficult to get it built correctly on Solaris 10. I couldn't get a working 64-bit build at all, either with gcc or with Sun Studio, and the only way I could get a correctly

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

2011-10-05 Thread Phil Stracchino
On 10/05/11 15:14, Ben Walton wrote: Excerpts from Phil Stracchino's message of Wed Oct 05 14:51:57 -0400 2011: Hi Phil, Side note: It was unreasonably difficult to get it built correctly on Solaris 10. I couldn't get a working 64-bit build at all, either with gcc or with Sun Studio, and

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

2011-10-05 Thread Ben Walton
Excerpts from Phil Stracchino's message of Wed Oct 05 15:26:06 -0400 2011: I've been trying, but have yet to succeed. I think it would probably be a lot simpler if Solaris 10 came in all-32-bit and all-64-bit flavors, instead of the hybrid mixture of 32-bit and 64-bit it is at present. I'd

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

2011-10-05 Thread Phil Stracchino
On 10/05/11 15:54, Ben Walton wrote: What mysql are you building against? The included one? More to the point, which compiler was it built with? MySQL 5.5.8, Solaris 10 package from Oracle. Need to update that actually. -- Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607,