I just read about the release of Honey Monitor for MySQL. I read through the features. I looked at the screenshots. Then I read about the licensing. Then I read about the fact that it only runs on windows XP or Vista. So, my questions for the ages…

1. Why, in this age of multiple OSes battling each other for market share, would you write an application that is OS specific? Every app should run in a vendor neutral web browser unless there’s a really really good reason. Monitoring software, are you kidding? Monitoring software must be vendor neutral and web-based. I will never use anything that ties me to windows or linux or osx, it has to be cross platform. End of story.
2. Why, when MySQL is so heavily used on Linux and Solaris, would you write an application for MySQL that can only be run on Windows? Every MySQL DBA …

I heard about TwitterJobSearch on net@night, and decided to give it a twirl. I typed “mysql” and found 3,092 results in 30 seconds. You can then filter by job title, salary, skill set, job type, and more, as well as sort it by relevance or date.

Useful? Quite possibly. Would be more useful, if you could filter out Twitter users (like @itcareer, for example). Search that is semantic, instead of just word based. So “mysql in san francisco” will return relevant results for you.

If you’re looking for a job anytime soon, note that there will also be a Job Fair at the MySQL Conference & Expo 2009, happening April 20-23 2009, are you registered yet? Its a great place to network, and you shouldn’t miss it.

…

We are pleased to announce the release 1.0.16 of HoneyMonitor, our GUI for MySQL™ administration and monitoring.

In this release, available for immediate download, we have fixed many bugs and included several improvements.

We are working to release a RC version as soon as possible.

The following is the list of changes:

• New Features:
  • new Tab “Defaults Folders” in the “HoneyMonitor Options” Window to set the default folders to be used when storing Audit Reports, Standard Reports, HTML Reports, Queries, Backups, Scripts, Exported Data.
• …

When Mondrian tools output MDX results as text, such as in the cmdRunner utility, we've been using the same old crappy format for years. For example, the query

select
  crossjoin(
    {[Time].[1997].[Q1],  [Time].[1997].[Q2].[4]},
    {[Measures].[Unit Sales], [Measures].[Store  Sales]}) on 0,
  {[USA].[CA].[Los Angeles],
   [USA].[WA].[Seattle],
   [USA].[CA].[San Francisco]} on 1
FROM [Sales]

is formatted as

Axis #0:
{}
Axis #1:
{[Time].[1997].[Q1], [Measures].[Unit  Sales]}
{[Time].[1997].[Q1], [Measures].[Store  Sales]}
{[Time].[1997].[Q2].[4], [Measures].[Unit  Sales]}
{[Time].[1997].[Q2].[4], [Measures].[Store Sales]}
Axis #2:
{[Store].[All Stores].[USA].[CA].[Los Angeles]}
{[Store].[All  Stores].[USA].[WA].[Seattle]}
{[Store].[All Stores].[USA].[CA].[San  Francisco]}
Row #0: 6,373
Row #0: 13,736.97
Row #0: 1,865
Row #0: …

I haven’t really decided my schedule yet during the conference, but I thought I’d mention these sessions that look interesting to me. I’m presenting a session on how to use Maatkit, which I think attendees will get a lot of benefit from. Tuesday This is Not a Web App: The Evolution of a MySQL Deployment at Google (keynote). Mark Callaghan, need I say more? MySQL and Search at Craigslist.

I always say that the ultimate MySQL tuning script is an expert human. To that end, I generally try to build tools that help a human be more productive with the raw information from MySQL. One of the things we look at during a performance audit is the MySQL status counters. It’s useful to look at a) absolute values and b) several incremental snapshots. I’ve written a small shell script called “mext” that can make this a little easier.

This feature has requested many times, and I have been reluctant to implement it, because it involved fiddling with the internals of low_level_make_sandbox, which should behave differently depending on the base directory. An installed BASEDIR has a different structure than a source BASEDIR. In …

MySQL Proxy 0.7.0 is finally released:

* https://launchpad.net/mysql-proxy/trunk/0.7.0

The full ChangeLog is a bit longer as 0.7.0 was more than a year in the works. To make it short: it is faster, better and more flexible.

Binaries will be release at http://dev.mysql.com/downloads/mysql-proxy/index.html shortly.

For everyone who just wants to update from 0.6.1 to 0.7.0 you should just see a major speed improvement.

• A bug in the connect()-phase that caused to leave the Naggle-algorithm enabled caused a unneccesary high latency.
• We also changed the buffering of result-sets to only buffer them if the scripts really ask …

MySQL Proxy 0.7.0 is finally released:

• https://launchpad.net/mysql-proxy/trunk/0.7.0

The full ChangeLog is a bit longer as 0.7.0 was more than a year in the works. To make it short: it is faster, better and more flexible.

Binaries will be release at http://dev.mysql.com/downloads/mysql-proxy/index.html shortly.

{% endexcerpt %} For everyone who just wants to update from 0.6.1 to 0.7.0 you should just see a major speed improvement.

• A bug in the connect()-phase that caused to leave the Naggle-algorithm enabled caused a unneccesary high latency.
• We also changed the buffering of result-sets to only …

I am doing the final prep work for my upcoming UC presentation on SSD’s, and I thought I would throw this out their. Recently their has been a great deal of discussion on the write cache on the Intel x-25e and whether you need to disable it to prevent data loss on a power outage. Most disk caches are not protected by a battery backup and are disabled by default on most high end controllers. Who wants to potentially lose 16-64MB of data on an outage? So it seems like it would make sense that you should disable the cache on the Intel drives as well. But their is a problem. Vadim over at the MySQL Performance Blog recently published some benchmarks that show some rather slow results when the disk cache is disabled, in fact I have also noticed a significant slow down in these cases as well. So this leads to the …