We have just announced our two new Editions of HoneyMonitor: HoneyMonitor ‘Pro’ and HoneyMonitor ‘Audit Pro’.
Press Release available at:
http://www.honeysoftware.com/news/pressreleases/20080429-honeymonitor-performance-tuning.php
I am preparing an Article to explain in details that Editions; I will try to post it asap.
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 / Test Cases.
Well, I’m a developer, not a proper DBA which has to manage/store data. However I will try to explain what I am developing with Falcon.
First of all I have to admit that I didn’t find the time to test the new 6.0.5-alpha version. I will do asap as it will be available on the download page of MySQL AB Web Site.
Now, as regard 6.0.4-alpha and earlier, I posted the verified Bugs #30826 and #35210.
Also I posted Feat. Req. #36059 for having a ‘have_falcon’ variable but Sergey replied that as ‘have_engine’ variables are not well suited to work with pluggable architecture he would unlikely do add that variable and also he recalled that bugs like that are open for every 3-d party engine (maybe, he refers to Bug #35192?).
So, as regard testing and bug reports, I am trying to have a my own (very little) part for Falcon improvement.
As regard what I am developing with Falcon, as I posted here I added a new Tab for the Falcon Engine in the Performance Tuning Monitor (Sorry but as today you can’t find on-line no info on that Monitor - I will try to post something as soon as possible on our web site).
Essentially, the Performance Tuning Monitor is a Tool that will be included in the 2 new Editions of HoneyMonitor (the new ‘Pro’ and ‘Audit Pro’ Edition - to be released later in Q2 2008).
It helps you tuning and monitoring the performance of your MySQL® Server. Just to understand what we are talking about, here’s a short list of features of that Monitor:
As the Monitor is compatible only with version 5.1.x of the Server, it does not require agents running on your server because it uses a scheduled event to store in an audit database complete derived performance metrics and allows you to generate and see more than 90 performance-charts (and create your own if you don’t like the standard charts).
Indeed, the Monitor is compatible with 5.0.x series and earlier - but for that versions it’s just a static Monitor - without Performance Charts (because Scheduled Events were added only in MySQL® 5.1 and it is the event that take care of storing the data to be used in the charts!).
So, as regard the Falcon Management in our Performance Tuning Monitor, below you find some screenshots:
 |
 |
 |
 |
Other features related to Falcon that I previously implemented in HoneyMonitor are the Creation and Visualization of the Falcon TableSpaces - and the possibility to create, using the Create Table Wizard, a Table that uses a particular TableSpace.
You can find some screenshots and explanations on those 3 features here.
So, hope to see Falcon in production very soon and a greeting to all the Falcon Team. Thank you for your efforts!
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 Ratio’ should be the monitoring-chart #92. So, yes.. I am very tired in this period and hope I could end the alpha stage sOOn!
Some days ago I have started writing the Documentation Chapters on the new Monitor. Then I will come back to the software to finish some unfinished features.
Of course, I will post other info on the Performance Tuning Monitor later in May or June.
