------------------------------- Matija,
Thanks for the reply! I read through that, and looked at my indexes on the File table and it doesn't appear as if I have superfluous indexes. The doc mentions: "you need to drop all the indexes from File table except the primary key and indexes on (`JobId`,`PathId`,`FilenameId`) and (`JobId`)" However, unless I am missing something, those are all my indexes: 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 | 9241817 | NULL | NULL | | BTREE | | | File | 1 | JobId | 1 | JobId | A | 9241817 | NULL | NULL | | BTREE | | | File | 1 | JobId_2 | 1 | JobId | A | 9241817 | NULL | NULL | | BTREE | | | File | 1 | JobId_2 | 2 | PathId | A | 9241817 | NULL | NULL | | BTREE | | | File | 1 | JobId_2 | 3 | FilenameId | A | 9241817 | NULL | NULL | | BTREE | | +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+ 5 rows in set (0.00 sec) (Apologies for the wide lines...) Jason > On Tue, Apr 20, 2010 at 10:38:27AM -0600, Jason Hill wrote: > > I am at my wit's end on this one, and I am hoping someone has had this > > problem already. > > > > I am running the following: > > > > RHEL 5.5 (client, or workstation) > > Bacula 5.0.1 > > MySQL 5.1 > > > > > > My problem is that when I attempt a restore for a large backup bacula > > hangs on the "Building directory tree...". > > Yes. See: > http://wiki.bacula.org/doku.php?id=faq#restore_takes_a_long_time_to_retrieve_ > sql_results_from_mysql_catalog > > (or http://tinyurl.com/y6334ht if your MUA breaks the link) > ------------------------------- Jason ------------------------------------------------------------------------------ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
