Advertisement
jcrespeau

SLAVE A - MYSQL FULL PROCESSLIST;

Jan 26th, 2021 (edited)
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.51 KB | None | 0 0
  1. mysql> SHOW FULL PROCESSLIST;
  2. +-----------+-------------+----------------------------+-----------+---------+---------+--------------------------------------------------------+-----------------------+
  3. | Id        | User        | Host                       | db        | Command | Time    | State                                                  | Info                  |
  4. +-----------+-------------+----------------------------+-----------+---------+---------+--------------------------------------------------------+-----------------------+
  5. |  51942024 | system user |                            | NULL      | Connect | 6430333 | Waiting for master to send event                       | NULL                  |
  6. |  86437124 | system user |                            | NULL      | Connect |       2 | Slave has read all relay log; waiting for more updates | NULL                  |
  7. | 104777972 | root        | localhost                  | NULL      | Query   |       0 | starting                                               | SHOW FULL PROCESSLIST |
  8. | 104777998 | live   | server1:33178 | live | Sleep   |     120 |                                                        | NULL                  |
  9. | 104778038 | live   | server1:33834 | live | Sleep   |     120 |                                                        | NULL                  |
  10. +-----------+-------------+----------------------------+-----------+---------+---------+--------------------------------------------------------+-----------------------+
  11. 5 rows in set (0.02 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement