MariaDB optimization for string related operations

In our upcoming MariaDB 5.3 release Monty optimized the internal string append code for performance. I tested his patch with a plain MariaDB 5.2 vs. a patched MariaDB 5.2 with sql-bench, which showed an overall performance gain around 3%.

The details of the patch Monty describes like this
Patch to optimize string append:

While examining a trace output from a mysql-test-run case, I noticed a
lot of reallocation calls.  This was strange as MariaDB/MySQL was
designed to do so few malloc/realloc as possible.  The system uses was
to first calculate how big buffer you would need and then allocate a
buffer big enough for most usage. …

MariaDB And Trademark

I’d like to wish Henrik Ingo well now that he has publicly announced his resignation from Monty Program. Henrik, I especially wish you all the best with the new member of your family.

I know you put a lot of effort into your presentation to the Monty Program board regarding transfer of trademark ownership, and you know (and I do not mind saying externally) that I supported transfer to a non-profit designed for such purposes. Our informal, non-inclusive vote in Istanbul aside, I think the company as a whole should put a lot of thought into such matters. …

Recently in MariaDB #2

There has been a lot happening in the MariaDB community recently, and there has been growth. Here are some of the highlights. Thank you to all our current contributors, and to others that want to contribute, shoot community[at]askmonty[dot]org an e-mail.

MariaDB 5.2.3 binaries for Solaris and Debian Sparc

Our Sparc community contributor, Mark, has continued to make popular binaries for Solaris 10 and Debian Sparc. He’s kept up to speed with MariaDB 5.2.3, so please visit him and download the binaries.

MariaDB 5.2.3 on the openSUSE Build Service

Community contributor Michal Hrušecký has packaged MariaDB for openSUSE and its available via the openSUSE build service.

MariaDB 5.2 is released as stable

I am happy to announce that MariaDB 5.2.3 is now released as a stable release.

During the gamma period we did not receive any serious reports for issues in 5.2, so we are relatively confident that the new code is of decent quality.

You can read about the features of MariaDB 5.2 in my previous blog entry or in the fast growing MariaDB knowledgebase..

What is most interesting about MariaDB 5.2 is that most of the features came from the MariaDB/MySQL community, not from Monty Program Ab!

Without the community it would not have been possible to do a stable release so soon after the last release. …

Segmented key cache performance results for MariaDB 5.2.2-gamma

Recently I tested our new segmented key cache feature for MyISAM in MariaDB 5.2.2-gamma for performance gains. You can check our new features in MariaDB 5.2 in our Ask Monty Knowledge Base

You will also find the details about the segmented key cache feature in our Knowledge Base at:

We wrote a test in LUA for SysBench v0.5 called select_random_points.lua, to figure out the performance gain of splitting the key cache’s global mutex into several mutex under multi user load. …

MP Istanbul 2010 T-Shirt Giveaway: the winners and extension!

And the winners are, …

There was quite a rush for the t-shirts and we have our three winners:

* Antony Curtis http://antbits.blogspot.com/
* Ray Kawalec http://www.traenq.com/
* Patrick Crews http://www.wc220.com/

Next round

Due to your high interest in our Istanbul2010 t-shirts, we are extending our giveaway quiz until November 30th.

Question: What is Maria in MariaDB and how is it connected to My and Max?

Email your answers to “istanbul2010-contest [at] askmonty (dot) o r g” before 30 Nov 2010. Good luck!

By the way, the design on the t-shirts looks like this:

Şerefe! – The MariaDB Knowledge Base in Istanbul

Monty Program along with various guests and our friends at the recently founded SkySQL recently wrapped up a meeting in Istanbul Turkey. Sadly it rained most days but we had a good time and got a lot done.

Besides learning how to say “Şerefe” which is “Cheers” in Turkish, we discussed the future of MariaDB, our companies goals, the MariaDB knowledge base and many other topics. Since I am the web guy, I lead the presentation / talk on the KB and thought I would share some highpoints of it with you.

If you don’t know, the KB is located at http://kb.askmonty.org. …

MP Istanbul 2010 T-Shirt Giveaway

We saved three XL-sized t-shirts from our recent all-company meeting in Istanbul. At first we thought it would be a good idea to give away the shirts through a random drawing. But after mulling it around in our minds for a day or two, we thought we should make it a bit more fun, so we decided to have a small quiz (don’t worry, it’s only one easy question).

Before we get to that, here’s a run-down of what we did in Istanbul. Our community and documentation guys (Daniel Bartholomew, Colin Charles, and Kurt von Finck) had the great idea to create an “Istanbul Haber” (aka Istanbul newspaper) for each day of the meeting. …