MySQL Forums
Forum List  »  MyISAM

Re: MySQL 8 Windows Deletion Performance Improvement?
Posted by: Randy Smith
Date: January 14, 2020 03:44PM

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;

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL 8 Windows Deletion Performance Improvement?
140
January 14, 2020 03:44PM


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.