MySQL Forums
Forum List  »  MyISAM

Re: MySQL 8 Windows Deletion Performance Improvement?
Posted by: Peter Brawley
Date: January 14, 2020 11:30PM

You say you're doing manual transactions. You're doing no transactions on these tables, they're non-transactional.

Let's see the query for which you showed the Explain result.

If you must stay with MyISAM for some reason, up to a quarter of available RAM should go to key_buffer_size.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL 8 Windows Deletion Performance Improvement?
217
January 14, 2020 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.