This is another, in-case-you-missed-it, but it is definitely worth mentioning again:

MariaDB 5.3 is now GA

So, if you’re using MariaDB 5.1 or 5.2, I’d definitely recommend upgrading to the new MariaDB 5.3.

Also, if you’re a Windows user using MySQL 5.1, I’d highly consider making the switch to MariaDB 5.3 due to all of the Windows-specific improvements in it.

MariaDB 5.3 Enhancements:

• Subquery optimizations
• Semi-join subquery optimizations
• Non-semi-join optimizations
• Subquery Cache
• Subquery Optimizations Map
• Optimizations for derived tables and views
• Disk access optimization
• Join optimizations
• Index Merge improvements
• Optimizer control
• NoSQL-style interfaces
• Group commit for the binary log
• Replication and binary logging enhancements …

MariaDB-5.5.21-beta is the first MariaDB release featuring the new thread pool. Oracle offers a commercial thread pool plugin for MySQL Enterprise, but now MariaDB brings a thread pool implementation to the community!

If you are not familiar with the term, please read the Knowledge Base article about it.

The main design goal of the thread pool is to increase the scalability of the MariaDB server with many concurrent connections. In order to test and demonstrate this, I have run the sysbench OLTP RO benchmark with up to 4096 threads to compare the new pool-of-threads and the traditional thread-per-connection scheduler:

Benchmark description:

• sysbench multi table OLTP, readonly
• 16 tables, totaling 40 mio …

We are pleased to announce the immediate availability of MariaDB 5.5.21-beta. MariaDB 5.5.21 is the first Beta release in the 5.5 series and follows the initial MariaDB 5.5.20-alpha release. We hope to follow it up soon with Release Candiate and then Stable (GA) 5.5 releases.

MariaDB 5.5.21 beta is a merge of MariaDB 5.3 and MySQL 5.5 with some limited additional bug fixes. In this release we have added some extra notable features including an improved thread pool, an updated SphinxSE storage engine for fulltext search, and the ability to selectively skip replication of binlog events. Extra features planned for MariaDB 5.5 will be pushed into subsequent releases.

As with any beta release, MariaDB 5.5.21-beta should not be used on production systems.

The Release Notes page has some …

Now that the snow is melting and spring is in the air, the SkySQL Team is hitting the road and making the rounds of key industry events, trade shows, and meetups around the globe.  Come meet the team, pick-up a few tips and tricks for using the MySQL database, network with your peers, and learn more about SkySQL’s products and services.  Here are some the events we’ll be at this spring:

BIG Data, A New Horizon for Data Analysis
March 20 - 21, 2012
Cité Internationale Univeritaire de Paris, Paris, France

POSSCON 2012
March 28-29, 2012
Columbia Metropolitan Convention Center, Columbia, South Carolina

…

I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5

The post Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact appeared first on ovais.tariq.

MySQL community conferences are alive and well in 2012.   Percona has taken the initiative to host the yearly MySQL event at the Santa Clara Hyatt; it's now called Percona Live MySQL Conference and Expo.  It runs from 10 through 12 April.  But don't plan on going home Thursday night.  On Friday 13 April you can also attend the SkySQL and MariaDB MySQL Solutions Day in the same location.  And wait, that's not all!  Drizzle Day is also on 13 April and also at the Hyatt, so you can catch up on what the Drizzle folks have been up to for the last 12 months.

Now for some specifics on the conferences where Continuent will be appearing. …

I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5

Now let’s take a look briefly at what this enhancement actually is, and what is it aimed at.

Index Condition Pushdown

Traditional B-Tree index lookups have some limitations in cases such as range scans, where index parts after the part on which range condition is applied cannot be used for filtering records. For example, suppose you have a key defined as:

KEY `i_l_partkey` …

In case you didn’t notice it last week, MariaDB 5.5 (5.5.20, specifically) has been released.

It’s a release I’ve been looking forward to for a while now, so I’m very excited that it’s now available!

Note that it is currently ‘alpha’ since it is the very first release of MariaDB 5.5. However, it is not your typical new ‘alpha’, so I would expect it to be GA in the not-so-distant future (please don’t quote me on this though, as I have no idea of the true time table – but the goal is for the next 5.5 release to be ‘beta’).

You can download MariaDB 5.5 from the following location:

http://downloads.askmonty.org/mariadb/5.5/

There are also more details on this 5.5.20 MariaDB version here:

What is MariaDB 5.5
…

Here’s another MariaDB screencast, this time highlighting some of the GIS functionality in MariaDB.

(I recommend watching it in full screen 720p, so you can see the details.)

Some links and notes:

• GIS Functionality in MariaDB
• Data used in this screencast
• OpenJUMP
• JUMP database plugin
  • To use the database plugin, unpack it into the OpenJUMP lib/ext/ directory (not a subdirectory, but directly into that directory). Also place the mysql-connector-java.jar into the …

Following closely on the heels of the MariaDB 5.3.4-rc release a couple of weeks ago, the MariaDB project is pleased to announce the immediate availability of MariaDB 5.3.5!

MariaDB 5.3.5 is the first stable (GA) release in the 5.3 series. Details and downloads are available from the following links:

• MariaDB 5.3.5 Release Notes
• MariaDB 5.3.5 Changelog
• MariaDB 5.3.5 Downloads

(Debian and Ubuntu packages are available from our mirrored apt repositories. A sources.list generator is available.)

About MariaDB 5.3

…