1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
|
--source include/have_debug.inc
--source include/have_innodb_16k.inc
--source include/not_valgrind.inc
--source include/have_case_sensitive_file_system.inc
--echo #
--echo # This test upgrades a database from 8.0.21 and attempts to add
--echo # autoextend_size tablespace attribute to it's tables
--echo # and tablespaces
--echo #
--echo # Stop the running server
--source include/shutdown_mysqld.inc
--echo ###################################################################
--echo # Unzip a 8.0.21 database and start the server using this directory
--echo ###################################################################
--echo ###################################################################
--echo # Copy and unzip the datadir
--echo ###################################################################
--copy_file $MYSQLTEST_VARDIR/std_data/data80021_autoextend_size.zip $MYSQL_TMP_DIR/data80021_autoextend_size.zip
--file_exists $MYSQL_TMP_DIR/data80021_autoextend_size.zip
--exec unzip -qo $MYSQL_TMP_DIR/data80021_autoextend_size.zip -d $MYSQL_TMP_DIR
let $BUGDATADIR = $MYSQL_TMP_DIR/data80021_autoextend_size;
--echo # Restart the server using the new datadir
--replace_result $BUGDATADIR BUGDATADIR
--let $restart_parameters = restart: --datadir=$BUGDATADIR --innodb_page_size=16k
--let $wait_counter=3000
--source include/start_mysqld.inc
--echo # Check the contents of INFORMATION_SCHEMA.INNODB_TABLESPACES
SELECT lower(name), file_size, autoextend_size from
INFORMATION_SCHEMA.INNODB_TABLESPACES where name like '%t%';
--echo # Update autoextend_size attribute both for the implicit as
--echo # well as explicit tablespaces
ALTER TABLE t5 AUTOEXTEND_SIZE 4M;
ALTER TABLESPACE ts1 AUTOEXTEND_SIZE 4M;
--echo # Check the contents of INFORMATION_SCHEMA.INNODB_TABLESPACES
SELECT lower(name), file_size, autoextend_size from
INFORMATION_SCHEMA.INNODB_TABLESPACES where name like '%t%';
--echo # Cleanup
--echo # Shutdown server
--source include/shutdown_mysqld.inc
--echo # Remove the copied files
--file_exists $MYSQL_TMP_DIR/data80021_autoextend_size.zip
--force-rmdir $MYSQL_TMP_DIR/data80021_autoextend_size
--remove_file $MYSQL_TMP_DIR/data80021_autoextend_size.zip
--echo # Restart the server
let $restart_parameters =;
--source include/start_mysqld.inc
|
