On 23/02/11 18:01, Daniel Etter wrote:
> 2011/2/23 Erik P. Olsen<epodata AT gmail DOT com>:
>> Backup is swift so I don't understand why building of directory trees should
>> take so long time. When the directory trees have been build, the restore is 
>> as
>> swift as the backup.
>>
>> I suspect problems with the mysql database but have no idea of what I
>> could/should do to correct the problem.
>
> I did have the same problem some days before. I googled around about
> mysql performance and found
> the following solution:
>
> You should optimize from time to time the mysql-db.
>
> I have scheduled now dayli the follwing command:
>
> /usr/bin/mysqlcheck -Aao
>
> Now the directory tree is build fast enough.

Thanks for the tip but unfortunately it didn't change anything when it comes to 
speed. I ran "sudo mysqlcheck -Aaov" and got among apparently normal messages 
the following surfaced:

note     : The storage engine for the table doesn't support optimize

Does this mean that nothing has been optimised?

-- 
Erik

------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in 
Real-Time with Splunk. Collect, index and harness all the fast moving IT data 
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business 
insights. http://p.sf.net/sfu/splunk-dev2dev 
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users