Enabled slow queries will hit performance

Enabled Slow Queries

check log status

mysql>show variables like 'log_%'; 

The config file should be named my.ini or my.cnf.

In Linux, file would be located at /etc; in Windows would be locate in mysql_home\bin

To enable slow queries, put this section in your config file

# log-error="mysql/logs/error.log"  
# log="mysql/logs/mysql.log"
# logging query every 2 seconds    
#if query is more then long_query_time seconds, it will be logging.  
# log-slow-queries= "mysql/logs/slowquery.log"  

<note note> You need to restart mysql after configured. <note>