当前位置: 动力学知识库 > 问答 > 编程问答 >

sql - How can I get a full list of all queries currently running on my MySQL server?

问题描述:

This question already has an answer here:

  • How can I view live MySQL queries?

    11 answers

网友答案:

Run the following command in order to see full query in the output:

mysql>SHOW FULL PROCESSLIST;

Look for more information here: How to see full query from SHOW PROCESSLIST

In order to see all queries you MUST have PROCESS privilege.

网友答案:

Run the following command:

mysql> show processlist;
分享给朋友:
您可能感兴趣的文章:
随机阅读: