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 thelong_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 theflush,refresh, andreloadcommands.Open tables: This value indicates the number of tables...