mysql delete slow

 

LOW_PRIORITY
Optional. If LOW_PRIORITY is provided, the delete will be delayed until there are no processes reading from the table. LOW_PRIORITY may be used with MyISAM, MEMORY and MERGE tables that use table-level locking.

QUICK
Optional. If QUICK is provided, ndex leaves are not merged during the delete making the deletion faster for MyISAM tables.

 

 

 

Creative Commons license icon Creative Commons license icon