如何从SHOW PROCESSLIST看完整的查询 [英] How to see full query from SHOW PROCESSLIST

问题描述

当我发出SHOW PROCESSLIST查询时，信息列仅返回正在运行的SQL查询的前100个字符.

When I issue SHOW PROCESSLIST query, only first 100 characters of the running SQL query are returned in the info column.

是否可以更改Mysql配置或发出不同类型的请求以查看完整查询(我正在查看的查询超过100个字符)

Is it possible to change Mysql config or issue a different kind of request to see complete query (the queries I'm looking at are longer than 100 characters)

推荐答案

SHOW FULL PROCESSLIST

如果不使用FULL，则仅每个语句的前100个字符显示在Info字段" .

If you don't use FULL, "only the first 100 characters of each statement are shown in the Info field".

使用phpMyAdmin时，还应单击全文"选项(结果表左上角的←T→")以查看未删减的结果.

When using phpMyAdmin, you should also click on the "Full texts" option ("← T →" on top left corner of a results table) to see untruncated results.

这篇关于如何从SHOW PROCESSLIST看完整的查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！