Counting the number of select statements, connections per user in MySQL
Posted
by Michelangelo
on Stack Overflow
See other posts from Stack Overflow
or by Michelangelo
Published on 2010-02-15T10:35:37Z
Indexed on
2010/04/10
21:03 UTC
Read the original article
Hit count: 309
mysql
|mysql-query
Hi guys,
how can I count the number of connection and queries by user per day? I need a little list of users, previously registered in my MySQL Server, with the total of the queries and connections.
For instance:
users | Queries
user01 | 120000
user02 | 340000
user03 | 1540000
user04 | 1244000
thanks
© Stack Overflow or respective owner