Debian Codegraph @

mysql-test/suite/rpl/t/rpl_autoextend_ddl.test

raw
1 --source include/have_innodb_16k.inc
2 --source include/not_valgrind.inc
3
4 --echo #
5 --echo # Test AUTOEXTEND_SIZE clause
6 --echo # This test validates that the changes to AUTOEXTEND_SIZE
7 --echo # option are replicated to the secondary nodes successfully
8 --echo #
9
10 source include/set_privilege_checks_user_as_system_user.inc;
11 source include/master-slave.inc;
12
13 --disable_warnings
14 connection master;
15 drop database if exists test1;
16 --enable_warnings
17 create database test1;
18 use test;
19
20 --echo # Scenario-1: Create a table with autoextend_size set to valid value
21 --echo # and validate that the changes are propagated properly to the secondary nodes
22 CREATE TABLE t1(c1 INT) AUTOEXTEND_SIZE 4M;
23 SELECT NAME, FILE_SIZE, AUTOEXTEND_SIZE from INFORMATION_SCHEMA.INNODB_TABLESPACES
24 WHERE NAME like '%t1%';
25
26 # Sync the slave
27 --source include/sync_slave_sql_with_master.inc
28
29 connection slave;
30 SELECT NAME, FILE_SIZE, AUTOEXTEND_SIZE from INFORMATION_SCHEMA.INNODB_TABLESPACES
31 WHERE NAME like '%t1%';
32
33 SHOW CREATE TABLE t1;
34
35 --echo # Scenario-2: Alter an existing table and set autoextend_size option
36 --echo # and validate that the option is propagated to the slave nodes
37 connection master;
38 ALTER TABLE t1 AUTOEXTEND_SIZE 0;
39 SELECT NAME, FILE_SIZE, AUTOEXTEND_SIZE from INFORMATION_SCHEMA.INNODB_TABLESPACES
40 WHERE NAME like '%t1%';
41
42 # Sync the slave
43 --source include/sync_slave_sql_with_master.inc
44 connection slave;
45 SELECT NAME, FILE_SIZE, AUTOEXTEND_SIZE from INFORMATION_SCHEMA.INNODB_TABLESPACES
46 WHERE NAME like '%t1%';
47
48 connection master;
49 DROP TABLE t1;
50
51 --echo # Scenario-3: Test that autoextend_size value for implicit tablespaces
52 --echo # is visible on slave nodes
53 CREATE TABLESPACE myspace AUTOEXTEND_SIZE 4M;
54 # Sync the slave
55 --source include/sync_slave_sql_with_master.inc
56 connection slave;
57 SELECT NAME, FILE_SIZE, AUTOEXTEND_SIZE from INFORMATION_SCHEMA.INNODB_TABLESPACES
58 WHERE NAME like '%myspace%';
59
60 connection master;
61 ALTER TABLESPACE myspace AUTOEXTEND_SIZE 0;
62 # Sync the slave
63 --source include/sync_slave_sql_with_master.inc
64 connection slave;
65 SELECT NAME, FILE_SIZE, AUTOEXTEND_SIZE from INFORMATION_SCHEMA.INNODB_TABLESPACES
66 WHERE NAME like '%myspace%';
67
68 connection master;
69 DROP TABLESPACE myspace;
70
71 --echo #Scenario-4: Test replication of autoextend_size on partitioned and
72 --echo # sub-partitioned tables
73 CREATE TABLE tpart (c1 INT, c2 TEXT) AUTOEXTEND_SIZE 4M
74 PARTITION BY RANGE (c1) (
75 PARTITION p0 VALUES LESS THAN (20),
76 PARTITION p1 VALUES LESS THAN maxvalue);
77 SELECT NAME, FILE_SIZE, AUTOEXTEND_SIZE from INFORMATION_SCHEMA.INNODB_TABLESPACES
78 WHERE NAME like '%tpart%';
79
80 CREATE TABLE tsubpart (c1 INT, c2 TEXT) AUTOEXTEND_SIZE 4M
81 PARTITION BY RANGE (c1)
82 SUBPARTITION BY HASH (c1)
83 SUBPARTITIONS 3 (
84 PARTITION p0 VALUES LESS THAN (10),
85 PARTITION p1 VALUES LESS THAN (20),
86 PARTITION p2 VALUES LESS THAN maxvalue);
87 SELECT NAME, FILE_SIZE, AUTOEXTEND_SIZE from INFORMATION_SCHEMA.INNODB_TABLESPACES
88 WHERE NAME like '%tsubpart%';
89
90 # Sync the slave
91 --source include/sync_slave_sql_with_master.inc
92 connection slave;
93 SELECT NAME, FILE_SIZE, AUTOEXTEND_SIZE from INFORMATION_SCHEMA.INNODB_TABLESPACES
94 WHERE NAME like '%tpart%';
95 SELECT NAME, FILE_SIZE, AUTOEXTEND_SIZE from INFORMATION_SCHEMA.INNODB_TABLESPACES
96 WHERE NAME like '%tsubpart%';
97
98 connection master;
99 DROP TABLE tpart;
100 DROP TABLE tsubpart;
101
102 --echo # Scenario-5: Test replication of autoextend_size value when it is
103 --echo # changed by ALTER TABLE statement for partitioned and sub-partitioned tables
104 CREATE TABLE tpart (c1 INT, c2 TEXT) AUTOEXTEND_SIZE 4M;
105
106 ALTER TABLE tpart PARTITION BY RANGE (c1) (
107 PARTITION p0 VALUES LESS THAN (10),
108 PARTITION p1 VALUES LESS THAN (20),
109 PARTITION p2 VALUES LESS THAN maxvalue);
110
111 CREATE TABLE tsubpart (c1 INT, c2 TEXT) AUTOEXTEND_SIZE 4M;
112 ALTER TABLE tsubpart
113 PARTITION BY RANGE (c1)
114 SUBPARTITION BY HASH (c1)
115 SUBPARTITIONS 3 (
116 PARTITION p0 VALUES LESS THAN (10),
117 PARTITION p1 VALUES LESS THAN (20),
118 PARTITION p2 VALUES LESS THAN maxvalue);
119
120 # Sync the slave
121 --source include/sync_slave_sql_with_master.inc
122 connection slave;
123 SELECT NAME, FILE_SIZE, AUTOEXTEND_SIZE from INFORMATION_SCHEMA.INNODB_TABLESPACES
124 WHERE NAME like '%tpart%';
125 SELECT NAME, FILE_SIZE, AUTOEXTEND_SIZE from INFORMATION_SCHEMA.INNODB_TABLESPACES
126 WHERE NAME like '%tsubpart%';
127
128 connection master;
129 DROP TABLE tpart;
130 DROP TABLE tsubpart;
131
132 DROP DATABASE test1;
133 --source include/rpl_end.inc