Re: MySQL 8 Windows Deletion Performance Improvement?

[Randy Smith]

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