Re: [Bacula-users] 7.2 mysql issue?
2015-10-05 13:36:33
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
| 4494348205 | NULL | NULL | | BTREE | |
| File | 1 | JobId | 1 | JobId | A
| 19 | NULL | NULL | | BTREE | |
| File | 1 | JobId | 2 | PathId | A
| 408577109 | NULL | NULL | | BTREE | |
| File | 1 | JobId | 3 | FilenameId | A
| 4494348205 | NULL | NULL | | BTREE | |
+-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
On 10/05/2015 10:30 AM, Stephen Thompson wrote:
>
>
> Phil,
>
> Good question. I vaguely recollect doing that a few years back, but I
> don't immediately see any additional indexing. Where can I reference
> what the default indexes are supposed to be?
>
> thanks,
> Stephen
>
>
>
> On 10/05/2015 10:28 AM, Phil Stracchino wrote:
>> On 10/05/15 13:17, Stephen Thompson wrote:
>>> At any rate, the only thing that's changed was the upgrade from 7.0.5 to
>>> 7.2.0. The table involved is definitely the File table. We do have
>>> jobs with 20-30 million records, so those jobs can be slow when it comes
>>> time for attribute insertion into the database (or to read out a file
>>> list for Accurate backups). This why we've historically had innodb lock
>>> timeout of 3600. However, it's only last week after the upgrade that
>>> we've ever had queries extend beyond that hour mark.
>>
>> Stephen,
>> Just as a thought, there have been a number of threads on this mailing
>> list recommending additional or modified indexes on the File table.
>> Have you added the suggested additional indexes?
>>
>>
>
--
Stephen Thompson Berkeley Seismological Laboratory
stephen AT seismo.berkeley DOT edu 215 McCone Hall # 4760
Office: 510.664.9177 University of California, Berkeley
Remote: 510.214.6506 (Tue,Wed) Berkeley, CA 94720-4760
------------------------------------------------------------------------------
_______________________________________________
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>
|
- [Bacula-users] 7.2 mysql issue?, Stephen Thompson
- Re: [Bacula-users] 7.2 mysql issue?, Ana Emília M. Arruda
- Re: [Bacula-users] 7.2 mysql issue?, Stephen Thompson
- Re: [Bacula-users] 7.2 mysql issue?, Ana Emília M. Arruda
- Re: [Bacula-users] 7.2 mysql issue?, Eric Bollengier
- Re: [Bacula-users] 7.2 mysql issue?, Ana Emília M. Arruda
- Re: [Bacula-users] 7.2 mysql issue?, Eric Bollengier
- Re: [Bacula-users] 7.2 mysql issue?, Stephen Thompson
- Re: [Bacula-users] 7.2 mysql issue?, Eric Bollengier
- Re: [Bacula-users] 7.2 mysql issue?, Stephen Thompson
|
|
|