MySQL Queries per second avg from 40 to 100
I got the server with a bit high load average, around 1.4-1.8 almost all the time.
MySQL uses about 80-90% of CPU1 so I know it's because of mysql.
If i check mysql status I get:
Queries per second avg: 44.034
40 is as low as it gets...sometimes its up to 80 or even over a 100 queries/sec
The mysql slow query log doesn't show any long running queries so my question is: how can I find out which mysql user that executes the most queries to mysql on this server?
If I log all queries to a file I get all executed queries...but that file is USELESS for the human eye...I need a way to create some nice stats...but haven't found any *working* script that can parse the log. Me=no perl expert.
Any ideas on a solution to my problem?
thanks for your help...
