1
Table Op Msg_type Msg_text
2
test.innodb_stats_drop_locked analyze status OK
4
SELECT table_name FROM mysql.innodb_table_stats
5
WHERE table_name='innodb_stats_drop_locked'
8
innodb_stats_drop_locked
9
SELECT table_name FROM mysql.innodb_index_stats
10
WHERE table_name='innodb_stats_drop_locked'
13
innodb_stats_drop_locked
14
innodb_stats_drop_locked
15
innodb_stats_drop_locked
16
innodb_stats_drop_locked
17
innodb_stats_drop_locked
18
innodb_stats_drop_locked
19
innodb_stats_drop_locked
20
ALTER TABLE innodb_stats_drop_locked DROP INDEX c_key;
22
Warning 1205 Unable to delete statistics for index c_key from mysql.innodb_index_stats because the rows are locked: Lock wait timeout. They can be deleted later using DELETE FROM mysql.innodb_index_stats WHERE database_name = 'test' AND table_name = 'innodb_stats_drop_locked' AND index_name = 'c_key';
23
SHOW CREATE TABLE innodb_stats_drop_locked;
25
innodb_stats_drop_locked CREATE TABLE `innodb_stats_drop_locked` (
26
`c` int(11) DEFAULT NULL
27
) ENGINE=InnoDB DEFAULT CHARSET=latin1 STATS_PERSISTENT=1
28
DROP TABLE innodb_stats_drop_locked;
32
SELECT table_name FROM mysql.innodb_table_stats
33
WHERE table_name='innodb_stats_drop_locked';
35
innodb_stats_drop_locked
36
SELECT table_name FROM mysql.innodb_index_stats
37
WHERE table_name='innodb_stats_drop_locked';
39
innodb_stats_drop_locked
40
innodb_stats_drop_locked
41
innodb_stats_drop_locked
42
innodb_stats_drop_locked
43
innodb_stats_drop_locked
44
innodb_stats_drop_locked
45
innodb_stats_drop_locked