Re: MySQL 8 Windows Deletion Performance Improvement?

[Randy Smith]

Sure! What is "Explain"?

key_buffer_size=8M
read_buffer_size=64K
read_rnd_buffer_size=256K

NOTE: The "key" on the temp_roles table did not exist when I posted this nor when I tried this, it is being created now (and it takes a long time for that):

CREATE TABLE `roles` (
`job_id` varchar(255) NOT NULL,
`role` varchar(255) NOT NULL,
`modify_timestamp` timestamp NULL DEFAULT NULL,
KEY `idx_job_id` (`job_id`) USING BTREE,
KEY `idx_role` (`role`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `temp_roles` (
`job_id` varchar(255) NOT NULL,
`role` varchar(255) NOT NULL,
`modify_timestamp` timestamp NULL DEFAULT NULL,
KEY `idxRolesJobID` (`job_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;