mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE SPACE = 26\G *************************** 1. row *************************** SPACE: 26 NAME: test/t1 FLAG: 0 FILE_FORMAT: Antelope ROW_FORMAT: Compact or Redundant PAGE_SIZE: 16384 ZIP_PAGE_SIZE: 0 SPACE_TYPE: Single FS_BLOCK_SIZE: 4096 FILE_SIZE: 98304 ALLOCATED_SIZE: 65536
ALLOCATED_SIZE:
The actual size of the file, which is the amount of space allocated on disk.
这个信息可采集,做表和整个数据库磁盘容量趋势分析。
参考文档:https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tablespaces-table.html