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.
Someone will win a limited edition and very rare MySQL Cluster 7.2 shirt today
I was again reminded why setting SQL_MODE is so important in any new MySQL environment. While performing benchmark tests on parallel backup features with a common InnoDB tablespace and per file tablespace, I inadvertently missed an important step in the data migration. The result was the subsequent test that performed data population worked without any issues however there was no data in any InnoDB tables.
These are the steps used in the migration of InnoDB tables from a common tablespace model to a per-table tablespace model.
At the recent leaders summit of world leaders in Oracle, Java and MySQL user communities I gave a presentation on Why Upgrade to MySQL 5.5
This is a more high level overview presentation, specifically designed for Oracle resources with little to no knowledge about MySQL, however it provides a great management approach to the consideration of using the current MySQL GA version.
The North Texas MySQL User Group will meet Monday March 12 and there will be pizza and giveaways.
I have it all working. It's kind of magic. But there are issues, and I'm not sure it should even exist, and am looking for input.
In Auto caching tables I presented with a hack which allows getting cached or fresh results via a simple SELECT queries.
The drive for the above hack was INFORMATION_SCHEMA tables. There are two major problems with INFORMATION_SCHEMA:
The MySQL Council has been operational for more than one year, with mixed fortunes. As an early member, I am glad to be a member, and I feel that I have done something useful by participating in this organism. The council is young, and the MySQL community is variegated and sparse. The enthusiasm of the first volunteers must be reinforced by the injection of new members, who can contribute fresh views and keep the council on their toes.
Percona Toolkit version 2.0.4 is available for immediate download. This release fixes 25 bugs and is a bug-fix release only, with the exception of a minor new filtering option for pt-kill. The change log is available on Launchpad. There are links to the documentation, downloads, bug reporting system, and mailing list on the toolkit homepage.
The third edition is now available in ePub, Mobi, and PDF formats. Print format should be available early next week. Further Reading:High Performance MySQL, Third Edition High Performance MySQL, Second Edition: Replication, Scaling and High Availability High Performance MySQL 2nd Edition gets revised and translated Get a free copy of High Performance MySQL 3rd Edition!