If I have a PHP script that makes a MySQL call/query. Is there a way to log/audit the size of the response/data (in bytes) that is returned from that call?
I know I could use tcpdump
, but that does not necessarily ensure the traffic stats I gather are for a certain transaction (IE: I may have 5 transactions at roughly the same time, making it impossible to determine one transaction from another).
mysqli has a couple of functions that will give you some stats:
Some of the statistics available include:
Take a look at this page to see the all the stats you can get if you're using the MySQL Native Driver: MySQL Native Driver statistics