Information_schema schema Table introduction processlist

The information_schema schema table introduces processlist in mysql. We generally use show (full) processlist to view the current connection and handle various database problems. Now in information_schema mode, the processlist table is added after 5.5, which stores the current connection information, which is the same as that stored in show (full) processlist. Through processlist, we can analyze and analyze some information, instead of relying on shell commands (such as grep and awk), such as querying the connection information of the current ip address mysql> select substring_index (host ,':', 1), count (*) from processlist group by substring_index (host, ':', 1); at the same time, related tables such as innodb Storage engine performance information are added, the following table starting with innodb mysql> select database (); + -------------------- + | database () | + -------------------- + | information_schema | + ------------------ + 1 row in set (0.00 sec) mysql> show tables; + variables + | Tables_in_information_schema | + variables + | CHARACTER_SETS | COLLATIONS | EVENTS | COLUMNS | COLUMN_PRIVILEGES | ENGINES | EVENTS | FILES | GLOBAL_STATUS | GLOBAL_VARIABLES | KEY_COLUMN_USAGE | PARAMETERS | PARTITIONS | PLUGINS | PROCESSLIST | PROFILING | metrics | ROUTINES | SCHEMATA | metrics | SESSION_STATUS | SESSION_VARIABLES | STATISTICS | TABLES | TABLESPACES | TABLE_CONSTRAINTS | TABLE_PRIVILEGES | TRIGGERS | USER_PRIVILEGES | VIEWS | catalog | INNODB_TRX | catalog | INNODB_CMP | INNODB_LOCKS | | INNODB_CMPMEM_RESET | INNODB_CMP_RESET | INNODB_BUFFER_PAGE_LRU | + ------------------------------------- + 40 rows in set (0.01 sec)