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