Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 

\n \n \n \n \n \n \n \n \n \n \n \n \n
Related DocumentationVersion of up.time \naffectedAffected Platforms
\nAllAll

...

The up.time MySQL Advanced Metrics monitor collects the following performance metrics from a MySQL database:

...

 

 

\n \n\tMetric \n\tExplanation \n \n \n\tUptime \n \n\t
MetricExplanation
Uptime
The number of seconds that MySQL has been running.
\n \n \n\t
Questions
\n\t
The number of queries that have been sent to the database.
\n \n \n\t
Slow Queries
\n\t
The number of queries that take longer than long_query_time to complete.
\n \n \n \n\t
Open Tables
\n\t
The number of database tables that are opened independently by each concurrent thread.
\n \n \n\t
QPSA
\n\t
The average number of queries, per second, that must be exceeded before up.time generates an alert.
\n \n \n
\n\t
Bytes Received
\n\t
The number of bytes received by the server.
\n \n \n \n\t
Bytes Sent
\n\t
The number of bytes sent by the server to all clients.
\n \n \n\t
Delayed Insert Threads
\n\t
The number of delayed insert threads that must be exceeded before up.time sends an alert.
\n \n \n\t
Delayed Errors
\n \n\t
The number of delayed insert threads that had an error.
\n \n \n\t
Max Used Connections
\n \n\t
The maximum number of connections that have been in simultaneous use since the server was started.
\n \n \n \n \n\t
Threads Connected
\n\t
The maximum number of clients that can be connected to the database at any one time.
\n
\n \n\t
Threads Running
\n \n\t
The number of threads that are running, which can be used to determine whether or not the database is becoming overloaded.
\n \n \n
\n\t
QCache Inserts
\n\t
The number of queries added to the query cache.
\n \n \n \n\t
QCache Hits
\n\t
The number of hits to the query cache (qcache_hits) to determine the number of query results taken directly from the cache instead of executing them.
\n
\n \n \n\t
QCache Lowmem Prunes
\n\t
The number of QCache_lowmem_prunes that can be deleted from the cache because of low memory.
\n \n \n\t
QCache Not Cached
\n\t
The maximum number of queries that are not cached.
\n
\n \n\t
QCache Free Memory
\n\t
The amount of free memory for the query cache.
\n
\n \n\t
QCache Free Blocks
\n\t
The number of free memory blocks in query cache.
\n \n \n\t
QCache Table Blocks
\n\t
The amount of query cache memory fragmentation.
\n \n \n