You are here

Home

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 |
+------------------+-------------------------------------+

Taxonomy upgrade extras: 
general query log

Kalasha,
You might need to execute the SQL statement (FLUSH LOGS;) and then check the log files.
abdel-mawlacomment 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
kalashacomment Thu, 2014-03-20 12:44

Are you using FILE or TABLE as log output ?
Try "show global variables like'log_output';"
abdel-mawlacomment Thu, 2014-03-20 13:00

Sir, Log_output is showing none
kalashacomment Fri, 2014-03-21 06:19

OK. Try to set log_ouput to table with:

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