重要字段：
Id： 连接标识符 可以进行连接查询 information_schema.processlist.ID performance_schema.threads.processlist_id
command:
A thread can have any of the following Command values:
Binlog Dump
This is a thread on a master server for sending binary log contents to a slave server.
Change user
The thread is executing a change-user operation.
Close stmt
The thread is closing a prepared statement.
Connect
A replication slave is connected to its master.
Connect Out
A replication slave is connecting to its master.
Create DB
The thread is executing a create-database operation.
Daemon
This thread is internal to the server, not a thread that services a client connection.
Debug
The thread is generating debugging information.
Delayed insert
The thread is a delayed-insert handler.
Drop DB
The thread is executing a drop-database operation.
Error
Execute
The thread is executing a prepared statement.
Fetch
The thread is fetching the results from executing a prepared statement.
Field List
The thread is retrieving information for table columns.
Init DB
The thread is selecting a default database.
Kill
The thread is killing another thread.
Long Data
The thread is retrieving long data in the result of executing a prepared statement.
Ping
The thread is handling a server-ping request.
Prepare
The thread is preparing a prepared statement.
Processlist
The thread is producing information about server threads.
Query 这个状态比较多
The thread is executing a statement.
Quit
The thread is terminating.
Refresh
The thread is flushing table, logs, or caches, or resetting status variable or replication server information.
Register Slave
The thread is registering a slave server.
Reset stmt
The thread is resetting a prepared statement.
Set option
The thread is setting or resetting a client statement-execution option.
Shutdown
The thread is shutting down the server.
Sleep 这个状态比较多
The thread is waiting for the client to send a new statement to it.
Statistics
The thread is producing server-status information.
Table Dump
The thread is sending table contents to a slave server.
Time
Unused.
time: 处于当前状态的时间
state:
copy to tmp table 发生在alter 命令时 performance_schema 可以查看进度，需要开启相应的监控项performance_schema.setup_instruments
stage/sql/copy to tmp tableCopying to tmp table 拷贝内存里的临时表
更多 参考 https://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html
info: 默认显示100字符，显示全部使用show full processlist 命令