Re: [Bacula-users] restore / slow directory tree build process on 5.0.x / mysql

2010-07-19 Thread Nick Hilliard
On 19/07/2010 12:33, Dan Langille wrote: > You are probably missing an index. I'm pretty sure this has been discussed > previously on this list. Sorry, I don't know which index is missing but I'm > pretty sure it will be easy to find with a search. I did look back over the list for a couple of mon

Re: [Bacula-users] restore / slow directory tree build process on 5.0.x / mysql

2010-07-19 Thread Eric Bollengier
Hello Nick, This issue has been discussed few months ago, you can get advise by searching on mailing list or on the wiki. http://wiki.bacula.org/doku.php?id=faq#restore_takes_a_long_time_to_retrieve_sql_results_from_mysql_catalog Bye Le lundi 19 juillet 2010 13:04:23, Nick Hilliard a écrit : > O

Re: [Bacula-users] restore / slow directory tree build process on 5.0.x / mysql

2010-07-19 Thread Dan Langille
On 7/19/2010 7:04 AM, Nick Hilliard wrote: > On 16/07/2010 16:48, Nick Hilliard wrote: >>> ++---+--++-+-+ >>> | JobId | Level | JobFiles | JobBytes | StartTime | >>> VolumeName | >>> +

Re: [Bacula-users] restore / slow directory tree build process on 5.0.x / mysql

2010-07-19 Thread Nick Hilliard
On 16/07/2010 16:48, Nick Hilliard wrote: >> ++---+--++-+-+ >> | JobId | Level | JobFiles | JobBytes | StartTime | >> VolumeName | >> ++---+--++

[Bacula-users] restore / slow directory tree build process on 5.0.x / mysql

2010-07-16 Thread Nick Hilliard
Hello, something's gone badly wrong with the directory tree rebuild sql query on 5.0.x. I'm currently attempting to restore a single file from a disk backup I made recently: here's the output: > ++---+--++-+-+ > | J