Monthly Archives: March 2012
We are pleased to announce the immediate availability of MariaDB 5.5.22-rc. MariaDB 5.5.22 is the first release candidate (RC) release in the 5.5 series and follows the MariaDB 5.5.20-alpha and 5.5.21-beta releases. We hope to follow it up soon with a Stable (GA) 5.5 release.
MariaDB 5.5 is a merge of MariaDB 5.3 and MySQL 5.5 with some limited additional bug fixes. Please see the What is MariaDB 5.5 page for an overview of MariaDB 5.5.
The Release Notes page has some notes on the release. There is also a Changelog available for those who are interested. …
When I published the MariaDB-5.3.4 sysbench results I said “if your workload includes complex (sub)queries, then you will probably benefit more from MariaDBs new optimizer features”. Today I will present some benchmark results for complex workload.
The benchmark is DBT3, an implementation of the TPC-H specification. DBT3 is written in C and hosted at Sourceforge.
The DBT3 benchmark can run at different scale factors – defining the size of the database. I used a scale factor of 30 which yields ~30GB of raw data and ~48GB of disk footprint. The machine running the benchmark had 16G of memory. …
A screencast demonstrating the MariaDB Windows installer.
httpv://www.youtube.com/watch?v=yQPnCxJMOWI
(I recommend watching it in full screen 720p, so you can see the details.)
Some links:
- The MariaDB homepage
- The AskMonty Knowledgebase
- The MariaDB Downloads page
- Installing MariaDB on Windows documentation
- The HeidiSQL homepage
Acknowledgments:
A big thanks to Vladislav Vaintroub, MariaDB’s Windows guru, and to Rasmus Johansson for help with the screencast. …
Continue reading “Screencast: Installing MariaDB on Windows”
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 rows (~10G of data)
- 16G buffer pool – result is independent of disk performance
- mysqld bound to 16 cpu cores, sysbench to the other 8
Read/write OLTP benchmark results will be published as soon as they are available. …
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. …
Here’s another MariaDB screencast, this time highlighting some of the GIS functionality in MariaDB.
httpv://www.youtube.com/watch?v=LpDm_8L1oyI
(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 lib/ext/ directory.
Acknowledgments:
A big thanks to Alexey Botchkov, MariaDB’s GIS guru, for the example data and help with the screencast. …