You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
Version 1
Next »
\n
\n
\nRelated Documentation |
\nVersion of up.time
\naffected |
\nAffected Platforms |
\n
\n
\n
\n |
\nAll |
\nAll |
\n
\n
\n
\n
\n
The up.time MySQL Advanced Metrics monitor collects the following performance metrics from a MySQL database:
\n
\n
\n
\n\tMetric |
\n\tExplanation |
\n
\n
\n\tUptime |
\n
\n\tThe number of seconds that MySQL has been running. |
\n
\n
\n\tQuestions |
\n\tThe number of queries that have been sent to the database. |
\n
\n
\n\tSlow Queries |
\n\tThe number of queries that take longer than long_query_time to complete. |
\n
\n
\n
\n\tOpen Tables |
\n\tThe number of database tables that are opened independently by each concurrent thread. |
\n
\n
\n\tQPSA |
\n\tThe average number of queries, per second, that must be exceeded before up.time generates an alert. |
\n
\n
\n
\n\tBytes Received |
\n\tThe number of bytes received by the server. |
\n
\n
\n
\n\tBytes Sent |
\n\tThe number of bytes sent by the server to all clients. |
\n
\n
\n\tDelayed Insert Threads |
\n\tThe number of delayed insert threads that must be exceeded before up.time sends an alert. |
\n
\n
\n\tDelayed Errors |
\n
\n\tThe number of delayed insert threads that had an error. |
\n
\n
\n\tMax Used Connections |
\n
\n\tThe maximum number of connections that have been in simultaneous use since the server was started. |
\n
\n
\n
\n
\n\tThreads Connected |
\n\tThe maximum number of clients that can be connected to the database at any one time. |
\n
\n
\n\tThreads Running |
\n
\n\tThe number of threads that are running, which can be used to determine whether or not the database is becoming overloaded. |
\n
\n
\n
\n\tQCache Inserts |
\n\tThe number of queries added to the query cache. |
\n
\n
\n
\n\tQCache Hits |
\n\tThe 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\tQCache Lowmem Prunes |
\n\tThe number of QCache_lowmem_prunes that can be deleted from the cache because of low memory. |
\n
\n
\n\tQCache Not Cached |
\n\tThe maximum number of queries that are not cached. |
\n
\n
\n\tQCache Free Memory |
\n\tThe amount of free memory for the query cache. |
\n
\n
\n\tQCache Free Blocks |
\n\tThe number of free memory blocks in query cache. |
\n
\n
\n\tQCache Table Blocks |
\n\tThe amount of query cache memory fragmentation. |
\n
\n
\n