Debian Codegraph @

mysql-test/suite/innodb/r/innodb_stats_drop_locked.result

raw
1 Table Op Msg_type Msg_text
2 test.innodb_stats_drop_locked analyze status OK
3 SET autocommit=0;
4 SELECT table_name FROM mysql.innodb_table_stats
5 WHERE table_name='innodb_stats_drop_locked'
6 FOR UPDATE;
7 table_name
8 innodb_stats_drop_locked
9 SELECT table_name FROM mysql.innodb_index_stats
10 WHERE table_name='innodb_stats_drop_locked'
11 FOR UPDATE;
12 table_name
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;
21 Warnings:
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;
24 Table Create Table
25 innodb_stats_drop_locked CREATE TABLE `innodb_stats_drop_locked` (
26 `c` int DEFAULT NULL
27 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci STATS_PERSISTENT=1
28 DROP TABLE innodb_stats_drop_locked;
29 SHOW TABLES;
30 Tables_in_test
31 COMMIT;
32 SELECT table_name FROM mysql.innodb_table_stats
33 WHERE table_name='innodb_stats_drop_locked';
34 table_name
35 innodb_stats_drop_locked
36 SELECT table_name FROM mysql.innodb_index_stats
37 WHERE table_name='innodb_stats_drop_locked';
38 table_name
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
46 SET autocommit=1;