8.2.4.3 Optimizing DELETE Statements
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 key_buffer_size
system variable. See Section 5.1.1, “Configuring the Server”.
To delete all rows from a MyISAM
table, TRUNCATE TABLE
is faster than tbl_name
DELETE FROM
. Truncate 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.34, “TRUNCATE TABLE Statement”. tbl_name