How to profile MySQL

Question

How do I profile a MySQL database. I want to see all the SQL being run against a database.

I know you can do this:

• type set profiling=1;
• Run your slow query (eg SELECT * FROM messages WHERE fromaddress='xxx';)
• type SHOW PROFILES;

But this seem to only apply to stuff run on the command line, I want to see the results from running a website.

Answer 1

You can simply parse the query log in real time. If on linux, you can use tail -f to see the log live

Also, you can try some free software from these guys:

http://hackmysql.com/mysqlsla

Answer 2

there is a product that cost money

http://www.webyog.com/en/

Answer 3

You want the query log - but obviously doing this on a heavy production server could be... unwise.

Answer 4

MySqlAdministrator have some useful build in features (including logs view), but for logs it have to be run on same machine as database