I am using MySQL 5.5 with Amazon Linux 2013. Following is my configuration for log file.
slow_query_log = 1
long_query_time=0
log-error = /var/log/mysqld.log
slow_query_log_file = /var/log/mysqld_slow_query.log
general-log = 'ON'
log_queries_not_using_indexes = 1
general_log_file = /var/log/mysqld_normal.log
log = /var/log/mysqld_normal.log
But, It is not logging the queries in log file. particularly I have to find the queries which is not using Index at all.
Please help me on this. Thank you.
Best Answer
For logging slow queries do like below, It will log all queries those are not using indexes as well as which are taking more than 1 sec
For Error log
For general log