PDA

View Full Version : MYSQL query statistic


mrazicek
30th June 2008, 23:35
Hi.

I have MYSQL 5 server on Debian Linux and I want to view query statistic for each mysql user separately. I found through google this patch on mysql:
http://www.mysqlperformanceblog.com/2008/04/24/mysql-extensions-for-hosting/

But I don't now how to patch MYSQL with that diff file.

Have someone any idea? Or know someone other method to monitor per user query statistic?

falko
2nd July 2008, 00:13
You'd have to patch the MySQL sources and then compile MySQL yourself. Are you sure you want to do this?

mrazicek
2nd July 2008, 01:01
You'd have to patch the MySQL sources and then compile MySQL yourself. Are you sure you want to do this?

NO, I want simple way to view number of queries per user