什么是PHP的MySQL调试工具?

I'm looking for something like firebug but to monitor & log all the processed MySQL queries with the syntax, processing time, and fetched rows count and size. All that should be printed on the bottom of the page, so it should be something includable on the finish of the php code.

I'm not using any frameworks or libraries, just pure PHP and MySQL.

Any tools recommendations?

Thanks

2个回答



只需使用mysql常规日志即可。 创建一个运行这两个查询的包含文件,并显示第二个查询的输出。</ p>

  SET GLOBAL general_log ='ON'; 

SELECT * FROM mysql.general_log;

</ code> </ pre>
</ div>

展开原文

原文

Just use the mysql general log. Create an include file that runs these two queries and display the output of the 2nd one.

SET GLOBAL general_log = 'ON';

SELECT * FROM mysql.general_log;



如果您在MySQl服务器上没有完全访问权限,或者在那里运行的数据库太多,那么您只是 想要你的应用程序日志,你可以使用“mysql代理”。 它是一个非常有用的工具,用于捕获特定应用程序和数据库之间的所有通信(以及查询)。 http://forge.mysql.com/wiki/MySQL_Proxy </ p>
</ DIV>

展开原文

原文

If you don't have complete access on the MySQl server, or if there're too much databases running there, and that you just want your app logs you could use "mysql proxy". It's a very usefull tools to catch all the communications (so queries as well) between your specific app and the Database. http://forge.mysql.com/wiki/MySQL_Proxy

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
立即提问
相关内容推荐