MySQL's information_schema parsing 1

INFORMATION_SCHEMA Library is a system library provided by MySQL, which keeps the original data of the database, and makes it easy for users to monitor and manage MSYQL.

Now, Nathan, the library associated with INNODB: Innodb_sys_tables,innodb_sys_columns,innodb_sys_indexs,innodb_sys_tablespaces,

Innodb_sys_fields,innodb_sys_datafiles,innodb_sys_tablestats,innodb_sys_foreign,innodb_sys_foreign_cols.

A description of the relationships between the primary tables is available:

These 7 tables are linked to each other through Table_id,index_id,space to enable the retrieval and monitoring of data.

MySQL's information_schema parsing 1