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.
Tried on own 10.0.21 and did not have the same issue directly.
But way to achieve this was to enable log_queries_not_using_indexes as just direct count does not use indexes. Check your my.cnf or from CLI check if the variable is set with SELECT @@log_queries_not_using_indexes;