Drawing of the various buffers and files in InnoDB, what they do, and what configuration parameters modify their size or behavior. So much nicer than long reference lists.

To read.

Some light reading.

Been doing about the same thing except selecting by a prefix of the binary(20) primary key.

I want innodb_write_io_threads.

Page 10 mentions a "profiling" mode I've never heard of before.

OMGOMGOMGOMGOMG

An L2 cache using remote memory for InnoDB. Maybe instead of manually asking memcached for things before going to the database, one could just ask the database and repurpose the memcached instances already available for WaffleGrid. This definitely introduces some inefficiencies but essentially teaches memcached to speak SQL.

"If you can afford the loss of some of the latest committed transactions if a crash occurs, you can set the innodb_flush_log_at_trx_commit parameter to 0. InnoDB tries to flush the log once per second anyway, although the flush is not guaranteed."

Oh lord, help me.