如何获得MySQL服务器上当前正在运行的所有查询的完整列表? [英] How can I get a full list of all queries currently running on my MySQL server?

问题描述

我正在使用MySQL Administrator和MySQL Workbench查看我当前的线程和连接，并且查询在这些应用程序中显示，但是它太长了并且无法在屏幕上显示.

I am using MySQL Administrator and MySQL Workbench to view my current threads and connections, and the query is shown within those apps, but it's just way too long and runs off the screen.

查看所有查询多长时间的简单方法是什么?有没有我可以运行的简单SQL语句?

What is a simple way to see all queries no matter how long they are? Is there a simple SQL statement I can just run?

推荐答案

运行以下命令以查看输出中的完整查询:

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

mysql>SHOW FULL PROCESSLIST;

在此处查找更多信息: 如何从SHOW 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.

这篇关于如何获得MySQL服务器上当前正在运行的所有查询的完整列表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！