Comments - Slow query log and long_query_time
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Most likely you have log_queries_not_using_indexes enabled in your my.cnf, this would explain the issue as the count() you are using does not use indexes. Also quick way to check if it is enable through CLI with next query: SELECT @@log_queries_not_using_indexes;
Did try on own 10.0.21 and did not have this on by default and could not replicate the problem without enable previously mentioned attribute;
I haven't realized that I have enabled set log_queries_not_using_indexes.Thank you!
Denis