Oracle VM Consulting
view counter

MySQL Feed

Oracle MySQL resources, news, and support articles.

Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact

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.

Who will win a MySQL Cluster 7.2 shirt today??

Someone will win a limited edition and very rare MySQL Cluster 7.2 shirt today


Someone will win this shirt at the North Texas MySQL User Group meeting on Monday March 12th

BoFs and lightning talks at the MySQL conference

We’re running Birds of a Feather (BoF) sessions and lightning talks this year at the MySQL conference, similarly to previous years. You can help by submitting proposals ASAP. The deadline is Monday, and it is a hard deadline.

Submit a BoF SessionSubmit a Lightning Talk

SQL_MODE and storage engines

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.

IOUC Leaders Summit Presentation

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.

North Texas MySQL Users Group meeting Monday March 12

The North Texas MySQL User Group will meet Monday March 12 and there will be pizza and giveaways.

Auto caching INFORMATION_SCHEMA tables: seeking input

The short version

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.

The long version

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:

Bringing fresh blood to the MySQL Council

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 2.0.4 released

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.

High Performance MySQL 3rd edition now available

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!

view counter