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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users