Debian Codegraph @

mysql-test/suite/innodb/include/show_i_s_tablespaces.inc

raw
1 # This script assumes that the caller did the following;
2 # LET $MYSQLD_DATADIR = `select @@datadir`;
3 # LET $INNODB_PAGE_SIZE = `select @@innodb_page_size`;
4 --echo === information_schema.innodb_tablespaces and innodb_datafiles ===
5 --disable_query_log
6 --replace_regex /innodb_file_per_table.[0-9]+/innodb_file_per_table.##/ /#P#/#p#/ /#SP#/#sp#/
7 --replace_result ./ MYSQLD_DATADIR/ $MYSQLD_DATADIR/ MYSQLD_DATADIR/ $MYSQLD_DATADIR MYSQLD_DATADIR/ $MYSQL_TMP_DIR MYSQL_TMP_DIR $INNODB_PAGE_SIZE DEFAULT
8 SELECT s.name 'Space_Name',
9 s.space_type 'Space_Type',
10 s.page_size 'Page_Size',
11 s.zip_page_size 'Zip_Size',
12 s.fs_block_size!=0 'BlockSize!=0',
13 s.file_size!=0 'FileSize!=0',
14 s.row_format 'Formats_Permitted',
15 d.path 'Path'
16 FROM information_schema.innodb_tablespaces s,
17 information_schema.innodb_datafiles d
18 WHERE s.space = d.space
19 AND d.path NOT LIKE '%/sys/%'
20 AND d.path NOT LIKE '%\\\sys\\\%'
21 AND s.name NOT LIKE 'mysql/%'
22 AND s.name NOT LIKE 'sys/%'
23 AND s.name NOT LIKE '%undo%'
24 ORDER BY s.name, d.path;
25
26 # This SELECT will not show UNDO or TEMPORARY tablespaces
27 --echo === information_schema.files ===
28 LET $REGEX = /innodb_file_per_table.[0-9]+/innodb_file_per_table.##/ /#P#/#p#/ /#SP#/#sp#/ $EXTRA_I_S_FILES_REGEX;
29 --replace_regex $REGEX
30 --replace_result ./ MYSQLD_DATADIR/ $MYSQLD_DATADIR/ MYSQLD_DATADIR/ $MYSQLD_DATADIR MYSQLD_DATADIR/ $MYSQL_TMP_DIR MYSQL_TMP_DIR $INNODB_PAGE_SIZE DEFAULT
31 # Hypergraph optimizer has different warnings, so disable them temporarily.
32 --disable_warnings
33 SELECT s.name 'Space_Name',
34 f.file_type 'File_Type',
35 f.engine 'Engine',
36 f.status 'Status',
37 f.tablespace_name 'Tablespace_Name',
38 f.file_name 'Path'
39 FROM information_schema.files f,
40 information_schema.innodb_tablespaces s
41 WHERE f.file_id = s.space
42 AND f.file_name NOT LIKE '%/sys/%'
43 AND f.file_name NOT LIKE '%\\\sys\\\%'
44 AND s.name NOT LIKE 'mysql'
45 AND s.name NOT LIKE 'sys/%'
46 AND s.name NOT LIKE 'innodb_temporary'
47 AND s.name NOT LIKE '%undo%'
48 ORDER BY s.name, f.file_name;
49 --enable_warnings
50 --enable_query_log