mysql - 关于mysql显示进程列表

Question

我已通过mysql -uroot -p连接到mysql控制台，然后使用命令show processlist;列出进程，但我看不到结果，可能是命令太长，该列只允许85个字符左右，命令应该超出限制，我怎样才能看到完整的命令？

谢谢

Answer 1

您应该尝试显示完整的进程列表

SHOW PROCESSLIST shows you which threads are running. You can also get this information from the INFORMATION_SCHEMA PROCESSLIST table or the mysqladmin processlist command. If you have the PROCESS privilege, you can see all threads. Otherwise, you can see only your own threads (that is, threads associated with the MySQL account that you are using). If you do not use the FULL keyword, only the first 100 characters of each statement are shown in the Info field.

如果您不使用 FULL，查询将在结果中被截断。