(Mark Callaghan) With a few changes to InnoDB and MySQL I think I can get more than 100,000 disk reads/second from MySQL 5.1.47. InnoDB and MySQL continue to amaze me. This is a remarkable result.
Tag: Open Source
MySQL and Quoting
(Sheeri K. Cabral) MySQL does not follow the ANSI SQL standard for quoting. MySQL’s default quoting behavior is that either single or double quotes can be used to quote a string (this gets me into trouble when I work with Oracle databases, as double quotes do not indicate a string!).
dsh and TABLE CHECKSUM
(Dathan Vance Pattishall) So running through some various tasks, I’m finally on the section of work where I can resurrect a script that finds inconsistent data between master-master pairs.
Using PMP to double MySQL throughput, part 1
(Mark Callaghan) I used PMP this week to find bottlenecks in MySQL while running two benchmarks and describe the first bottleneck in this note. Changing the code as described here doubled the peak QPS. Pardon the hype in the title. This doubles peak QPS at 64 and 128 concurrent threads. To double th
PHP: Client side caching for all MySQL extensions
(Ulf Wendel) The first public mysqlnd plugin adds client side query result caching to all MySQL extensions of PHP (ext/mysql, ext/mysqli, PDO_MySQL). The cache is written in C. It does not change any of the PHP MySQL APIs and works with any PHP application using MySQL.
How read_buffer_size Impacts Write Buffering and Write Performance
(Venu Anuganti) Even though the name read_buffer_size implies that the variable controls only read buffering, but it actually does dual purpose by providing sequential IO buffering for both reads and writes.
Why does MySQL insert a NULL when a column is declared NOT NULL?, Other Thoughts…
(Brian Aker) Here is one, but not all of the culprits in the codebase:
NOT IN NULL Uniqueness trickery
(Leo Hsu and Regina Obe) I know a lot has been said about this beautiful value we affectionately call NULL, which is neither here nor there and that manages to catch many of us off guard with its casual neither here nor thereness. Database analysts who are really just back seat mathematicians in dis
SQL: forcing single row tables integrity
(Shlomi Noach) Single row tables are used in various cases. Such tables can be used for “preferences” or “settings”; for managing counters (e.g. summary tables), for general-purpose administration tasks (e.g. heartbeat table) etc.
How many IOPs can InnoDB do?
(Mark Callaghan) I previously tested InnoDB on an 8-core server to determine how many IOPs it can do for a simple IO-bound workload. The limits were ~12k disk reads/second for MySQL 5.0 and ~18k reads/second for MySQL 5.1.