We have yet another opening at MySQL Performance Blog.

We're looking for Intern position (with limited compensation) to work on project of MySQL Performance research and analysis, developing and running benchmarks under our guidance, writing WhitePapers and articles.

We feel this would be perfect part time position for the Computer Science student interested in High Performance systems design, performance optimizations and MySQL. The work done with us has potential of also being used for course work or diploma project.

The work to be done is with intent to be openly published both in terms of benchmarks code and benchmark results.

Working us you would learn a lot about MySQL Architecture, Unix/Linux Operating Systems and Hardware Performance Optimization, Performance Analysis, benchmarking and load testing plus get your name known in MySQL Community.

What we're looking for: You must be …

Just as a head’s up, I’ll be at Software Freedom Day 2007, not in Melbourne, but in Beijing! Its on Saturday, September 15, 2007, and it only starts at 1PM (I presume this means I get to party on Friday night, to re-live some Beijing memories?).

I’m told a beginner-styled talk is best, so what kind of MySQL-related talk would you be after? Business model related? Do give me ideas (sooner, the better). Keep in mind, I’ll have to pass the message on within a good 15 minutes, with 5 minutes for questions…

Check out the program, and I do hope to see you soon, if you’re in Beijing (or if we cross paths - I’m on Dopplr now, so you can play a “Where in the world is …

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.