General Query Log & Slow query log is not working

Thu, 2014-03-20 11:48 — kalasha

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 |
+------------------+-------------------------------------+
tags: 
general query log

Comments

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

abdel-mawla comment Thu, 2014-03-20 12:26

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

kalasha comment Thu, 2014-03-20 12:44

Are you using FILE or TABLE as log output ?
Try “show global variables like’log_output’;”

abdel-mawla comment Thu, 2014-03-20 13:00

Sir,

Log_output is showing none

kalasha comment Fri, 2014-03-21 06:19

OK. Try to set log_ouput to table with:

SET GLOBAL log_output = 'table';
oli comment Fri, 2014-03-21 09:55