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, -71

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

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 St

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 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 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. >>

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 an

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 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 around 14TB

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