Delete slow as not using index
I have a very big 600G MyISAM table. Its structure is simple as 7 columns, first 5 are indexes, and last two are blob.
After migrated to MySQL 8.0, the deletion runs 20 times slower than 5.0.96. There are about 50% data to purge daily.
The select with same condition works with index well, but deletion not using index.
Can any guru here help me out?
Subject
Views
Written By
Posted
Delete slow as not using index
517
February 16, 2023 11:30PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.