MariaDB [(none)]> SELECT t.NAME, c.* -> FROM information_schema.innodb_sys_tables t -> JOIN information_schema.innodb_sys_columns c ON c.table_id = t.table_id -> WHERE t.NAME LIKE '%innodb_%'; +--------------------------+----------+--------------------------+-----+-------+---------+------+ | NAME | TABLE_ID | NAME | POS | MTYPE | PRTYPE | LEN | +--------------------------+----------+--------------------------+-----+-------+---------+------+ | mysql/innodb_table_stats | 15 | database_name | 0 | 12 | 5439759 | 192 | | mysql/innodb_table_stats | 15 | table_name | 1 | 12 | 5439759 | 192 | | mysql/innodb_table_stats | 15 | last_update | 2 | 6 | 1799 | 4 | | mysql/innodb_table_stats | 15 | n_rows | 3 | 6 | 1800 | 8 | | mysql/innodb_table_stats | 15 | clustered_index_size | 4 | 6 | 1800 | 8 | | mysql/innodb_table_stats | 15 | sum_of_other_index_sizes | 5 | 6 | 1800 | 8 | | mysql/innodb_index_stats | 16 | database_name | 0 | 12 | 5439759 | 192 | | mysql/innodb_index_stats | 16 | table_name | 1 | 12 | 5439759 | 192 | | mysql/innodb_index_stats | 16 | index_name | 2 | 12 | 5439759 | 192 | | mysql/innodb_index_stats | 16 | last_update | 3 | 6 | 1799 | 4 | | mysql/innodb_index_stats | 16 | stat_name | 4 | 12 | 5439759 | 192 | | mysql/innodb_index_stats | 16 | stat_value | 5 | 6 | 1800 | 8 | | mysql/innodb_index_stats | 16 | sample_size | 6 | 6 | 1544 | 8 | | mysql/innodb_index_stats | 16 | stat_description | 7 | 12 | 5443855 | 3072 | +--------------------------+----------+--------------------------+-----+-------+---------+------+ 14 rows in set (0.001 sec) MariaDB [(none)]> MariaDB [(none)]> SELECT * -> FROM information_schema.columns -> WHERE TABLE_NAME = 'innodb_table_stats';\g +---------------+--------------+--------------------+--------------------------+------------------+---------------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+----------------+---------------------+------------+-------------------------------+---------------------------------+----------------+--------------+-----------------------+ | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | COLUMN_DEFAULT | IS_NULLABLE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | NUMERIC_PRECISION | NUMERIC_SCALE | DATETIME_PRECISION | CHARACTER_SET_NAME | COLLATION_NAME | COLUMN_TYPE | COLUMN_KEY | EXTRA | PRIVILEGES | COLUMN_COMMENT | IS_GENERATED | GENERATION_EXPRESSION | +---------------+--------------+--------------------+--------------------------+------------------+---------------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+----------------+---------------------+------------+-------------------------------+---------------------------------+----------------+--------------+-----------------------+ | def | mysql | innodb_table_stats | database_name | 1 | NULL | NO | varchar | 64 | 192 | NULL | NULL | NULL | utf8 | utf8_bin | varchar(64) | PRI | | select,insert,update,references | | NEVER | NULL | | def | mysql | innodb_table_stats | table_name | 2 | NULL | NO | varchar | 199 | 597 | NULL | NULL | NULL | utf8 | utf8_bin | varchar(199) | PRI | | select,insert,update,references | | NEVER | NULL | | def | mysql | innodb_table_stats | last_update | 3 | current_timestamp() | NO | timestamp | NULL | NULL | NULL | NULL | 0 | NULL | NULL | timestamp | | on update current_timestamp() | select,insert,update,references | | NEVER | NULL | | def | mysql | innodb_table_stats | n_rows | 4 | NULL | NO | bigint | NULL | NULL | 20 | 0 | NULL | NULL | NULL | bigint(20) unsigned | | | select,insert,update,references | | NEVER | NULL | | def | mysql | innodb_table_stats | clustered_index_size | 5 | NULL | NO | bigint | NULL | NULL | 20 | 0 | NULL | NULL | NULL | bigint(20) unsigned | | | select,insert,update,references | | NEVER | NULL | | def | mysql | innodb_table_stats | sum_of_other_index_sizes | 6 | NULL | NO | bigint | NULL | NULL | 20 | 0 | NULL | NULL | NULL | bigint(20) unsigned | | | select,insert,update,references | | NEVER | NULL | +---------------+--------------+--------------------+--------------------------+------------------+---------------------+-------------+-----------+--------------------------+------------------------+-------------------+---------------+--------------------+--------------------+----------------+---------------------+------------+-------------------------------+---------------------------------+----------------+--------------+-----------------------+ 6 rows in set (0.003 sec)