Oracle has finally announced the long time pending MySQL 5.5 as GA. The 5.5x branch has the following super improvements.
uuhhoooo.. !!!
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. Then there was some safety
calls to
extend the buffer if needed.
What had happened in the MySQL code over time was that new coders
was
using a buffer that was not …
The art of simplicity is a puzzle of complexity. (Douglas Horton)
No puzzle looks simpler than a Sudoku. But behind the very few rules of this game hides enormous complexity. It’s now proved that there are 6670903752021072936960 different grids for a standard 9×9 Sudoku. More refinements and subtleties taking symmetries into account have been examined as well as other variants of Sudoku. Solving strategies have been studied inside out, enumerated and refined. Sudoku grids and Latin squares have kept mathematicians busy for a long time and lots of hidden patterns and complex concepts still remain to be discovered. This little game is a treasure island for mathematicians and developers : we only need to dig deep enough and long enough…
This …
[Read more]While it’s great that MySQL 5.5 is GA with the 5.5.8 release (you can download it here), I’m rather disappointed that the bzr repositories on launchpad aren’t being kept up to date. At time of writing, it looked like this:
Yep – nothing for five weeks in the 5.5 repo – nothing since the 5.5.7 release :(
There hasn’t been zero changes either – the changelog has a decent number of fixes.
Percona just announced that they’re going to include HandlerSocket in the latest Percona build.
This is huge news. In case you aren’t aware, HandlerSocket is a raw protocol interface that is similar to a dictionary lookup (kind of like memcached, or a hashtable) and does NOT go through the SQL parser.
The performance implications are huge as this thing flies.
Most web applications access data in terms of key/values. In fact, databases like Redis take the concept a bit further and implement functions you can use to manipulate keys directly.
What’s interesting here is that I think HandlerSocket is bigger than Percona and …
[Read more]This morning, Oracle gave a MySQL technology update that included the announcement that MySQL 5.5 is GA. The short list of exciting new and improved features is -
The InnoDB and MySQL database improvements in 5.5 are impressive. Many of these improvments are gained through increased i/o subsystem improvements and removal of lock contention that has long been an issue when scaling on hosts above 4 cores.
The benchmark graphs that Oracle had in this morning’s call show improvements on multicore machines, at high levels of transactions and across read, write and mixed workloads.
With 5.5, …
[Read more]
I will be speaking at least once at the 2011 O'Reilly MySQL
conference. I
have not heard back on all my proposed session but I will be
talking
about Open Source BI tools. There are several great packages to
help
DBAs make reports from their MySQL instances. These tools are
great for
simple ad-hoc reports to highly detailed data dumps.
A bit early for Christmas, or perhaps slightly delayed for Saint
Lucia, MySQL 5.5 is finally GA. A fantastic present
from Oracle for the whole MySQL Community, something that many
wish unwrap and install as soon as possible.
Tomorrow, Thursday 16 December @ 9AM PT/12PM ET/1800 CET, we will
present the first webinar around the offering of products and
services from SkySQL. If you are interested, you can register
here: http://www.skysql.com/en/news-and-events/webinars
We have not blogged much about what SkySQL can offer to the
Community and to its customers, so I think this is the occasion
to understand how we operate, what is our position with regards
to the main forks and distributions of MySQL (including 5.5) and
which technologies we use and recommend. I think (and hope) the …
Just wanted to highlight that Percona Server has now added HandlerSocket to its most recent release, being the first "MySQL fork/distribution" to ship it in easy to consume binary downloads.
HandlerSocket brings NoSQL to MySQL, and does so with a vengeance! It was developed at DeNa, by Akira Higuchi and is already used in production in their MySQL servers. The announcement on my former collague Yoshinori Matsunobu's blog flaunts a 7x performance improvement over the standard SQL interface in MySQL. The most astonishing part is that their MySQL is now faster than Memcached, even if the latter doesn't store anything to disk, so with this NoSQL-for-MySQL solution it makes sense to remove the caching layer completely! …
[Read more]
