Locking a table and disabling the indexes hangs mysql - 100% CPU
1
vote
1
answer
204
views
CREATE TABLE
runs
(
RunID
int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (RunID
)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table runs
--
-- WHERE: runid=430864838
LOCK TABLES runs
WRITE;
ALTER TABLE runs
DISABLE KEYS;
INSERT INTO runs
VALUES (430864838);
As soon as TABLE runs
DISABLE KEYS;
runs it seems to hang the database - a core is 100% being used and it will not respond.
What is the cause of this behavior?
Asked by Chris Stryczynski
(173 rep)
Feb 8, 2018, 10:56 AM
Last activity: Jul 20, 2025, 11:00 PM
Last activity: Jul 20, 2025, 11:00 PM