(Ronald Bradford) 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.

(Rob Gravelle) MySQL resource locking and performance go together much like movies and popcorn. Applying table locking at the right time and in the right way can yield very positive results, specifically in a noticeable speeding up of your SQL statements. By the same token, when improperly execute

(Cedric PEINTRE) I just want to share about a strange behavior of one of our MySQL server yesterday.

(Mark Callaghan) Someone who knows a lot about storage asked me whether we can spend IOPS to improve compression.

(Aaron Brown) At ideeli, there is an asynchronous process that allows internal users to import SKUs into our MySQL database. As ideeli has grown, more people are doing more of the same thing at the same time and the SKU import process had become a pain point. At its core, it simply inserts records i

(Rob Gravelle) MySQL Access Control is not just about giving your users access to the database by adding their login credentials to the User table. Beyond that there’s a whole other layer of access control, based on user privileges.

(Shlomi Noach) Is there a way to create a caching table, some sort of a materialized view, such that upon selecting from that table, its data is validated/invalidated?

(Ulf Wendel) MySQL Replication is sometimes critizied for being asynchronous and having slaves that lag behind. True! However, sometimes slaves can be used safely and reliably for read-your-writes.

(Sean Hudgston) When working in any programming language, dealing with dates and time is often a trivial and simple task. That is, until time zones have to be supported.

(Baron Schwartz) MySQL 5.6 is going to have a lot of improvements. I want to mention a few things I think are uniquely valuable for a large set of typical MySQL users.