>>>>> On Mon, 6 Nov 2006 09:25:33 +0100, Andras Horvai said: > > I reindexed my tabels, but it seems that it didn't help too much. > Still takes "forever" to prune/purge my volumes. Forever means not > hours but 30 minutes instead of few minutes which was in the past. > What else could I do? This the mysql output of indexing: > > mysql> CREATE INDEX PathIdIdx ON File(PathId); > Query OK, 6390188 rows affected (1 hour 2 min 53.22 sec) > Records: 6390188 Duplicates: 0 Warnings: 0 > > mysql> CREATE INDEX FilenameIdIdx ON File(FilenameId); > Query OK, 6390188 rows affected (1 hour 11 min 47.64 sec) > Records: 6390188 Duplicates: 0 Warnings: 0 > > mysql> CREATE INDEX FileSetIdIdx ON Job(FileSetId); > Query OK, 268 rows affected (0.30 sec) > Records: 268 Duplicates: 0 Warnings: 0 > > mysql> CREATE INDEX ClientIdIdx ON Job(ClientId); > Query OK, 268 rows affected (0.20 sec) > Records: 268 Duplicates: 0 Warnings: 0 > > The configuration: AMD Athlon(tm) 64 Processor 2800+; 512 MB ram; SATA > disks > Kernel: 2.6.8-2; Mysql 4.0.24 > > The database size is around 1 GB.
I suggest looking at the MySQL logs to see which queries are slow: http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html __Martin ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
