OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Make delete requests without impact on a database

From: David Florella (dflorellalegos.fr)
Date: Wed Apr 14 2010 - 08:08:24 CDT

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.