开发者

watch requests between db server and client

开发者 https://www.devze.com 2022-12-11 07:53 出处:网络
Is there any tool which can monitor the requests and responses between a MySQL server and clients? Basically I want to know how many requests my web app makes to the mysql server and analyze the perfo

Is there any tool which can monitor the requests and responses between a MySQL server and clients? Basically I want to know how many requests my web app makes to the mysql server and analyze the performance.

开发者_运维知识库

Is there any similar thing available for MSSQL server also?


Here is a bash script to monitor MySQL requests: http://blog.taragana.com/index.php/archive/monitoring-mysql-queries-using-bash-script/ And here is web-based variant of monitor: http://webyog.com/en/ (check out MONyog screenshots to understand is it really what you need).


Wireshark will do the trick. Wireshark is a general purpose protocol analyser and includes fitlers for a variety of applications including Mysql.


I've never used it myself, but MySQL proxy should do what you want.

0

精彩评论

暂无评论...
验证码 换一张
取 消