Re: [Bacula-users] restore performance

[Novosielski, R. <nov...@um...>]

I would say it depends on your read of that article and either way whether or not you believe it. I'm not quite sure what to think. I believe I will re-add the indices I dropped and see what happens. 



----- Original Message -----
From: Uwe Schuerkamp [mailto:uwe...@ni...]
Sent: Tuesday, January 15, 2013 10:32 AM
To: Novosielski, Ryan
Cc: John Drescher <dre...@gm...>; bacula-users <Bac...@li...>
Subject: Re:  [Bacula-users] restore performance

On Mon, Jan 14, 2013 at 09:01:32AM -0500, Novosielski, Ryan wrote:

> > http://wiki.bacula.org/doku.php?id=faq#restore_takes_a_long_time_to_retrieve_sql_results_from_mysql_catalog
> 
> Actually,
> > 
> after re-reading that, I'm a little confused. I don't know
> whether it says to "drop all indexes except for primary and then drop
> the listed indices" or "drop everything except for primary and except
> for the listed indices."
> 
> In any case, this solved the problem for me. I wonder if a repair
> would have also and maybe that's why?
> 

I have the following indexes defined on the "File" table: 

MariaDB [bacula]> show indexes in File ; 
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name |
Collation | Cardinality | Sub_part | Packed | Null | Index_type |
Comment | Index_comment |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| File  |          0 | PRIMARY  |            1 | FileId      | A
|   947714927 |     NULL | NULL   |      | BTREE      |         |
|
| File  |          1 | JobId    |            1 | JobId       | A
|        2513 |     NULL | NULL   |      | BTREE      |         |
|
| File  |          1 | JobId_2  |            1 | JobId       | A
|        2513 |     NULL | NULL   |      | BTREE      |         |
|
| File  |          1 | JobId_2  |            2 | PathId      | A
|    30571449 |     NULL | NULL   |      | BTREE      |         |
|
| File  |          1 | JobId_2  |            3 | FilenameId  | A
|   947714927 |     NULL | NULL   |      | BTREE      |         |
|
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
5 rows in set (0.00 sec)

MariaDB [bacula]> select count(*) from File ; 
+-----------+
| count(*)  |
+-----------+
| 947749966 |
+-----------+
1 row in set (0.00 sec)

So it seems I'm more or less in the clear regarding our index setup,
or am I missing something? 

Cheers & thanks in advance, Uwe