Obtaining metrics from MariaDB and MySQL

Metrics not only enable you to build a character analysis of your database server, but they can provide evidence of an unexpected behavior. For the troubleshooter, this type of data is important and that can be obtained by running the following command:

# mysqladmin -u root -p status

The output will provide the following information:

• Uptime: This value represents the number of seconds the database server has been running.

• Threads: This value indicates the number of connected clients.

• Questions: This value indicates the number of queries served since the database server was started.

• Slow queries: This value indicates the number of queries that have exceeded the long_query_time.

• Opens: This value indicates the number of tables that have been served to clients.

• Flush tables: This value indicates the number of flush requests served by the database server. This includes the flush, refresh, and reload commands.

• Open tables: This value indicates the number of tables...