Re: MySQL 8 Windows Deletion Performance Improvement?

[Peter Brawley]

That query will probably run faster as a Join, also with a Where clause limiting rows than with Limit, eg ...

delete a from roles a
join temp_roles b using(job_id)
where job_id between ...;

Once you find the largest chunk size that maintains performance, wrote an sproc or PHP script that chunks it automatically.

If it's me, I make InnoDB versions, test, and move to InnoDB if I can tune InnoDB to get better performance with innodb_buffer_pool_size=6G and key_buffer_size at a minimum..



Edited 1 time(s). Last edit at 01/15/2020 12:44PM by Peter Brawley.