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?