Bacula-users

Re: [Bacula-users] Extremely long restore times.

2011-02-23 12:07:11
Subject: Re: [Bacula-users] Extremely long restore times.
From: Daniel Etter <daniel AT obastrlx DOT ch>
To: bacula-users AT lists.sourceforge DOT net
Date: Wed, 23 Feb 2011 18:01:34 +0100
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.

regards
Daniel Etter

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