MySQL Forums
Forum List  »  MyISAM

Re: MySQL 8 Windows Deletion Performance Improvement?
Posted by: Randy Smith
Date: January 15, 2020 07:13AM

Here's the EXPLAIN query I used, basically taking the last one I did that failed and adding EXPLAIN to the front. I had EXPLAIN EXTENDED but it told me extended was not allowed:

EXPLAIN delete from paytrak.roles where job_id in (select job_id from paytrak.temp_roles) LIMIT 100;

Yes, these records are all for lookup only, nothing is being written except when we update the database with fresh data.

Upon adding that index to the TEMP, things are going much faster, MUCH faster, but I still think they could be increased more.

You say a quarter of RAM should go to that buffer? So, since I have 8G, this should be 2G?

Thank you, RLS

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL 8 Windows Deletion Performance Improvement?
542
January 15, 2020 07:13AM


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.