The INFORMATION_SCHEMA INNODB_SYS_TABLES Table

The INNODB_SYS_TABLES table provides status information about InnoDB tables, equivalent to the information from the SYS_TABLES table in the InnoDB data dictionary.

Table 18.6. INNODB_SYS_TABLES Columns

Column name	Description
TABLE_ID	An identifier for each InnoDB table that is unique across all databases in the instance.
NAME	The name of the table. Preceded by the database name where appropriate, for example test/t1. InnoDB system table names are in all uppercase. Names of databases and user tables are in the same case as they were originally defined, possibly influenced by the lower_case_table_names setting.
FLAG	0 = InnoDB system table, 1 = user table.
N_COLS	The number of columns in the table.
SPACE	An identifier for the tablespace where the table resides. 0 means the InnoDB system tablespace. Any other number represents a table created in file-per-table mode with a separate .ibd file. This identifier stays the same after a TRUNCATE TABLE statement. Other than the zero value, this identifier is unique for tables across all the databases in the instance.

Notes:

• Since the INFORMATION_SCHEMA is a general-purpose way to monitor the MariaDB server, use this table rather than the corresponding InnoDB system table for any new monitoring application you develop.
• You must have the PROCESS privilege to query this table.

Retornar