Re: [Bacula-users] Database performance issues

2011-06-09 Thread Gavin McCullagh
Hi, On Wed, 08 Jun 2011, Jérôme Blion wrote: > What tool do you use to perform restore ? > I had such issues with BAT... With Webacula, I am not able to reproduce > this behaviour. > Perhaps a bad query which does not use an index. This conversation is not original. We had a discussion about i

Re: [Bacula-users] Database performance issues

2011-06-09 Thread Uwe Schuerkamp
Hi folks, I've been following the mysql vs. postgres vs. different mysql versions discussion which has been very interesting. Has anyone tried "Drizzle" as a bacula db backend? It's supposed to be a lot leaner than mysql, just wondering. All the best, Uwe -- NIONEX ist ein Unternehmen der

Re: [Bacula-users] Database performance issues

2011-06-08 Thread Gavin McCullagh
Hi, On Wed, 08 Jun 2011, Jérôme Blion wrote: > What tool do you use to perform restore ? bconsole: restore 5 (Select the most recent backup for a client) choose host then building directory tree takes ages. > I had such issues with BAT... With Webacula, I am not able

Re: [Bacula-users] Database performance issues

2011-06-08 Thread Phil Stracchino
On 06/08/11 13:45, Jérôme Blion wrote: > I had such issues with BAT... With Webacula, I am not able to reproduce > this behaviour. Very interesting. > Perhaps a bad query which does not use an index. Definitely worth study. -- Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71

Re: [Bacula-users] Database performance issues

2011-06-08 Thread Masopust, Christian
> > > > There are a few options to solve this > > > > - use innodb for the tables in MySQL > > - migrate to PostgreSQL > > anybody already did a successfull migration from MySQL to PostgreSQL? and willing to share a procedure? is it really possible to migrate the complete catalog? thanks, chr

Re: [Bacula-users] Database performance issues

2011-06-08 Thread Jérôme Blion
Le 08/06/2011 19:16, Gavin McCullagh a écrit : > On Wed, 08 Jun 2011, Jérôme Blion wrote: > >> You will see performance improvements if you have lot of concurrents >> updates. > I don't imagine concurrent updates are really an issue for us. Our backups > run fast enough generally for our purposes

Re: [Bacula-users] Database performance issues

2011-06-08 Thread Gavin McCullagh
On Wed, 08 Jun 2011, Jérôme Blion wrote: > You will see performance improvements if you have lot of concurrents > updates. I don't imagine concurrent updates are really an issue for us. Our backups run fast enough generally for our purposes . I daresay they could be faster, but they're not cau

Re: [Bacula-users] Database performance issues

2011-06-08 Thread Gavin McCullagh
Hi, On Wed, 08 Jun 2011, Jérôme Blion wrote: > > Assuming that version of MySQL, do you know if the case for InnoDB vs > > MyISAM is still as cut and dry? Would we likely see substantial > > performance improvements? > > You will see performance improvements if you have lot of concurrents > u

Re: [Bacula-users] Database performance issues

2011-06-08 Thread Phil Stracchino
On 06/08/11 12:16, Gavin McCullagh wrote: > For simplicity of operation and patching, we're using the Ubuntu archive > packages which are MySQL 5.1.41. I realise that's quite old now. There > are one or two restores in particular which take a long time (like 30 > minutes) to build the restore tre

Re: [Bacula-users] Database performance issues

2011-06-08 Thread Phil Stracchino
On 06/08/11 11:44, Jérôme Blion wrote: > On Wed, 08 Jun 2011 10:50:58 -0400, Phil Stracchino > wrote: >> The very first thing I would do would be upgrade to MySQL 5.5.[current] >> (5.5.13, right now) if you're not already using 5.5, making sure it's >> properly configured (hint: look at the new c

Re: [Bacula-users] Database performance issues

2011-06-08 Thread Jérôme Blion
Le 08/06/2011 18:16, Gavin McCullagh a écrit : > Hi, > > On Wed, 08 Jun 2011, Phil Stracchino wrote: > >> The very first thing I would do would be upgrade to MySQL 5.5.[current] >> (5.5.13, right now) if you're not already using 5.5, making sure it's >> properly configured (hint: look at the new c

Re: [Bacula-users] Database performance issues

2011-06-08 Thread Gavin McCullagh
Hi, On Wed, 08 Jun 2011, Phil Stracchino wrote: > The very first thing I would do would be upgrade to MySQL 5.5.[current] > (5.5.13, right now) if you're not already using 5.5, making sure it's > properly configured (hint: look at the new configuration directive > innodb_buffer_pool_instances),

Re: [Bacula-users] Database performance issues

2011-06-08 Thread Jérôme Blion
On Wed, 08 Jun 2011 10:50:58 -0400, Phil Stracchino wrote: > The very first thing I would do would be upgrade to MySQL 5.5.[current] > (5.5.13, right now) if you're not already using 5.5, making sure it's > properly configured (hint: look at the new configuration directive > innodb_buffer_pool_in

Re: [Bacula-users] Database performance issues

2011-06-08 Thread Phil Stracchino
On 06/08/11 08:06, Enrico van Goor wrote: > Hi All, > > We have a setup with bacula-dir/MySQL and bacula-sd (2 servers) and a > SAN connected via fiber. We are running bacula with about 250 jobs a > day. The table File is about 500M records with a size of about 100G. We > use batch insert. All ta

[Bacula-users] Database performance issues

2011-06-08 Thread Enrico van Goor
Hi All, We have a setup with bacula-dir/MySQL and bacula-sd (2 servers) and a SAN connected via fiber. We are running bacula with about 250 jobs a day. The table File is about 500M records with a size of about 100G. We use batch insert. All tables are MyISAM. Currently we are experiencing perform