During last one and a half year we had pretty good track record with MySQL Performance Blog - there were times when site was slow (especially when backup was running) but I do not remember significant downtime, until today we went down for few hours.

All this time the site was running on dedicated server which I rented from APLUS about 3 years ago. It is rather slow Celeron box with single disk and 512MB running Fedora Core 2. Despite its age (it was used "Value" server even when I got it) the server had very good track record with basically zero failures during this time - there were some network disruptions at Aplus but this is about all problems we had.

As the OS on the box become rather outdated plus server was old and had no RAID and I did not want to rely just on daily backups we got new server from 1and1 couple of weeks ago. …

I've just released mondrian-2.4 production. In the five months since mondrian-2.3 there have been some significant new features and a host of bug fixes.

The features I'm most pleased with are the ability to aggregate distinct-count measures (much harder to implement than you'd think!) and the ability to generate SQL containing the new GROUPING SETS clause if the database supports it.

No more release lag

In past releases, we've been criticized for a several month lag between a mondrian release and the Pentaho release which contains it - and rightly so. We've now put that right. On Monday, Pentaho just released the 2nd Release Candidate of their 1.6 release, containing mondrian-2.4.1-RC1. Pentaho 1.6 will shortly go …

This release of MySQL Toolkit fixes some minor bugs and adds new functionality to four of the tools. Some of the changes I made were in response to feedback I got at the recent MySQL Camp. I’m still working on some of the feature requests, such as daemon-izing certain tools. For those who requested features for MySQL Query Profiler, the tab-separated format should give you the desired output: no zero rows, and variables are not renamed.

At the end of the Google Summer of Code 2007, the MySQL Test Creator tool is far more functional than at the midterm assesment. The following features have been implemented:

Recording single connection test cases
Recording multiple connection test cases
Macros that allow the user to view the test file or result file, reset the test case, change the name of the macros, output to a specific file name, and force the test case to be written to disk without stopping the recording
Automatically dropping any tables that are created in the test case, and a macro to include a .inc file
A test suite with test cases that test basic functionality

The problem herein lies with the features that are implemented, but need to be expanded upon or completed for the project to be complete. To achieve the goals stated for this project, there is still more work to
do, and I believe that one additional week of …

Cool video from Google about a MySQL user group (I think). I thought it would be appropriate as my first MySQL blog Post.

Some good information here. Lot's of storage talk.

In the recent past the RSS feeds on http://forge.mysql.com/ used to loose the formatting on posts leading to most feed readers showing them as just one long wrapped line of text. This made forum posts hard to read and impossible to figure out any SQL or code snippets within.

This has now been fixed a few days ago, so providing a way better reading experience for all us RSS users

If you have not been to the www.mysql.com website, it’s a new look.

As of late I am really fed up with anecdotal information on MySQL.
One of the one's I hear is "with many processors you need to disable
Innodb's Adaptive Hash".

First things first, unless you roll up your sleeves and hack the code
there is no way to turn it off. There is no user configurable
variable, all there is is a single true/false boolean you can set in
the code. As many times as I have heard "turn it off" I had thought I
would discover that there was some setting I never knew about. It
turns out that this is not the case.

What you see below is a with/without adaptive test. It was key read
test, meaning that it just tested key reads and no writes. Users who
are using 8way and beyond machines today (and the Intel was an 8 way,
while the Sun T1000 can be considered a 32way), are not guys with
machine in their basement. Typically it is …

Steve Karam, The Oracle Alchemist, saved the skin of a harried LB administrator this week (that would be me), stepping up at the last moment to edit and publish the 60th edition of Log Buffer, the weekly review of database blogs. Thank you, Steve! Next week, Arnold Daniels does LB#61 on Arnold?s wor(l)ds. [...]

The Fake Larry Ellison blog cracks me up.  It started off on the Fake Steve Jobs blog, but now it's spun out to get its own separate blog.  Fake Larry Ellison is paranoid about open source and hangs out with Steve Jobs and Paris Hilton. I don't know if this is Dan Lyons or someone else behind this one, but it's quite funny. Maybe he'll be at Burning Man this weekend... Or is that Fake Burning …