You are here

General Query Log & Slow query log is not working

I have enabled the General Query Log and the Slow Query Log in MySQL 5.6.13 in windows server. File is created but sql statement are not capturing. This is production server now its not possible to restart.

Kindly help me to solve the issue.

mysql> show global variables like 'slow%';
+---------------------+----------------------------------------+
| Variable_name       | Value                                  |
+---------------------+----------------------------------------+
| slow_launch_time    | 2                                      |
| slow_query_log      | ON                                     |
| slow_query_log_file | F:/MySQL DataFiles/data/Slow_Query.log |
+---------------------+----------------------------------------+

mysql> show global variables like 'general%';
+------------------+-------------------------------------+
| Variable_name    | Value                               |
+------------------+-------------------------------------+
| general_log      | ON                                  |
| general_log_file | F:/MySQL DataFiles/data/General.log |
+------------------+-------------------------------------+

Taxonomy upgrade extras: 

Kalasha,
You might need to execute the SQL statement (FLUSH LOGS;) and then check the log files.
abdel-mawlacomment

Hi, I executed flush logs command even though queries are not capturing. I am facing slowness in server during to high memory usage. MySQL and Tomcat are running in same server. OS - windows Server 2008 R2 MySQL version- 5.6.13 64 Bit Memory - 7 GB Memory assigned for innodb_buffer_pool_size=4GB key buffer size =8 M join_buffer_size-256K Images are server in a drive and image path is save in one table and in another table TEXT data type is used
kalashacomment

Are you using FILE or TABLE as log output ?
Try "show global variables like'log_output';"
abdel-mawlacomment

Sir, Log_output is showing none
kalashacomment

OK. Try to set log_ouput to table with:

SET GLOBAL log_output = 'table';
olicomment