measuring mysql data transfer?
I'm wondering if there's any way to measure data transfer made between a remote mysql client, and a mysql daemon residing on my own server.Specifically, in a database hosting enviroment. Is my only hope to put each user on their own ip address, and use ifconfig to monitor bandwidth usage? Is there any way to monitor bandwidth usage on a per mysql user basis?
Thanks.