Debian Codegraph @

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

raw
1 SELECT @@innodb_temp_data_file_path;
2 @@innodb_temp_data_file_path
3 ibtmp1:12M:autoextend
4 SELECT FILE_NAME FROM INFORMATION_SCHEMA.FILES
5 WHERE TABLESPACE_NAME='innodb_temporary';
6 FILE_NAME
7 ./ibtmp1
8 # restart: --innodb-temp-data-file-path=mytemp:12M:autoextend
9 SELECT @@innodb_temp_data_file_path;
10 @@innodb_temp_data_file_path
11 mytemp:12M:autoextend
12 SELECT FILE_NAME FROM INFORMATION_SCHEMA.FILES
13 WHERE TABLESPACE_NAME='innodb_temporary';
14 FILE_NAME
15 ./mytemp
16 # restart: --innodb-temp-data-file-path=./mytemp:12M:autoextend
17 SELECT @@innodb_temp_data_file_path;
18 @@innodb_temp_data_file_path
19 ./mytemp:12M:autoextend
20 SELECT FILE_NAME FROM INFORMATION_SCHEMA.FILES
21 WHERE TABLESPACE_NAME='innodb_temporary';
22 FILE_NAME
23 ./mytemp
24 SET GLOBAL innodb_fast_shutdown = 0;
25 # restart: --innodb-read-only
26 SELECT @@innodb_temp_data_file_path;
27 @@innodb_temp_data_file_path
28 ibtmp1:12M:autoextend
29 SELECT FILE_NAME FROM INFORMATION_SCHEMA.FILES
30 WHERE TABLESPACE_NAME='innodb_temporary';
31 FILE_NAME
32 ./mytemp
33 # restart: --innodb-temp-data-file-path=MYSQL_TMP_DIR/mytemp:12M:autoextend
34 SELECT @@innodb_temp_data_file_path;
35 @@innodb_temp_data_file_path
36 MYSQL_TMP_DIR/mytemp:12M:autoextend
37 SELECT FILE_NAME FROM INFORMATION_SCHEMA.FILES
38 WHERE TABLESPACE_NAME='innodb_temporary';
39 FILE_NAME
40 MYSQL_TMP_DIR/mytemp
41 # restart: