MySQL Meta database information_schema learning Tables Table

Tables in the INFORMATION_SCHEMA database are simply read-only, cannot be updated, deleted, and inserted, and cannot be triggered because they are actually just a view, not a base table, and there are no associated files.

There is a table tables in the INFORMATION_SCHEMA database, which provides a meta-information record of the database tables.

Here are a few of the frequently used field records:

Table_schema: The database name of the table in the record table_name: The table name in the record

Engine: the storage engine used by the table in the record table_rows: A rough row estimate of the table in the record

data_length: the size of the table in the record (in bytes) index_length: The index size of the table in the record

Knowing the above fields, you can query the size of the tables in the database, such as:

Select Table_schema,engine,table_name,table_rows,concat (data_length/1024/1024, ' MB '), concat (index_length/1024/ 1024x768, ' MB ') from Information_schema.tables ORDER BY data_length Desc

MySQL Meta database information_schema learning Tables Table