Deleting from a table with over 22 Million Rows.
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.
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.