How can I check on my MySQL server the follow:
what accounts have an open connection to the mysql-server ?
how often they request a new connection ?
how many requests they usually do per connection ?
It would be nice if I could aswell identify the codes that are making the calls aswell like, let's say:
/home/domainX/public_html/db.pl or /home/domainX/public_html/index.php
I guess this last part is only available if it is a socket call right ?