MySQL Forums
Forum List  »  MyISAM

Delete slow as not using index
Posted by: EDGEFREE DU
Date: February 16, 2023 11:30PM

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?

Options: ReplyQuote

Written By
Delete slow as not using index
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.