Re: [Bacula-users] restore performance
2013-01-15 10:36:16
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
------------------------------------------------------------------------------
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Re: [Bacula-users] restore performance, (continued)
- Re: [Bacula-users] restore performance, Uwe Schuerkamp
- Re: [Bacula-users] restore performance, Novosielski, Ryan
- Re: [Bacula-users] restore performance, John Drescher
- Re: [Bacula-users] restore performance, Uwe Schuerkamp
- Re: [Bacula-users] restore performance, John Drescher
- Re: [Bacula-users] restore performance, Uwe Schuerkamp
- Re: [Bacula-users] restore performance, Novosielski, Ryan
- Re: [Bacula-users] restore performance, Novosielski, Ryan
- Re: [Bacula-users] restore performance,
Uwe Schuerkamp <=
- Re: [Bacula-users] restore performance, Novosielski, Ryan
- Re: [Bacula-users] restore performance, Novosielski, Ryan
- Re: [Bacula-users] restore performance, Jérôme Blion
|
|
|