Reading this article you will learn how to create a Customized Performance Report for one of your MySQL™ Servers using HoneyMonitor, a GUI for MySQL™ Server Administration, Monitoring & Performance Tuning.

Contents

• Introduction
• Step 1 - Choosing a File Name and Opening the Report Designer
• Step 2 - Editing the SQL Queries used by the Report
• Step 3 - Editing the Charts contained in the Report
  • Axis Name
  • Series
• Step 4 - Other minor changes
• Step 5 - Previewing our Customized Report
• Few Considerations and Useful Tips
  • Actual Date Interval
  …

[HoneyMonitor is a MySQLTM GUI Tool for WindowsTM Systems. Server Administration, Database and Database Objects Administration, Code Development, Server Monitoring, Performance Monitoring, Performance Auditing. Read more on http://www.honeysoftware.com]

We are pleased to announce the availability of HoneyMonitor Pro and HoneyMonitor Audit Pro!

Press Release available at:
http://www.honeysoftware.com/news/pressreleases/20080714-honeymonitor-performance-tuning.php.

The …

information_schema.global_variables and information_schema.global_status are two useful tables for getting information on the MySQL® server configuration and status. They have been introduced in MySQL® version 5.1.

You know that some status variables are ‘raw’ and they need a little manipulation to bring a kind of useful information. For example, let’s consider the variable BYTES_RECEIVED (i.e. the number of bytes received from all clients).

If you just select that variable you don’t have a useful information, but if you calculate the ratio ‘Bytes Received per Second’

(`BYTES_RECEIVED`) / (`UPTIME`)

you have a more interesting value and you can see how this value is changing over time.

I’ve created a SQL Script that can help you calculate many interesting Hit Ratios and Derived Performance Metrics and I am posting it here so that you can have and idea on what ratios you can calculate to …