Debian Codegraph @

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

raw
1 #
2 # This test upgrades a database from 8.0.21 and attempts to add
3 # autoextend_size tablespace attribute to it's tables
4 # and tablespaces
5 #
6 # Stop the running server
7 ###################################################################
8 # Unzip a 8.0.21 database and start the server using this directory
9 ###################################################################
10 ###################################################################
11 # Copy and unzip the datadir
12 ###################################################################
13 # Restart the server using the new datadir
14 # restart: --datadir=BUGDATADIR --innodb_page_size=16k
15 # Check the contents of INFORMATION_SCHEMA.INNODB_TABLESPACES
16 SELECT lower(name), file_size, autoextend_size from
17 INFORMATION_SCHEMA.INNODB_TABLESPACES where name like '%t%';
18 lower(name) file_size autoextend_size
19 innodb_temporary 12582912 0
20 test/t5 114688 0
21 ts1 147456 0
22 # Update autoextend_size attribute both for the implicit as
23 # well as explicit tablespaces
24 ALTER TABLE t5 AUTOEXTEND_SIZE 4M;
25 ALTER TABLESPACE ts1 AUTOEXTEND_SIZE 4M;
26 # Check the contents of INFORMATION_SCHEMA.INNODB_TABLESPACES
27 SELECT lower(name), file_size, autoextend_size from
28 INFORMATION_SCHEMA.INNODB_TABLESPACES where name like '%t%';
29 lower(name) file_size autoextend_size
30 innodb_temporary 12582912 0
31 test/t5 114688 4194304
32 ts1 147456 4194304
33 # Cleanup
34 # Shutdown server
35 # Remove the copied files
36 # Restart the server
37 # restart