What if which ever way you turn, you think are seeing a postcard? What if you could take the afternoon off to go skiing? What if you would one day come to assume that every city has a beautiful lake at the center and mountains surrounding? What if every movie would always be shown in the original version without having to go to that single cinema in town that did? Speaking of languages, what if you could get by with whatever language you speak, or just practice one of many languages without having to go an a trip? What if going for a snack after one of the monthly user group meetings, feels more like a speakers dinner at a conference? Yes, then you must be working in Zurich, the up and coming PHP capital of the world! :)

Seriously, all I can say its awesome down here and there are a ton of awesome companies looking for top notch PHP developers. Sizes and types greatly vary. From the small development team, to large international …

I'm looking at the final patch for adding Asynchronous IO to the
Archive engine in MySQL. The current patch relies on an AIO library I
wrote myself a while ago to play around with the problem. It works,
but it adds more ongoing threads to MySQL, and I have mixed feelings
about doing that in user space (though its all the rage among engine
writers).

Last night I got it in my head to try out the posix AIO callers. In
part because I've never used them, and in part because I like the
thought of reusing code that someone else wrote (aka support my own
AIO means well... supporting it...).

I decided to do a test using 1024 byte buffers on a 1 gig file:

First Intel:

read()
real 0m0.789s
user 0m0.041s
sys 0m0.744s

aio()
real 0m2.487s
user 0m3.067s
sys 0m1.798s

…

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.

A new style for MySQL jobs page.
Haven't you heard? MySQL is hiring!


If the adventurous type doesn't appeal to you, you can opt for the quiet home sweet home version, with the beach sweet beach variation. That's what happened during the recent Summer of Code. I know it's a different story, but when I saw the picture of the career climber in the desert I couldn't resist associating it with Sakila typing away in the beach.

Hi, plase let me to re-introduce myself to you! Of course I can't just sit still after my holiday, so per September 2007 this is my new venture:



Open Query's motto is "Open Source Experts, MySQL Specialists", offering:

• Workshops and Training (materials developed by Open Query)
• Remote and on-site Consulting
• Open Source business advice and Community development strategies

I'm open for business!

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.