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?
> 

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

Please post the result. Thanks in advance!

-- 
Kind regards
Christoph
________________________________________________________________________
Christoph Litauer                  litauer AT uni-koblenz DOT de
Uni Koblenz, Computing Center,     http://www.uni-koblenz.de/~litauer
Postfach 201602, 56016 Koblenz     Fon: +49 261 287-1311, Fax: -100 1311
PGP-Fingerprint: F39C E314 2650 650D 8092 9514 3A56 FBD8 79E3 27B2


------------------------------------------------------------------------------
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