(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.
Tag: Open Source
The Pros and Cons of MySQL Table Locking
(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
A (little) MySQL bug story…
(Cedric PEINTRE) I just want to share about a strange behavior of one of our MySQL server yesterday.
Modern platforms: flash, disk, log-structured, update-in-place
(Mark Callaghan) Someone who knows a lot about storage asked me whether we can spend IOPS to improve compression.
Diagnosing MySQL AUTO-INC and Gap Locks
(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
MySQL’s User Privileges Model for Access Control
(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.
Auto caching tables
(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?
PECL/mysqlnd_ms: MySQL 5.6.4-m8+ global transaction identifier feature supported
(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.
Working with Dates and Times in PHP and MySQL
(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.
My favorite features in MySQL 5.6
(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.
