| 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 |