Watch Mysql queries in real time

command-line-prompt

$> tail -f -n 100 /var/lib/mysql/devint1.log

...

 8941 Prepare	select * from `stepFeed` where `productId` = ? limit 1

 8941 Execute	select * from `stepFeed` where `productId` = '764773' limit 1

mysql-prompt

mysql> SHOW VARIABLES LIKE "general_log%";

+------------------+----------------------------+

| Variable_name    | Value                      |

+------------------+----------------------------+

| general_log      | OFF                        |

| general_log_file | /var/lib/mysql/devint1.log |

+------------------+----------------------------+

2 rows in set (0.00 sec)



mysql> SET GLOBAL general_log = 'ON';

Query OK, 0 rows affected (0.00 sec)