The time required to delete individual rows is exactly
proportional to the number of indexes. To delete rows more
quickly, you can increase the size of the key cache by
system variable. See Section 7.5.3, “Tuning Server Parameters”.
To delete all rows from a table,
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 12.2.10, “
TRUNCATE TABLE Syntax”.