Re: [Bacula-users] 7.2 mysql issue?

2015-10-14 Thread Stephen Thompson
Yes, we've tuned the database a number of times and believe it's the best we can do. On 10/14/15 3:17 AM, Alex Domoradov wrote: > The same thing as for me. I'm trying do not use mysql shipped with > CentOS 6 and replace it with Percona 5.5/5.6 whenever it's possible > > 2 Stephen > Have you

Re: [Bacula-users] 7.2 mysql issue?

2015-10-14 Thread Alan Brown
On 14/10/15 10:49, Uwe Schuerkamp wrote: > > you might also try giving MariaDB a shot which has been performing > fine as a drop-in mysql replacement for us for the last few years with > catalogs of similar size. > Speaking as a mysql affectionado and one who's using both DBs regularly in

Re: [Bacula-users] 7.2 mysql issue?

2015-10-14 Thread Uwe Schuerkamp
On Mon, Oct 12, 2015 at 07:33:46AM -0700, Stephen Thompson wrote: > > update... > > After adding more RAM, we are back to getting a about 3 queries a day > that run longer than 15 minutes. This was our norm before upgrading. > No job errors since the first couple days from this month (Oct).

Re: [Bacula-users] 7.2 mysql issue?

2015-10-14 Thread Alex Domoradov
The same thing as for me. I'm trying do not use mysql shipped with CentOS 6 and replace it with Percona 5.5/5.6 whenever it's possible 2 Stephen Have you tried to run mysqltunner? On Mon, Oct 12, 2015 at 07:33:46AM -0700, Stephen Thompson wrote: > > > > update... > > > > After adding more RAM,