mysql> show processlist;
+----+-----------------+-----------+------+---------+--------+--------------------------------------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-----------------+-----------+------+---------+--------+--------------------------------------------------------+------------------+
| 1 | event_scheduler | localhost | NULL | Daemon | 141366 | Waiting on empty queue | NULL |
| 13 | root | localhost | NULL | Query | 0 | starting | show processlist |
| 14 | system user | | NULL | Connect | 49 | Waiting for master to send event | NULL |
| 15 | system user | | NULL | Connect | 48 | Slave has read all relay log; waiting for more updates | NULL |
| 16 | system user | | NULL | Connect | 49 | Waiting for an event from Coordinator | NULL |
| 17 | system user | | NULL | Connect | 49 | Waiting for an event from Coordinator | NULL |
| 18 | system user | | NULL | Connect | 49 | Waiting for an event from Coordinator | NULL |
| 19 | system user | | NULL | Connect | 49 | Waiting for an event from Coordinator | NULL |
| 20 | system user | | NULL | Connect | 49 | Waiting for an event from Coordinator | NULL |
| 21 | system user | | NULL | Connect | 49 | Waiting for an event from Coordinator | NULL |
| 22 | system user | | NULL | Connect | 49 | Waiting for an event from Coordinator | NULL |
| 23 | system user | | NULL | Connect | 49 | Waiting for an event from Coordinator | NULL |
+----+-----------------+-----------+------+---------+--------+--------------------------------------------------------+------------------+
12 rows in set (0.00 sec)
mysql> show variables like 'slave_parallel%';
+------------------------+---------------+
| Variable_name | Value |
+------------------------+---------------+
| slave_parallel_type | LOGICAL_CLOCK |
| slave_parallel_workers | 8 |
+------------------------+---------------+
2 rows in set (0.00 sec)
mysql>
5458
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
