The time required to delete individual rows in a
MyISAM table is exactly proportional to the
number of indexes. To delete rows more quickly, you can
increase the size of the key cache by increasing the
variable. See Section 5.1.1, “Configuring the Server”.
To delete all rows from a
is faster than
operations are not transaction-safe; an error occurs when
attempting one in the course of an active transaction or
active table lock. See Section 13.1.37, “TRUNCATE TABLE Syntax”.