watch requests between db server and client
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.
精彩评论