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

This is a short tutorial on the features implemented in HoneyMonitor for the use and administration of Scheduled Events . It could be useful for Users who are new to the product and want to get start with it or to whom want to learn the basis of Scheduled Events in MySQL™ 5.1

More details on the HoneyMonitor Reference Manual at http://www.honeysoftware.com/honeymonitor/doc.

Contents

• Introduction
• The Scheduled Event Editor
  1. Performed Action
  2. Advanced
  3. Comment …

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

This is a short tutorial on the Server Objects List included in HoneyMonitor. I am writing it because I will reference it in some posts I am going to write in the next weeks. Furthermore, it could be useful for Users who are new to the product and want to get start with it.

More details on the HoneyMonitor Reference Manual at http://www.honeysoftware.com/honeymonitor/doc.

Contents:

• Introduction
• Connections Tree
• Metadata Catalog
• Using the Server Objects List
• Other …

Revision: 8 - Last Update: September 03 2008

This is the first part of a series of short articles with a how-to approach about MySQL® Performance Monitoring, Tuning & Auditing. We will see the question from a GUI prospective. In particular we will describe which monitoring-oriented features HoneyMonitor, a GUI for MySQL® currently in alpha development, implements.

I will explain how HoneyMonitor let you

1. install an audit database on your server, without the need of using 3th Party Agents nor using remote repository databases
2. enable the auditing and start monitoring your server
3. tuning your server changing a few suggested list of variables to get better performance.

We will use only the 5.1.x series of the Server as we use some Scheduled Events and the Event Scheduler has been added only in the 5.1 branch. In particular we will use MySQL® 5.1.24-rc. We will also do some …

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

Hakan Küçükyilmaz has just posted a new article  about the Falcon Engine.

There he explains that the Falcon Team at MySQL AB has added this week six new tests to the Falcon test suite and he reports (as usual) a time-trend chart of failed and passed Falcon tests.

I have calculated the ratio failed/passed tests and we can see that it is improving:

9%    |  (17:190)  |  207 tests in total  |  the last week
10%  |  (19:182)  |  201 tests in total  |  two weeks ago

Of course the ideal ratio is 0% i.e. 0 test failed.

In that post Hakan was wondering where and how Users use the Falcon Engine, what features they like/not like or want to see in it. Also he solicited Users for testing Falcon and reporting Bugs …

After 15 consecutive verified bugs, today I got my first “Not a Bug” (#36141).

Wow - I Don’t know exactly how should I feel.. Maybe it’s time for a holiday!
Consolation: Just errors of youth ;-)

The other important news of the day is the following. With the chart ‘Falcon Cache Hit Ratio’ (thank you Robin for your always interesting articles) I have finished the performance reports to be included in the new MySQL® Performance Tuning Monitor I am developing.

I was not sure whether to add a Falcon Tab in the Performance Tuning Monitor or not, but that article has convinced me. I had already added a Maria Tab.

If I am not mistaken, the ‘Falcon Cache Hit …