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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s