Re: [Bacula-users] Very slow interactive restore

Christoph Litauer wrote:
> Christoph Litauer schrieb:
>> Jesper Krogh schrieb:
>>> Christoph Litauer wrote:
>>>> Thanks! One last question (hopefully): How big is /var/lib/mysql/ibdata1?
>>> 282GB on ext3
>>>
>> Dear Jesper,
>>
>> in the meantime I made a test setup - not successfull 'til now regarding
>> the performance. What I forgot to ask: What mysql-DB version are you
>> running?

Standard Ubuntu Hardy mysql version.

> And another demand, please:
> 
> Could you - or someone else - please select any JobId and execute the
> following (my)sql-statement:
> 
> mysql>EXPLAIN SELECT Path.Path, Filename.Name, File.FileIndex,
> File.JobId, File.LStat
> FROM (
>       SELECT max(FileId) as FileId, PathId, FilenameId
>       FROM (
>               SELECT FileId, PathId, FilenameId
>               FROM File
>               WHERE JobId IN (<insert your JobId here>)
>       ) AS F GROUP BY PathId, FilenameId
> ) AS Temp JOIN Filename ON (Filename.FilenameId = Temp.FilenameId) JOIN
> Path ON (Path.PathId = Temp.PathId) JOIN File ON (File.FileId =
> Temp.FileId) WHERE File.FileIndex > 0 ORDER BY JobId, FileIndex ASC

mysql> EXPLAIN SELECT Path.Path, Filename.Name, File.FileIndex,
File.JobId, File.LStat FROM ( SELECT max(FileId) as FileId, PathId,
FilenameId FROM ( SELECT FileId, PathId, FilenameId FROM File WHERE
JobId IN (32348) ) AS F GROUP BY PathId, FilenameId ) AS Temp JOIN
Filename ON (Filename.FilenameId = Temp.FilenameId) JOIN Path ON
(Path.PathId = Temp.PathId) JOIN File ON (File.FileId = Temp.FileId)
WHERE File.FileIndex > 0 ORDER BY JobId, FileIndex ASC;
+----+-------------+------------+--------+---------------------+---------+---------+-----------------+------+---------------------------------+
| id | select_type | table      | type   | possible_keys       | key
 | key_len | ref             | rows | Extra                           |
+----+-------------+------------+--------+---------------------+---------+---------+-----------------+------+---------------------------------+
|  1 | PRIMARY     | <derived2> | ALL    | NULL                | NULL
 | NULL    | NULL            |   37 | Using temporary; Using filesort |
|  1 | PRIMARY     | Path       | eq_ref | PRIMARY             | PRIMARY
| 4       | Temp.PathId     |    1 |                                 |
|  1 | PRIMARY     | Filename   | eq_ref | PRIMARY             | PRIMARY
| 4       | Temp.FilenameId |    1 |                                 |
|  1 | PRIMARY     | File       | eq_ref | PRIMARY             | PRIMARY
| 4       | Temp.FileId     |    1 | Using where                     |
|  2 | DERIVED     | <derived3> | ALL    | NULL                | NULL
 | NULL    | NULL            |   37 | Using temporary; Using filesort |
|  3 | DERIVED     | File       | ref    | JobId,dump_info_idx | JobId
 | 4       |                 |   37 | Using index                     |
+----+-------------+------------+--------+---------------------+---------+---------+-----------------+------+---------------------------------+
6 rows in set (0.00 sec)



------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users