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
58
59
60
61
62
|
#######################################################################
# Bug#32840635: WRONG FILE_NAME OF INNODB_TEMPORARY TABLESPACE IN
# INFORMATION_SCHEMA.FILES TABLE
#######################################################################
--source include/not_windows.inc
# This test verifies that the value of innodb_temp_data_file_path and
# the value of FILE_NAME of innodb_temporary tablespace in
# INFORMATION_SCHEMA.FILES match
SELECT @@innodb_temp_data_file_path;
SELECT FILE_NAME FROM INFORMATION_SCHEMA.FILES
WHERE TABLESPACE_NAME='innodb_temporary';
# Restart the server with a non-default value of innodb-temp-data-file-path
--let $restart_parameters = restart: --innodb-temp-data-file-path=mytemp:12M:autoextend
--source include/restart_mysqld.inc
# Verify that the new temp data file path is reflect correctly
SELECT @@innodb_temp_data_file_path;
SELECT FILE_NAME FROM INFORMATION_SCHEMA.FILES
WHERE TABLESPACE_NAME='innodb_temporary';
# Restart the server with a relative path for innodb-temp-data-file-path
--let $restart_parameters = restart: --innodb-temp-data-file-path=./mytemp:12M:autoextend
--source include/restart_mysqld.inc
# Verify that the new temp data file path is reflect correctly
SELECT @@innodb_temp_data_file_path;
SELECT FILE_NAME FROM INFORMATION_SCHEMA.FILES
WHERE TABLESPACE_NAME='innodb_temporary';
# Restart the server with a non-default innodb-temp-data-file-path and read only mode
--let $restart_parameters = restart: --innodb-temp-data-file-path=newtemp:12M:autoextend
--source include/restart_innodb_read_only.inc
# Since the server is started in read only mode, the filepath is not updated and hence
# innodb_temp_data_file_path variable and file_name in information_schema.files will
# be different
SELECT @@innodb_temp_data_file_path;
SELECT FILE_NAME FROM INFORMATION_SCHEMA.FILES
WHERE TABLESPACE_NAME='innodb_temporary';
# Restart the server with an absolute path for innodb-temp-data-file-path
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
--let $restart_parameters = restart: --innodb-temp-data-file-path=$MYSQL_TMP_DIR/mytemp:12M:autoextend
--source include/restart_mysqld.inc
# Verify that the new temp data file path is reflect correctly
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
SELECT @@innodb_temp_data_file_path;
--replace_result $MYSQL_TMP_DIR MYSQL_TMP_DIR
SELECT FILE_NAME FROM INFORMATION_SCHEMA.FILES
WHERE TABLESPACE_NAME='innodb_temporary';
# Restart the server with the default innodb-temp-data-file-path
--let $restart_parameters = restart:
--source include/restart_mysqld.inc
|
