(mysql.info) delete-speed

Info Catalog

(mysql.info) update-speed

(mysql.info) query-speed

(mysql.info) tips

 
 7.2.18 Speed of `DELETE' Statements
 -----------------------------------
 
 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 increasing the `key_buffer_size' system
 variable. See  server-parameters.
 
 To delete all rows from a table, `TRUNCATE TABLE TBL_NAME' if faster
 than than `DELETE FROM TBL_NAME'. See  truncate.
 

Info Catalog

(mysql.info) update-speed

(mysql.info) query-speed

(mysql.info) tips