IDERA

article MySQL Advanced Metrics

Related Documentation Version of up.time affected Affected Platforms
All All

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

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

Article Info

Index: 126
Author: CSS
Created: 1-26-2007
Updated: 7-4-2011
Views: 5024
Rating:

Options

Rate This Article

Email This Article

Print This Article

Quick Links

Related Articles
User Comments

Related Articles

Oracle Advanced Metrics service monitor

RatingViews
article

This article outlines the performance metrics that the up.time Oracle Advanced Metrics monitor collects from an Oracle database.

By: uptime Support | Date Created: 1-23-2007 | Last Modified: 7-4-2011 | Index: 121

   7730

SQL Server Advanced Metrics

RatingViews
article

This article outlines the performance metrics that the up.time SQL Server Advanced Metrics monitor collects from a SQL Server database.

By: uptime Support | Date Created: 1-23-2007 | Last Modified: 1-3-2012 | Index: 122

   5690

How to monitor MySQL Databases with up.time

RatingViews
article

Find out how to use up.time to effectively monitor your MySQL servers and database structures.

By: uptime Support | Date Created: 5-17-2007 | Last Modified: 6-28-2011 | Index: 176

   11380

Securing the up.time MySQL Database

RatingViews
article

By: uptime Support | Date Created: 3-3-2006 | Last Modified: 7-28-2011 | Index: 058

   4332

Shrinking your MySQL DataStore

RatingViews
article

At times it may be necessary to reduce the disk space that your MySQL DataStore consumes on your monitoring station. The process of reducing your DataStore size follows the general steps that are...

By: uptime Support | Date Created: 7-31-2006 | Last Modified: 2-19-2014 | Index: 088

   11558

User Comments

No comments have been posted.

Copyright © 2021 IDERA, Inc.   Legal   Privacy Statement