MySQL Forums
Forum List  »  General

Deleting from a table with over 22 Million Rows.
Posted by: Andrew Rosolino
Date: January 22, 2007 07:05AM

I have a table on my server with over 22 Million Rows, and I actually need to clear about 21 Million of them. When I run the query it seems as if its going to run for days so I stop it. I have never tuned mysql on this server, is there any variables that will affect the speed of a MySQL delete.

Options: ReplyQuote


Subject
Written By
Posted
Deleting from a table with over 22 Million Rows.
January 22, 2007 07:05AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.