>>>>> On Fri, 13 Apr 2007 18:07:25 -0600, Michael FIG said: > > Hi, all... > > I have Bacula 1.38.11-5ubuntu1 installed. > > Just recently, I believe our Bacula setup hit its first year > anniversary, and so now our 365 day volume retention period goes into > effect. > > It now takes a long time (several minutes) to complete a "status dir" > command. To try to speed it up, I've run "myisamchk -o *.MYI" on all > the Bacula tables on our MySQL server. I've also added the following > indices (based on watching what queries bacula-dir was issuing via > MySQLAdmin): > > mysql> alter table File ADD INDEX(JobId); > Query OK, 2679492 rows affected (59.59 sec) > Records: 2679492 Duplicates: 0 Warnings: 0 > > mysql> alter table JobMedia ADD INDEX(MediaId); > Query OK, 13895 rows affected (0.15 sec) > Records: 13895 Duplicates: 0 Warnings: 0 > > mysql> > > This has helped a little, but I'm wondering if there's anything else > that I can do to make it snappier.
It depends on the size of the database. You could try setting log_slow_queries and long_query_time in your my.cnf to see which queries are causing the problems. > My second question is that I just noticed "*unknown*" being returned for > the volume on the scheduled jobs. Is this normal? I don't remember > seeing this before. It means that Bacula can't find an appendable volume in the pool for that job at the time you ran the status command. It only prunes based on the current time, so this will not be problem if there is volume available when the job actually runs. There was also a bug in the status command which would show the wrong results for jobs using a storage override in the schedule. __Martin ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
