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_sys_tablespaces and innodb_sys_datafiles ===
5 --disable_query_log
6 --replace_regex /#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 name 'Space_Name',
9 @@GLOBAL.innodb_page_size 'Page_Size',
10 page_size 'Zip_Size',
11 filename 'Path'
12 FROM information_schema.innodb_sys_tablespaces
13 WHERE name != 'innodb_system'
14 AND name NOT LIKE 'mysql/%'
15 ORDER BY space;
16 --enable_query_log