Re: [Bacula-users] Problem Restoration

[Philippe MULLER]

Christoph Haas a écrit : On Wednesday 26 October 2005 09:19, Philippe MULLER wrote: I'm running bacula on Gentoo. I'm using mysql. The problem is easy to desribe : I'm backing up a fileserver (40 Go) and the database make 40 Mo. But, when i restore a file (for a user) with bconsole, it take very very long time... and the server has a load average 1,5 ! What can i make to optimize the restoration ? That has just been discussed in a thread two notches above. :) See if your "File" table has proper indices. I have screwed down the time to build up the directory tree from 15 minutes to 10 seconds now. Christoph Mine show this: mysql> show index 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         |      801793 |     NULL | NULL   |      | BTREE      |         | | File  |          1 | JobId      |            1 | JobId       | A         |        NULL |     NULL | NULL   |      | BTREE      |         | | File  |          1 | PathId     |            1 | PathId      | A         |        NULL |     NULL | NULL   |      | BTREE      |         | | File  |          1 | FilenameId |            1 | FilenameId  | A         |        NULL |     NULL | NULL   |      | BTREE      |         | +-------+------------+------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ 4 rows in set (0.00 sec) Is there a problem ? Philippe