mysql> desc schema_table_lock_waits;

+------------------------------+---------------------+------+-----+---------+-------+

| Field                        | Type                | Null | Key | Default | Extra |

+------------------------------+---------------------+------+-----+---------+-------+

| object_schema                | varchar(64)         | YES  |     | NULL    |       |

| object_name                  | varchar(64)         | YES  |     | NULL    |       |

| waiting_thread_id            | bigint(20) unsigned | NO   |     | NULL    |       |

| waiting_pid                  | bigint(20) unsigned | YES  |     | NULL    |       |

| waiting_account              | text                | YES  |     | NULL    |       |

| waiting_lock_type            | varchar(32)         | NO   |     | NULL    |       |

| waiting_lock_duration        | varchar(32)         | NO   |     | NULL    |       |

| waiting_query                | longtext            | YES  |     | NULL    |       |

| waiting_query_secs           | bigint(20)          | YES  |     | NULL    |       |

| waiting_query_rows_affected  | bigint(20) unsigned | YES  |     | NULL    |       |

| waiting_query_rows_examined  | bigint(20) unsigned | YES  |     | NULL    |       |

| blocking_thread_id           | bigint(20) unsigned | NO   |     | NULL    |       |

| blocking_pid                 | bigint(20) unsigned | YES  |     | NULL    |       |

| blocking_account             | text                | YES  |     | NULL    |       |

| blocking_lock_type           | varchar(32)         | NO   |     | NULL    |       |

| blocking_lock_duration       | varchar(32)         | NO   |     | NULL    |       |

| sql_kill_blocking_query      | varchar(31)         | YES  |     | NULL    |       |

| sql_kill_blocking_connection | varchar(25)         | YES  |     | NULL    |       |

+------------------------------+---------------------+------+-----+---------+-------+

18 rows in set (0.00 sec)

每行记录描述的意义一览便知，本文不一一赘述

MySQL5.7 新特性诸多，单单是sys schema这一个特性又岂是三言两语能说明白的，本文只是略微列举一二，希望能引起各位看客朋友们探索的欲望。