Hi, I have a somewhat pressing problem with the performance of my Bacula installation.
My MySQL database currently holds 247,342,127 (36GB) records in the File table, and 78,576,199 (10GB) records in the Filename table. Since 3.0.0, but even more since 3.0.1, I have a problem with queries being really slow. Basically when doing a full backup of a server (mailserver, LOTS of small files), I can have my MySQL hanging for up to 24+ hours on queries like this: INSERT INTO Filename( Name ) SELECT a.Name FROM ( SELECT DISTINCT Name FROM batch ) AS a WHERE NOT EXISTS ( SELECT Name FROM Filename AS f WHERE f.Name = a.Name ) with the status "Sending data", and a lot of other similar queries in queue with the status "Locked". One of these queries take approx 10.000 seconds to execute, but is just followed by another similar (identical) query with the same duration. This is a problem mostly because it prevents me doing restores while backups are "Dir inserting attributes" Obviously I would think it's a MySQL performance issue, but I was wondering if anything had been done to the queries? They seem to be a LOT slower and a LOT heavier. I've just put more RAM into the server, but it's done little to improve the duration of the queries. My server now has 4GB RAM (will update to 6GB) - but again it's a recent issue, because Bacula has been running perfectly for many months on 2GB RAM, until I updated to 3.0.1 I've done REPAIR TABLE and OPTIMIZE TABLE and seen no improvement. Finally if anyone have any specific ideas to improve performance on my huge SQL database, please share :) Thanks -- Tom ------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users