Slow_queries Count in MariaDb keeps Incrementing

Products

• VMware Integrated OpenStack

Issue/Introduction

• The slow query counts are increasing over time in mariaDB.
  
  osctl exec -it mariadb-server-0 -- mysql --defaults-file=/etc/mysql/admin_user.cnf --host=localhost -e 'SHOW GLOBAL STATUS like "%slow%"'

           +---------------------+----------+
           | Variable_name       | Value    |
           +---------------------+----------+
           | Slow_launch_threads | 0        |
           | Slow_queries        | 21628653 |
           +---------------------+----------+

• No performance impact or performance issues reported.
  
  
• Service/deployment restart will reset the values.

Environment

7.3

Cause

This value is set on mariadb, log_queries_not_using_indexes=ON;  Per the mariadb upstream documentation, when this value is set to ON, all non-indexed queries will be recorded regardless of execution time.

Resolution

This is not an issue on its own  as long as there are no performance issues noticed.