Hello,

I just discovered that there are slow queries and queries not using indexes in my database. If I want to log only queries not using indexes, which lines should I uncomment?

#log_slow_queries       = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes

Are queries without indexes using the same log file which is for slow queries?

What is the default long_query_time if I don't uncomment it in my.cnf?

Thanks.

    Write a Reply...