Check sql statement executed in mysql

mysql> SHOW VARIABLES LIKE “general_log%”;

+——————+—————————-+
| Variable_name | Value |
+——————+—————————-+
| general_log | OFF |
| general_log_file | /var/run/mysqld/mysqld.log |
+——————+—————————-+

mysql> SET GLOBAL general_log = ‘ON’;

mysql> SET GLOBAL general_log = ‘OFF’;

http://stackoverflow.com/questions/568564/how-can-i-view-live-mysql-queries

Advertisements