Hey all, Trying to clean out a huge database that I cloned from our production server (~100Gb).
It looks like we're deleting about 5.3 million messages that we've managed to amass over the last year or so in the database. I'm coming into this project with the goal of updating and speeding up our dbmail instances. Right now I'm stuck at an error that I get when I run dbmail-util -t Basically I get the messages: Checking DBMAIL message integrity... Checking DBMAIL physmessage integrity... Ok. Found [0] unconnected physmessages. Checking DBMAIL partlists integrity... Ok. Found [0] unconnected partlists. Checking DBMAIL mimeparts integrity... Ok. Found [0] unconnected mimeparts. Checking DBMAIL headernames integrity... Ok. Found [0] unconnected headernames. Checking DBMAIL headervalues integrity... DATE SERVERNAME dbmail-util[12351]: [0x93dc008] Warning:[db] log_query_time(+299): slow query [SELECT hv.id FROM dbmail_headervalue hv LEFT JOIN dbmail_header h ON hv.id = h.headervalue_id WHERE h.headervalue_id IS NULL] took [79.420] seconds After I get the warning, dbmail-util sits there until it's killed or gives some killed message but that takes an inordinate amount of time. I left it running over the weekend last week and it only got kill on Tuesday at some point. Has anyone else seen this type of behaviour and can anyone give any pointers on where to go from here? A similar thing happens when running dbmail-util -b Thanks for your time.
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
