Hi, 27.11.2008 14:15, Boris Kunstleben onOffice Software GmbH wrote: ... > @Arno > i'm not that good in mysql, but i already tuned mysql und set some new > indexes, see below: > mysql> show index from File;
Actually, my suggestion was to *remove* indexes; updating an index when adding new data needs additional time. If you update less indexes, you save that time. So, remove some of those... but do this carefully, as many other operations will really suffer if the indexes required are not available. > +-------+------------+----------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ > | 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 > | 15544061 | NULL | NULL | | BTREE | | > | File | 1 | JobId | 1 | JobId | A > | 74 | NULL | NULL | | BTREE | | > | File | 1 | PathId | 1 | PathId | A > | 1195697 | NULL | NULL | | BTREE | | > | File | 1 | FilenameId | 1 | FilenameId | A > | 5181353 | NULL | NULL | | BTREE | | > | File | 1 | FilenameId | 2 | PathId | A > | 7772030 | NULL | NULL | | BTREE | | > | File | 1 | JobId_2 | 1 | JobId | A > | 74 | NULL | NULL | | BTREE | | > | File | 1 | JobId_2 | 2 | PathId | A > | 1943007 | NULL | NULL | | BTREE | | > | File | 1 | JobId_2 | 3 | FilenameId | A > | 15544061 | NULL | NULL | | BTREE | | The following two indexes seem to be duplicates of pre-existing ones. ... Arno -- Arno Lehmann IT-Service Lehmann Sandstr. 6, 49080 Osnabrück www.its-lehmann.de ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
