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. 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. Here is the output I get from running bconsole. # bconsole Connecting to Director bacula-dir:9101 1000 OK: bacula-dir Version: 1.38.11 (28 June 2006) Enter a period to cancel a command. *status dir Using default Catalog name=MyCatalog DB=bacula bacula-dir Version: 1.38.11 (28 June 2006) i486-pc-linux-gnu debian testing/unstable Daemon started 13-Apr-07 17:40, 0 Jobs run since started. Scheduled Jobs: Level Type Pri Scheduled Name Volume =================================================================================== Differential Backup 10 13-Apr-07 22:05 server1 *unknown* Full Backup 10 13-Apr-07 22:05 server2 *unknown* Full Backup 10 13-Apr-07 22:05 server3 *unknown* [...] Full Backup 10 13-Apr-07 22:05 client1 *unknown* Differential Backup 10 13-Apr-07 22:05 client2 *unknown* Full Backup 10 13-Apr-07 22:05 client3 *unknown* [...] ==== Running Jobs: No Jobs running. ==== No Terminated Jobs. ==== * Thanks for any help you can offer, -- Michael FIG <[EMAIL PROTECTED]>, PMP MarkeTel Multi-Line Dialing Systems, Ltd. Phone: (306) 359-6893 ext. 528 ------------------------------------------------------------------------- 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