mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ 4 rows in set (0.00 sec) mysql> show table status from information_schema; +---------------------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+------------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +---------------------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+------------------+---------+ | CHARACTER_SETS | MEMORY | 10 | Fixed | NULL | 384 | 0 | 16434816 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=43690 | | | COLLATIONS | MEMORY | 10 | Fixed | NULL | 231 | 0 | 16704765 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=72628 | | | COLLATION_CHARACTER_SET_APPLICABILITY | MEMORY | 10 | Fixed | NULL | 195 | 0 | 16357770 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=86037 | | | COLUMNS | InnoDB | 10 | Dynamic | NULL | 0 | 16384 | 0 | 0 | 8388608 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=2789 | | | COLUMN_PRIVILEGES | MEMORY | 10 | Fixed | NULL | 2565 | 0 | 16757145 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=6540 | | | ENGINES | MEMORY | 10 | Fixed | NULL | 490 | 0 | 16574250 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=34239 | | | EVENTS | InnoDB | 10 | Dynamic | NULL | 0 | 16384 | 0 | 0 | 8388608 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=619 | | | FILES | MEMORY | 10 | Fixed | NULL | 14468 | 0 | 16768412 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=1159 | | | GLOBAL_STATUS | MEMORY | 10 | Fixed | NULL | 3268 | 0 | 16755036 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=5133 | | | GLOBAL_VARIABLES | MEMORY | 10 | Fixed | NULL | 3268 | 0 | 16755036 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=5133 | | | KEY_COLUMN_USAGE | MEMORY | 10 | Fixed | NULL | 4637 | 0 | 16762755 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=3618 | | | OPTIMIZER_TRACE | InnoDB | 10 | Dynamic | NULL | 0 | 16384 | 0 | 0 | 8388608 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=578524 | | | PARAMETERS | InnoDB | 10 | Dynamic | NULL | 0 | 16384 | 0 | 0 | 8388608 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=6021 | | | PARTITIONS | InnoDB | 10 | Dynamic | NULL | 0 | 16384 | 0 | 0 | 8388608 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=5596 | | | PLUGINS | InnoDB | 10 | Dynamic | NULL | 0 | 16384 | 0 | 0 | 8388608 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=11328 | | | PROCESSLIST | InnoDB | 10 | Dynamic | NULL | 0 | 16384 | 0 | 0 | 8388608 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=22369 | | | PROFILING | MEMORY | 10 | Fixed | NULL | 308 | 0 | 16562084 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=54471 | | | REFERENTIAL_CONSTRAINTS | MEMORY | 10 | Fixed | NULL | 4814 | 0 | 16767162 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=3485 | | | ROUTINES | InnoDB | 10 | Dynamic | NULL | 0 | 16384 | 0 | 0 | 8388608 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=583 | | | SCHEMATA | MEMORY | 10 | Fixed | NULL | 3464 | 0 | 16738048 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=4843 | | | SCHEMA_PRIVILEGES | MEMORY | 10 | Fixed | NULL | 2179 | 0 | 16736899 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=7699 | | | SESSION_STATUS | MEMORY | 10 | Fixed | NULL | 3268 | 0 | 16755036 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=5133 | | | SESSION_VARIABLES | MEMORY | 10 | Fixed | NULL | 3268 | 0 | 16755036 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=5133 | | | STATISTICS | MEMORY | 10 | Fixed | NULL | 5753 | 0 | 16752736 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=2916 | | | TABLES | MEMORY | 10 | Fixed | NULL | 9441 | 0 | 16757775 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=1777 | | | TABLESPACES | MEMORY | 10 | Fixed | NULL | 6951 | 0 | 16772763 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=2413 | | | TABLE_CONSTRAINTS | MEMORY | 10 | Fixed | NULL | 2504 | 0 | 16721712 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=6700 | | | TABLE_PRIVILEGES | MEMORY | 10 | Fixed | NULL | 2372 | 0 | 16748692 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=7073 | | | TRIGGERS | InnoDB | 10 | Dynamic | NULL | 0 | 16384 | 0 | 0 | 8388608 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=569 | | | USER_PRIVILEGES | MEMORY | 10 | Fixed | NULL | 1986 | 0 | 16726092 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=8447 | | | VIEWS | InnoDB | 10 | Dynamic | NULL | 0 | 16384 | 0 | 0 | 8388608 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | max_rows=6935 | | | INNODB_LOCKS | MEMORY | 10 | Fixed | NULL | 31244 | 0 | 16746784 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=536 | | | INNODB_TRX | MEMORY | 10 | Fixed | NULL | 4536 | 0 | 16746912 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=3698 | | | INNODB_SYS_DATAFILES | MEMORY | 10 | Fixed | NULL | 12007 | 0 | 16773779 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=1397 | | | INNODB_FT_CONFIG | MEMORY | 10 | Fixed | NULL | 1163 | 0 | 16705332 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=14425 | | | INNODB_SYS_VIRTUAL | MEMORY | 10 | Fixed | NULL | 17 | 0 | 11883850 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=986895 | | | INNODB_CMP | MEMORY | 10 | Fixed | NULL | 25 | 0 | 13107200 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=671088 | | | INNODB_FT_BEING_DELETED | MEMORY | 10 | Fixed | NULL | 9 | 0 | 9437184 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=1864135 | | | INNODB_CMP_RESET | MEMORY | 10 | Fixed | NULL | 25 | 0 | 13107200 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=671088 | | | INNODB_CMP_PER_INDEX | MEMORY | 10 | Fixed | NULL | 1755 | 0 | 16728660 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=9559 | | | INNODB_CMPMEM_RESET | MEMORY | 10 | Fixed | NULL | 29 | 0 | 15204352 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=578524 | | | INNODB_FT_DELETED | MEMORY | 10 | Fixed | NULL | 9 | 0 | 9437184 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=1864135 | | | INNODB_BUFFER_PAGE_LRU | MEMORY | 10 | Fixed | NULL | 6669 | 0 | 16765866 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=2515 | | | INNODB_LOCK_WAITS | MEMORY | 10 | Fixed | NULL | 599 | 0 | 16749238 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=28008 | | | INNODB_TEMP_TABLE_INFO | MEMORY | 10 | Fixed | NULL | 1011 | 0 | 16694643 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=16594 | | | INNODB_SYS_INDEXES | MEMORY | 10 | Fixed | NULL | 618 | 0 | 16615548 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=27147 | | | INNODB_SYS_TABLES | MEMORY | 10 | Fixed | NULL | 2091 | 0 | 16736364 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=8023 | | | INNODB_SYS_FIELDS | MEMORY | 10 | Fixed | NULL | 594 | 0 | 16609428 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=28244 | | | INNODB_CMP_PER_INDEX_RESET | MEMORY | 10 | Fixed | NULL | 1755 | 0 | 16728660 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=9559 | | | INNODB_BUFFER_PAGE | MEMORY | 10 | Fixed | NULL | 6852 | 0 | 16766844 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=2448 | | | INNODB_FT_DEFAULT_STOPWORD | MEMORY | 10 | Fixed | NULL | 56 | 0 | 14680064 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=299593 | | | INNODB_FT_INDEX_TABLE | MEMORY | 10 | Fixed | NULL | 808 | 0 | 16612480 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=20763 | | | INNODB_FT_INDEX_CACHE | MEMORY | 10 | Fixed | NULL | 808 | 0 | 16612480 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=20763 | | | INNODB_SYS_TABLESPACES | MEMORY | 10 | Fixed | NULL | 2149 | 0 | 16753604 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=7806 | | | INNODB_METRICS | MEMORY | 10 | Fixed | NULL | 2994 | 0 | 16742448 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=5603 | | | INNODB_SYS_FOREIGN_COLS | MEMORY | 10 | Fixed | NULL | 1748 | 0 | 16738848 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=9597 | | | INNODB_CMPMEM | MEMORY | 10 | Fixed | NULL | 29 | 0 | 15204352 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=578524 | | | INNODB_BUFFER_POOL_STATS | MEMORY | 10 | Fixed | NULL | 257 | 0 | 16332350 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=65280 | | | INNODB_SYS_COLUMNS | MEMORY | 10 | Fixed | NULL | 610 | 0 | 16613350 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=27503 | | | INNODB_SYS_FOREIGN | MEMORY | 10 | Fixed | NULL | 1752 | 0 | 16700064 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=9576 | | | INNODB_SYS_TABLESTATS | MEMORY | 10 | Fixed | NULL | 1215 | 0 | 16763355 | 0 | 0 | NULL | 2015-10-25 20:07:13 | NULL | NULL | utf8_general_ci | NULL | max_rows=13808 | | +---------------------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+------------------+---------+ 61 rows in set (0.01 sec) mysql> show table status from mysql; +---------------------------+--------+---------+------------+------+----------------+-------------+--------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+--------------------+-----------------------------------------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +---------------------------+--------+---------+------------+------+----------------+-------------+--------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+--------------------+-----------------------------------------+ | columns_priv | MyISAM | 10 | Fixed | 0 | 0 | 0 | 241505530017742847 | 4096 | 0 | NULL | 2015-10-25 12:55:04 | 2015-10-25 12:55:04 | NULL | utf8_bin | NULL | | Column privileges | | db | MyISAM | 10 | Fixed | 1 | 488 | 488 | 137359788634800127 | 5120 | 0 | NULL | 2015-10-25 12:55:04 | 2015-10-25 12:55:05 | NULL | utf8_bin | NULL | | Database privileges | | engine_cost | InnoDB | 10 | Dynamic | 2 | 8192 | 16384 | 0 | 0 | 0 | NULL | 2015-10-25 12:57:08 | NULL | NULL | utf8_general_ci | NULL | stats_persistent=0 | | | event | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 2048 | 0 | NULL | 2015-10-25 12:55:04 | 2015-10-25 12:55:04 | NULL | utf8_general_ci | NULL | | Events | | func | MyISAM | 10 | Fixed | 0 | 0 | 0 | 162974011515469823 | 1024 | 0 | NULL | 2015-10-25 12:55:04 | 2015-10-25 12:55:04 | NULL | utf8_bin | NULL | | User defined functions | | general_log | CSV | 10 | Dynamic | 2 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | General log | | gtid_executed | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2015-10-25 12:57:08 | NULL | NULL | latin1_swedish_ci | NULL | | | | help_category | InnoDB | 10 | Dynamic | 40 | 409 | 16384 | 0 | 16384 | 0 | NULL | 2015-10-25 12:57:08 | NULL | NULL | utf8_general_ci | NULL | stats_persistent=0 | help categories | | help_keyword | InnoDB | 10 | Dynamic | 460 | 213 | 98304 | 0 | 81920 | 0 | NULL | 2015-10-25 12:57:08 | NULL | NULL | utf8_general_ci | NULL | stats_persistent=0 | help keywords | | help_relation | InnoDB | 10 | Dynamic | 1094 | 59 | 65536 | 0 | 0 | 0 | NULL | 2015-10-25 12:57:08 | NULL | NULL | utf8_general_ci | NULL | stats_persistent=0 | keyword-topic relation | | help_topic | InnoDB | 10 | Dynamic | 740 | 2147 | 1589248 | 0 | 81920 | 4194304 | NULL | 2015-10-25 12:57:08 | NULL | NULL | utf8_general_ci | NULL | stats_persistent=0 | help topics | | innodb_index_stats | InnoDB | 10 | Dynamic | 7 | 2340 | 16384 | 0 | 0 | 0 | NULL | 2015-10-25 12:57:08 | NULL | NULL | utf8_bin | NULL | stats_persistent=0 | | | innodb_table_stats | InnoDB | 10 | Dynamic | 2 | 8192 | 16384 | 0 | 0 | 0 | NULL | 2015-10-25 12:57:08 | NULL | NULL | utf8_bin | NULL | stats_persistent=0 | | | ndb_binlog_index | MyISAM | 10 | Dynamic | 0 | 0 | 0 | 281474976710655 | 1024 | 0 | NULL | 2015-10-25 12:55:04 | 2015-10-25 12:55:04 | NULL | latin1_swedish_ci | NULL | | | | plugin | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2015-10-25 12:57:08 | NULL | NULL | utf8_general_ci | NULL | stats_persistent=0 | MySQL plugins | | proc | MyISAM | 10 | Dynamic | 47 | 6252 | 293856 | 281474976710655 | 4096 | 0 | NULL | 2015-10-25 12:55:04 | 2015-10-25 12:55:05 | NULL | utf8_general_ci | NULL | | Stored Procedures | | procs_priv | MyISAM | 10 | Fixed | 0 | 0 | 0 | 252764529086169087 | 4096 | 0 | NULL | 2015-10-25 12:55:04 | 2015-10-25 12:55:04 | NULL | utf8_bin | NULL | | Procedure privileges | | proxies_priv | MyISAM | 10 | Fixed | 1 | 789 | 789 | 222083756624707583 | 8192 | 0 | NULL | 2015-10-25 12:55:04 | 2015-10-25 12:55:04 | NULL | utf8_bin | NULL | | User proxy privileges | | server_cost | InnoDB | 10 | Dynamic | 6 | 2730 | 16384 | 0 | 0 | 0 | NULL | 2015-10-25 12:57:08 | NULL | NULL | utf8_general_ci | NULL | stats_persistent=0 | | | servers | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2015-10-25 12:57:08 | NULL | NULL | utf8_general_ci | NULL | stats_persistent=0 | MySQL Foreign Servers table | | slave_master_info | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2015-10-25 12:57:08 | NULL | NULL | utf8_general_ci | NULL | stats_persistent=0 | Master Information | | slave_relay_log_info | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2015-10-25 12:57:08 | NULL | NULL | utf8_general_ci | NULL | stats_persistent=0 | Relay Log Information | | slave_worker_info | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2015-10-25 12:57:08 | NULL | NULL | utf8_general_ci | NULL | stats_persistent=0 | Worker Information | | slow_log | CSV | 10 | Dynamic | 2 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | Slow log | | tables_priv | MyISAM | 10 | Fixed | 1 | 899 | 899 | 253046004062879743 | 8192 | 0 | NULL | 2015-10-25 12:55:04 | 2015-10-25 12:55:05 | NULL | utf8_bin | NULL | | Table privileges | | time_zone | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | 1 | 2015-10-25 12:57:08 | NULL | NULL | utf8_general_ci | NULL | stats_persistent=0 | Time zones | | time_zone_leap_second | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2015-10-25 12:57:08 | NULL | NULL | utf8_general_ci | NULL | stats_persistent=0 | Leap seconds information for time zones | | time_zone_name | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2015-10-25 12:57:08 | NULL | NULL | utf8_general_ci | NULL | stats_persistent=0 | Time zone names | | time_zone_transition | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2015-10-25 12:57:08 | NULL | NULL | utf8_general_ci | NULL | stats_persistent=0 | Time zone transitions | | time_zone_transition_type | InnoDB | 10 | Dynamic | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2015-10-25 12:57:08 | NULL | NULL | utf8_general_ci | NULL | stats_persistent=0 | Time zone transition types | | user | MyISAM | 10 | Dynamic | 2 | 126 | 252 | 281474976710655 | 4096 | 0 | NULL | 2015-10-25 12:55:04 | 2015-10-25 13:44:42 | NULL | utf8_bin | NULL | | Users and global privileges | +---------------------------+--------+---------+------------+------+----------------+-------------+--------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-------------------+----------+--------------------+-----------------------------------------+ 31 rows in set (0.01 sec) mysql> show table status from performance_schema; +------------------------------------------------------+--------------------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +------------------------------------------------------+--------------------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------------+----------+----------------+---------+ | accounts | PERFORMANCE_SCHEMA | 10 | Fixed | 128 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | cond_instances | PERFORMANCE_SCHEMA | 10 | Dynamic | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_stages_current | PERFORMANCE_SCHEMA | 10 | Dynamic | 256 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_stages_history | PERFORMANCE_SCHEMA | 10 | Dynamic | 2560 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_stages_history_long | PERFORMANCE_SCHEMA | 10 | Dynamic | 10000 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_stages_summary_by_account_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 19200 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_stages_summary_by_host_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 19200 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_stages_summary_by_thread_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 38400 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_stages_summary_by_user_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 19200 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_stages_summary_global_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 150 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_statements_current | PERFORMANCE_SCHEMA | 10 | Dynamic | 2560 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_statements_history | PERFORMANCE_SCHEMA | 10 | Dynamic | 2560 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_statements_history_long | PERFORMANCE_SCHEMA | 10 | Dynamic | 10000 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_statements_summary_by_account_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 24576 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_statements_summary_by_digest | PERFORMANCE_SCHEMA | 10 | Dynamic | 10000 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_statements_summary_by_host_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 24576 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_statements_summary_by_program | PERFORMANCE_SCHEMA | 10 | Dynamic | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_statements_summary_by_thread_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 49152 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_statements_summary_by_user_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 24576 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_statements_summary_global_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 192 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_transactions_current | PERFORMANCE_SCHEMA | 10 | Dynamic | 256 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_transactions_history | PERFORMANCE_SCHEMA | 10 | Dynamic | 2560 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_transactions_history_long | PERFORMANCE_SCHEMA | 10 | Dynamic | 10000 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_transactions_summary_by_account_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 128 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_transactions_summary_by_host_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 128 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_transactions_summary_by_thread_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 256 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_transactions_summary_by_user_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 128 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_transactions_summary_global_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 1 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_waits_current | PERFORMANCE_SCHEMA | 10 | Dynamic | 1536 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_waits_history | PERFORMANCE_SCHEMA | 10 | Dynamic | 2560 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_waits_history_long | PERFORMANCE_SCHEMA | 10 | Dynamic | 10000 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_waits_summary_by_account_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 52992 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_waits_summary_by_host_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 52992 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_waits_summary_by_instance | PERFORMANCE_SCHEMA | 10 | Dynamic | 1024 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_waits_summary_by_thread_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 105984 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_waits_summary_by_user_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 52992 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | events_waits_summary_global_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 414 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | file_instances | PERFORMANCE_SCHEMA | 10 | Dynamic | 1024 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | file_summary_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 80 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | file_summary_by_instance | PERFORMANCE_SCHEMA | 10 | Dynamic | 1024 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | global_status | PERFORMANCE_SCHEMA | 10 | Dynamic | 165 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | global_variables | PERFORMANCE_SCHEMA | 10 | Dynamic | 518 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | host_cache | PERFORMANCE_SCHEMA | 10 | Dynamic | 279 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | hosts | PERFORMANCE_SCHEMA | 10 | Fixed | 128 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | memory_summary_by_account_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 40960 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | memory_summary_by_host_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 40960 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | memory_summary_by_thread_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 81920 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | memory_summary_by_user_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 40960 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | memory_summary_global_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 320 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | metadata_locks | PERFORMANCE_SCHEMA | 10 | Dynamic | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | mutex_instances | PERFORMANCE_SCHEMA | 10 | Dynamic | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | objects_summary_global_by_type | PERFORMANCE_SCHEMA | 10 | Dynamic | 1024 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | performance_timers | PERFORMANCE_SCHEMA | 10 | Fixed | 5 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | prepared_statements_instances | PERFORMANCE_SCHEMA | 10 | Dynamic | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | replication_applier_configuration | PERFORMANCE_SCHEMA | 10 | Fixed | 256 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | replication_applier_status | PERFORMANCE_SCHEMA | 10 | Fixed | 256 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | replication_applier_status_by_coordinator | PERFORMANCE_SCHEMA | 10 | Dynamic | 256 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | replication_applier_status_by_worker | PERFORMANCE_SCHEMA | 10 | Dynamic | 8192 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | replication_connection_configuration | PERFORMANCE_SCHEMA | 10 | Dynamic | 256 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | replication_connection_status | PERFORMANCE_SCHEMA | 10 | Dynamic | 256 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | replication_group_member_stats | PERFORMANCE_SCHEMA | 10 | Dynamic | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | replication_group_members | PERFORMANCE_SCHEMA | 10 | Fixed | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | rwlock_instances | PERFORMANCE_SCHEMA | 10 | Dynamic | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | session_account_connect_attrs | PERFORMANCE_SCHEMA | 10 | Dynamic | 131072 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_bin | NULL | | | | session_connect_attrs | PERFORMANCE_SCHEMA | 10 | Dynamic | 131072 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_bin | NULL | | | | session_status | PERFORMANCE_SCHEMA | 10 | Dynamic | 165 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | session_variables | PERFORMANCE_SCHEMA | 10 | Dynamic | 518 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | setup_actors | PERFORMANCE_SCHEMA | 10 | Fixed | 128 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | setup_consumers | PERFORMANCE_SCHEMA | 10 | Dynamic | 15 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | setup_instruments | PERFORMANCE_SCHEMA | 10 | Dynamic | 1077 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | setup_objects | PERFORMANCE_SCHEMA | 10 | Dynamic | 128 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | setup_timers | PERFORMANCE_SCHEMA | 10 | Dynamic | 5 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | socket_instances | PERFORMANCE_SCHEMA | 10 | Dynamic | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | socket_summary_by_event_name | PERFORMANCE_SCHEMA | 10 | Dynamic | 10 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | socket_summary_by_instance | PERFORMANCE_SCHEMA | 10 | Dynamic | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | status_by_account | PERFORMANCE_SCHEMA | 10 | Dynamic | 21120 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | status_by_host | PERFORMANCE_SCHEMA | 10 | Dynamic | 21120 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | status_by_thread | PERFORMANCE_SCHEMA | 10 | Dynamic | 42240 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | status_by_user | PERFORMANCE_SCHEMA | 10 | Dynamic | 21120 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | table_handles | PERFORMANCE_SCHEMA | 10 | Dynamic | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | table_io_waits_summary_by_index_usage | PERFORMANCE_SCHEMA | 10 | Dynamic | 1024 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | table_io_waits_summary_by_table | PERFORMANCE_SCHEMA | 10 | Dynamic | 1024 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | table_lock_waits_summary_by_table | PERFORMANCE_SCHEMA | 10 | Dynamic | 1024 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | threads | PERFORMANCE_SCHEMA | 10 | Dynamic | 256 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | user_variables_by_thread | PERFORMANCE_SCHEMA | 10 | Dynamic | 2560 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | users | PERFORMANCE_SCHEMA | 10 | Fixed | 128 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | | variables_by_thread | PERFORMANCE_SCHEMA | 10 | Dynamic | 132608 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | | | +------------------------------------------------------+--------------------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------------+----------+----------------+---------+ 87 rows in set (0.01 sec) mysql> show table status from sys; +-----------------------------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +-----------------------------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+ | host_summary | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | host_summary_by_file_io | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | host_summary_by_file_io_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | host_summary_by_stages | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | host_summary_by_statement_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | host_summary_by_statement_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | innodb_buffer_stats_by_schema | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | innodb_buffer_stats_by_table | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | innodb_lock_waits | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | io_by_thread_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | io_global_by_file_by_bytes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | io_global_by_file_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | io_global_by_wait_by_bytes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | io_global_by_wait_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | latest_file_io | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | memory_by_host_by_current_bytes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | memory_by_thread_by_current_bytes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | memory_by_user_by_current_bytes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | memory_global_by_current_bytes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | memory_global_total | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | metrics | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | processlist | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | ps_check_lost_instrumentation | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | schema_auto_increment_columns | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | schema_index_statistics | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | schema_object_overview | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | schema_redundant_indexes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | schema_table_lock_waits | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | schema_table_statistics | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | schema_table_statistics_with_buffer | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | schema_tables_with_full_table_scans | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | schema_unused_indexes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | session | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | session_ssl_status | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | statement_analysis | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | statements_with_errors_or_warnings | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | statements_with_full_table_scans | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | statements_with_runtimes_in_95th_percentile | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | statements_with_sorting | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | statements_with_temp_tables | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | sys_config | InnoDB | 10 | Dynamic | 6 | 2730 | 16384 | 0 | 0 | 0 | NULL | 2015-10-25 12:57:08 | NULL | NULL | utf8_general_ci | NULL | | | | user_summary | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | user_summary_by_file_io | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | user_summary_by_file_io_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | user_summary_by_stages | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | user_summary_by_statement_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | user_summary_by_statement_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | version | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | wait_classes_global_by_avg_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | wait_classes_global_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | waits_by_host_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | waits_by_user_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | waits_global_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$host_summary | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$host_summary_by_file_io | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$host_summary_by_file_io_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$host_summary_by_stages | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$host_summary_by_statement_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$host_summary_by_statement_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$innodb_buffer_stats_by_schema | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$innodb_buffer_stats_by_table | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$innodb_lock_waits | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$io_by_thread_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$io_global_by_file_by_bytes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$io_global_by_file_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$io_global_by_wait_by_bytes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$io_global_by_wait_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$latest_file_io | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$memory_by_host_by_current_bytes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$memory_by_thread_by_current_bytes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$memory_by_user_by_current_bytes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$memory_global_by_current_bytes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$memory_global_total | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$processlist | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$ps_digest_95th_percentile_by_avg_us | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$ps_digest_avg_latency_distribution | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$ps_schema_table_statistics_io | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$schema_flattened_keys | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$schema_index_statistics | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$schema_table_lock_waits | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$schema_table_statistics | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$schema_table_statistics_with_buffer | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$schema_tables_with_full_table_scans | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$session | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$statement_analysis | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$statements_with_errors_or_warnings | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$statements_with_full_table_scans | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$statements_with_runtimes_in_95th_percentile | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$statements_with_sorting | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$statements_with_temp_tables | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$user_summary | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$user_summary_by_file_io | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$user_summary_by_file_io_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$user_summary_by_stages | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$user_summary_by_statement_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$user_summary_by_statement_type | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$wait_classes_global_by_avg_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$wait_classes_global_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$waits_by_host_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$waits_by_user_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | | x$waits_global_by_latency | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | VIEW | +-----------------------------------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+ 101 rows in set (0.04 sec)