… point to consider. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “asynchronous” IO in…. This is to another question I was asked, namely: “If MySQL 5.5 uses async IO, is innodb_write_io_threads still important… –file-num=1 –file-extra-flags=direct –file-fsync-freq=0 –file-io-mode=sync –file-block-size=16384 –report-interval…
Post: Call for opinions: Do we need MySQL 5.0 with MySQL 5.4 performance
April 29, 2009 By 12 Comments
…. There is MySQL 5.0 version which did not get significant changes for around 2 years now. There is Innodb Plugin which has significant… instead we get MySQL 5.4 release with yet another set of Innodb changes. Why not to include plugin in MySQL 5.4 with relevant…. Now I’m confused – if Innodb Plugin is not taking place of default Innodb in MySQL 5.4 will this ever going to…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… did it couple of weeks ago so MySQL 5.0.67, MySQL 5.1.29 and Innodb Plugin 1.0.1 were used which are not very…% slower than MySQL 5.0 with two cores and just 2% slower with 8 cores, thus showing a bit better scalability. MySQL 5.1 plugin (compiled in) is further 3% slower compared to MySQL 5.1 with 2 cores and about…
Post: 5.0.87-build20 Percona binaries
November 18, 2009 By 3 Comments
… of MySQL server with Percona patches. Comparing to the previous release it has following new features: The build is based on MySQL-5.0.87 innodb_rw_lock.patch is ported from InnoDB Plugin 1.0.3 To be compatible with…/$basearch/ gpgcheck=0 As usual you can download binaries and sources with the patches here http://www.percona.com/mysql/5.0.87-b20…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… find on MySQL server. Let’s take a recent 5.1 bzr version (pre-5.1.61) and a single test, innodb_plugin.innodb…== by 0x5A0789C: clone (clone.S:112) ==9090== Location 0x6e29da8 is 0 bytes inside global var “srv_last_monitor_time” ==9090== declared… not-so-minor. Additionally, I’d consider backporting and using MySQL 5.5 atomic operation primitives with proper memory barriers, so that there…
Post: Innodb plugin 1.0.4 released - great job Innobase
August 11, 2009 By 3 Comments
… exactly 5 months after release of Innodb Plugin 1.0.3 (I honestly expected to see Innodb Plugin 1.0.4 to be released by MySQL Conference and Expo in April). This also is still “early adopter” version of a plugin… 4 years ago and which was known for about 5 years, since early MySQL 5.0 beta releases. We had semi-fix for this…
Post: MySQL versions shootout
October 10, 2011 By 6 Comments
… in question: MySQL 4.1 MySQL 5.0 MySQL 5.1 (with built-in InnoDB) MySQL 5.1 with InnoDB-plugin MySQL 5.5 MySQL 5.6 All versions are vanilla MySQL, not Percona Server… results, in tps (more is better) threads MySQL 4.1 MySQL 5.0 MySQL 5.1 MySQL 5.1+InnoDB-plugin MySQL 5.5 MySQL 5.6.2 1 685.52 639.73 596…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…, trust me. So Galera 0.8 comes with many nice features: Works with MySQL 5.1 and MariaDB 5.1. The latest is more… testing MySQL/Galera 0.8, binaries are available from Launchpad. The downside of MySQL/Galera is that it is based on standard InnoDB 5.1 instead of InnoDB-plugin. Standard InnoDB is seriously behind InnoDB-plugin…
Post: xtrabackup-0.3, binaries and stream backup
March 13, 2009 By 11 Comments
… version of xtrabackup – online backup solution for MySQL 5.0 / 5.1 and InnoDB standard version, plugin modification and XtraDB. We still consider it as… to work with standard version of InnoDB in MySQL 5.0. MySQL 5.1 + standard InnoDB / InnoDB-plugin also are supported. It can fully work as…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… we could write these as plugins instead of patches. 2. Be Scalable I’d like to see MySQL Scaling to large amount… Queries on MySQL because subqueries optimizer weakness. I’m saying about XA which were released in MySQL 5.0 without consistent work with MySQL close Partner – Innobase to ensure Group Commit still works in 5.0 and so we…
