I have a MySQL server running with about 50 users. I am looking for a way to tell which users are still actively accessing the server, which accounts are used.
I already thought about grep-ping binary logs over a longer period, but they do not contain this information.
I also though about
show processlist which is done by this. But polling a busy server (300 queries per second) seems useless.
How can I achieve this? Server is MySQL 4.1 on Debian 4.0.