Ideas, releases, practical guides, and perspectives from the people building with MySQL.
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` …[Read more]
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:
[Read more]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:
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:
(Debian and Ubuntu packages are available from our mirrored apt repositories. A sources.list generator is available.)
About MariaDB 5.3
…
[Read more]If you follow MySQL community at least as much as I do (browsing trough the planet from time to time), you know that some exciting milestones were reached both in Oracles MySQL and in MariaDB. And as I love bleeding edge software, you can try all these exciting things prepackaged in openSUSE
Oracles MySQL
Let’s start with news from guys at Oracle. Recently they released
new MySQL Cluster 7.2. Yes 7.2 is
GA now. And you can find a lot of exiting
info online about how fast it is! If you don’t believe
benchmarks done by others, try it by yourself! We have it in
server:database repository for
all supported openSUSE versions, SLE and …
We are pleased to announce the immediate availability of MariaDB 5.5.20-alpha. MariaDB 5.5.20 is the first Alpha release in the 5.5 series. We hope to follow it up soon with a beta 5.5 release.
MariaDB 5.5.20-alpha is a merge of MariaDB 5.3 and MySQL 5.5 with some limited additional bug fixes. This is the first 5.5-based release, and we are releasing it now, intentionally without any extra features (and with it missing some planned features) to get it into the hands of any who might want to test it. Extra features planned for MariaDB 5.5 will be pushed into future releases.
As with any alpha release, MariaDB 5.5.20-alpha should not be used on production systems.
The Release Notes page has some notes on the release. There is also a …
[Read more]
Slave prefetch is an increasingly popular technique for speeding
up native MySQL replication, with several tools already published
to enable it, such as mk-slave-prefetch and Replication Booster. Tungsten Replicator
is now joining the fray. This article explains how our
implementation works, how to install and tune it, and how well it
performs compared to unaided MySQL native replication as well as
Tungsten parallel replication.
Understanding Slave Prefetch
Slow reads from storage are the principle reason for lagging
MySQL replication. This seems paradoxical since at first
glance the lag is caused by delayed updates. The
explanation is due to the way DBMS engines …
We’ve had quite a bit of feedback already, so many thanks to all of you who have shared your thoughts with us!
However, if you’ve not voted yet, please take a moment and let us know what you’d most like to see in MariaDB 5.6:
http://www.skysql.com/content/new-server-functionality-have-your-say
As always, thank you, and we look forward to hearing from you.
