I want to "swtich" on the sql query profiler for my php/mysql site and leave it ru nnig for a while.
The idea is to capture usage details over a day and then analayze the queries and work out which ones need tweaking...
I did this from the command prompt (mysql):
mysql> show profiles; Empty set (0.00 sec) mysql> set profiling=1; Query OK, 0 rows affected (0.00 sec) // loaded the website mysql> show profiles; Empty set (0.00 sec)
But no results. How do i turn it on for the website?