Hi,
I am using MySQL version 4.1.12-log. All the databases on it are using MyISAM database engine. Every day, I delete almost 90000 rows on a table of 3 153 916 rows. To delete the rows, I use a request like this : "DELETE QUICK FROM [table] WHERE [column] < '2010-04-13 00:00:00' LIMIT 7500". I execute this request until all the rows are delete. This works but when I run the request, I can't access to the database (make INSERT and SELECT requests) during I do the DELETE. How can I do a "DELETE" without impact on INSERT and SELECT requests done on the same time? Regards, David.
