Sample Header Ad - 728x90

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