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 ...

Get Troubleshooting CentOS now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial