Hi Willy, What is the engine you are using for the table? Paste the table structure. Thanks, Suresh Kuna ------Original Message------ From: Willy Mularto To: [email protected] Subject: High Overhead On Active Insert And Delete Table Sent: Jan 3, 2010 4:22 PM
Hi list, I have a table which is very active in operation INSERT INTO and DELETE, approximately there will be around 2millions INSERT and DELETE operation per day. And I see the overhead is getting very high, I must do OPTIMIZE TABLE query every time. Is there any other option to solve this? TIA. Willy [email protected] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected] Sent from BlackBerry® on Airtel
