My Blog

Tips…

Helpful guide to enable dynamic logging of SQL queries on MySQL (xampp). Link

To enable Profiling on MySQL:

mysql> set profiling=1;
Query OK, 0 rows affected (0.00 sec)

To view SQL Profiles:

mysql> show profiles;

For additional instructions, go to: http://dev.mysql.com/tech-resources/articles/using-new-query-profiler.html

Steps:

1. Run ‘Command Prompt’
Start > Run > Type ‘cmd’ then click ‘Ok’

2. Go to MySQL bin folder
Type “cd c:\xampp\mysql\bin

3. Then, type ‘mysql -u root -p’

For additional instructions, go to this site: http://www.makeyougohmm.com/20040609/806/