Debian Codegraph @

mysql-test/suite/innodb/t/innodb_stats_drop_locked.test

raw
1 #
2 # Test the persistent stats feature when DROPping a table or an
3 # index when the corresponding rows in the stats tables are locked
4 #
5
6 -- source include/have_innodb.inc
7
8 CREATE DATABASE unlocked;
9 CREATE TABLE unlocked.t1(a INT PRIMARY KEY) ENGINE=INNODB STATS_PERSISTENT=0;
10 CREATE DATABASE locked;
11 CREATE TABLE locked.t1(a INT PRIMARY KEY) ENGINE=INNODB STATS_PERSISTENT=1;
12
13 CREATE TABLE innodb_stats_drop_locked (c INT, KEY c_key (c))
14 ENGINE=INNODB STATS_PERSISTENT=1;
15 ANALYZE TABLE innodb_stats_drop_locked;
16
17 BEGIN;
18 SELECT table_name FROM mysql.innodb_table_stats
19 WHERE table_name='innodb_stats_drop_locked'
20 FOR UPDATE;
21 SELECT table_name FROM mysql.innodb_index_stats
22 WHERE table_name='innodb_stats_drop_locked'
23 FOR UPDATE;
24
25 -- connect (con1,localhost,root,,)
26 SET innodb_lock_wait_timeout=1;
27
28 --error ER_LOCK_WAIT_TIMEOUT
29 ALTER TABLE innodb_stats_drop_locked DROP INDEX c_key;
30
31 # the index should be gone
32 SHOW CREATE TABLE innodb_stats_drop_locked;
33
34 --error ER_LOCK_WAIT_TIMEOUT
35 DROP TABLE innodb_stats_drop_locked;
36
37 DROP DATABASE unlocked;
38 --error ER_LOCK_WAIT_TIMEOUT
39 DROP DATABASE locked;
40 -- disconnect con1
41 -- connection default
42 COMMIT;
43
44 DROP DATABASE locked;
45
46 # the stats should be there
47
48 SELECT table_name FROM mysql.innodb_table_stats
49 WHERE table_name='innodb_stats_drop_locked';
50
51 SELECT table_name FROM mysql.innodb_index_stats
52 WHERE table_name='innodb_stats_drop_locked';
53
54 ALTER TABLE innodb_stats_drop_locked DROP INDEX c_key;
55
56 SELECT table_name FROM mysql.innodb_index_stats
57 WHERE table_name='innodb_stats_drop_locked';
58
59 DROP TABLE innodb_stats_drop_locked;
60
61 SELECT table_name FROM mysql.innodb_table_stats
62 WHERE table_name='innodb_stats_drop_locked';
63
64 SELECT table_name FROM mysql.innodb_index_stats
65 WHERE table_name='innodb_stats_drop_locked';