Hi,

I've reported before that we've had very slow restores, due to the time taken
to build the file tree for the console -- which is about 20+ minutes.

http://adsm.org//lists/html/Bacula-users/2010-11/msg00000.html

I've been looking at this again, particularly at a bug that had some
interesting debugging and at the FAQ page.  

http://wiki.bacula.org/doku.php?id=faq#restore_takes_a_long_time_to_retrieve_sql_results_from_catalog
http://bugs.bacula.org/view.php?id=1472

I don't recall seeing this detail before, but there is a suggestion to
removing additional indexes.  These are the indexes on our File table.

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         |   
 64154092 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | PathId      |            1 | PathId      | A         |   
   812077 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | FilenameId  |            1 | FilenameId  | A         |   
  2673087 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | FilenameId  |            2 | PathId      | A         |   
 12830818 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | JobId       |            1 | JobId       | A         |   
     1484 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | JobId       |            2 | PathId      | A         |   
  3207704 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | JobId       |            3 | FilenameId  | A         |   
 64154092 |     NULL | NULL   |      | BTREE      |         |
| File  |          1 | jobid_index |            1 | JobId       | A         |   
     1484 |     NULL | NULL   |      | BTREE      |         |
+-------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
8 rows in set (0.01 sec)

It looks to me like I should remove the indexes "PathId" and "FilenameID",
leaving the PRIMARY, JobId and jobid_index.  Does that seem correct?

Gavin


------------------------------------------------------------------------------
Got Input?   Slashdot Needs You.
Take our quick survey online.  Come on, we don't ask for help often.
Plus, you'll get a chance to win $100 to spend on ThinkGeek.
http://p.sf.net/sfu/slashdot-survey
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users