MYSQL Delete performance Optimization!

Optimization Items 1,

Low_priority The delete operation occurs when the article table is not connected.

Delete low_priority from T;

Optimization Items 2,

Quick when a row is deleted, the index is not deleted, and the index can be reused if it is inserted again, or when it is similar.

Delete quick from T;

Benefits: Quick, how to say also less delete some things, so fast.

Cons: If the line is no longer inserted, there is no way to reuse the space in the index.

Example: Auto_increment, because each time increments, so there is no way to reuse. Of course

can also be changed by ALTER TABLE table_name auto_increment = value; Http://www.cnblogs.com/JiangLe/p/4008607.html

Optimization Items 3,

Limit controls the size of a transaction, and if the DELETE statement includes an ORDER BY clause, the rows are deleted in the order specified in the clause.

Delete from T limit 2;

MYSQL Delete performance Optimization!