We have seen a few instances where upgrades of MySQL 5.1 to 5.5 have resulted in poor performance when using default values. After investigation it would appear that the main culprit appears to be the innodb_thread_concurrency setting.
Posted recently on the maria-developers mailing list, by Igor Babaev, Principal MariaDB developer at Monty Program is some interesting preliminary results for MariaDB 5.3.0 benchmarked against the DBT-3 benchmarking program.
DBT-3 is a benchmark to test a decision support workload, with a suite of business-oriented queries and concurrent data modifications.
As the dog days of summer set in and temperatures rise, this year’s O’Reilly OSCON conference in Portland, OR offered the open source community a brief respite from the heat. However, if you’re thinking the event lacked sizzle, think again. The energy, the discussions and the opportunities to collaborate, plus the chance to learn from/ interact with customers and potential customers, made OSCON one of the highlights of July.
Today at OSCON, SkySQL will introduce the SkySQL™ Recovery Manager. Powered by Zmanda, the SkySQL™ Recovery Manager is the most advanced backup and recovery solution for the MySQL® database. SkySQL’s solution makes life easier for any database administrator in need of a robust, yet flexible and easy to use backup and recovery manager.
If you're on openSUSE, you definitely want to upgrade to the latest MariaDB release made on 19/07/2011. Previous security fix disabled XtraDB! This is MariaDB 5.1.55.
If you're using Gentoo, please test MariaDB 5.2 ebuilds in the MySQL overlay. Its current with MariaDB 5.2.7 as well as MariaDB 5.1.55.
The primary objective of this release was to radically improve performance for subqueries, as well as for joins and single-table queries over large data sets. The MariaDB 5.3 release is based on MariaDB 5.2 (and therefor, MariaDB 5.1 & MySQL 5.1).
Noteworthy improvements in this release include:
SkySQL Partners with Yoshinori Matsunobu to Provide Commercial Services for MySQL® Master High Availability Manager & Tools
Today, SkySQL announced a partnership with Yoshinori Matsunobu, an Oracle ACE Director and the creator of the newly announced MySQL Master High Availability Manager and Tools (MySQL MHA) for automating MySQL master failover. With this partnership, SkySQL will be the first MySQL database commercial services company to provide technical support, professional services, and training, for MySQL MHA.
The gist of it is, if you've installed Mac OS X and you use Homebrew, you'll be pleased to note that you're just a brew install away for getting a working MariaDB. Yes, that's right, simply do: brew install mariadb and that's it -- you'll have MariaDB (currently 5.2.6) installed in no time.
Quick pointer that MariaDB 5.2.7 is now released. Highlights from the release notes: RHEL 5 RPMs (in addition to the CentOS 5 RPMs), and the inclusion of the HeidiSQLGUI client for the Windows MSI package. As always, the complete changelog, and what are you waiting for - download it now and give it a try!