Barry,
This may be of some use;
mysql> show indexes from File;
+-------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation
| Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+-------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| File | 0 | PRIMARY | 1 | FileId | A | 25687365 | NULL | NULL | | BTREE | |
| File | 1 | FilenameId | 1 | FilenameId | A | 626521 | NULL | NULL | |
BTREE | |
| File | 1 | FilenameId | 2 | PathId | A | 658650 | NULL | NULL | |
BTREE | |
+-------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
3 rows in set (0.00 sec)
mysql>
Regards,
Gavin Conway
Barry Benowitz wrote:
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 don’t seem to have the name mentioned. Would someone using MySQL
post what an appropriate result from a show index from File command
should be?
Thanks,
Barry
Barry Benowitz
Raritan Computer
(732) 764 8886 x1362
[EMAIL PROTECTED]
--
UKS Ltd, Birmingham Road, Studley, Warwickshire, B80 7BG
Tel: 08700 681 333 - Fax: 01527 851 301 - AS: 20547
[EMAIL PROTECTED] - www.uksolutions.co.uk
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
