Showing entries 1 to 3
Displaying posts with tag: HoneyMonitor Audit Pro (reset)
Step by Step Guide on How to Create a Customized Performance Report using HoneyMonitor

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
[Read more]
HoneyMonitor Pro and Audit Pro Editions v.1.0.13-alpha released!

[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 …

[Read more]
Hit Ratios for MySQL® Server Monitoring: a SQL Script

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 …

[Read more]
Showing entries 1 to 3