Tuesday, March 18

What is the current status of MySQL server?

# mysqladmin -u root -ptmppassword status 
Uptime: 9267148 
Threads: 1 Questions: 231977 Slow queries: 0 Opens: 17067 
Flush tables: 1 Open tables: 64 Queries per second avg: 0.25

The status command displays the following information:
  • Uptime: Uptime of the mysql server in seconds
  • Threads: Total number of clients connected to the server.
  • Questions: Total number of queries the server has executed since the startup.
  • Slow queries: Total number of queries whose execution time waas more than long_query_time variable’s value.
  • Opens: Total number of tables opened by the server.
  • Flush tables: How many times the tables were flushed.
  • Open tables: Total number of open tables in the database.

No comments:

Post a Comment