Re: [Bacula-users] Properly set indexs for MySQL

2006-03-22 Thread Kern Sibbald
On Wednesday 22 March 2006 11:11, Carlo Agrusti wrote: > I have installed debian packages downloaded from sourceforge (Bacula > 1.36.3-2), which have been packed by the same maintainer of > 1.36.2-2Sarge1, and I have still another index table: > > +---++--+--+---

Re: [Bacula-users] Properly set indexs for MySQL

2006-03-22 Thread Kern Sibbald
Hello, On Wednesday 22 March 2006 10:36, Gavin Conway wrote: > Hi Kern, > > I did notice the difference when looking at the two installs I have > here. Here is the output from the two; > > Debian Sarge 3.1 Bacula 1.36.2 (installed from the debian stable tree) > > +---++

Re: [Bacula-users] Properly set indexs for MySQL

2006-03-22 Thread Carlo Agrusti
I have installed debian packages downloaded from sourceforge (Bacula 1.36.3-2), which have been packed by the same maintainer of 1.36.2-2Sarge1, and I have still another index table: +---++--+--+-+---+-+--++--+

Re: [Bacula-users] Properly set indexs for MySQL

2006-03-22 Thread Gavin Conway
Hi Kern, I did notice the difference when looking at the two installs I have here. Here is the output from the two; Debian Sarge 3.1 Bacula 1.36.2 (installed from the debian stable tree) +---+++--+-+---+-+--+-

Re: [Bacula-users] Properly set indexs for MySQL

2006-03-21 Thread Kern Sibbald
Hello Gavin, I suspect that you might be experiencing some serious performance problems. A more appropriate set of indicies is probably something like what I have: mysql> show indexes from File; +---++--+--+-+---+-+--+

Re: [Bacula-users] Properly set indexs for MySQL

2006-03-21 Thread Gavin Conway
Barry, This may be of some use; mysql> show indexes from File; +---+++--+-+---+-+--++--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Su

[Bacula-users] Properly set indexs for MySQL

2006-03-21 Thread Barry Benowitz
Hi All,   I am starting to notice performance problems on my bacula setup. Some nights it backs up around 25G in 2 Hours, Last night it is still running after 8 hours for the same 25G. Reading the manual told me to check the indexes and I see that there are some set (5 of them) but they d