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.