Binary Sludge
  • Home

MySQL

A collection of 3 posts
Debugging

The network is reliable

A fascinating post-mortem on high profile network failures: This post is meant as a reference point–to illustrate that, according to a wide range of accounts, partitions occur in many real-world environments. Processes, servers, NICs, switches, local and wide area networks can all fail, and the resulting economic
09 Jun 2013
DRBD

Redundant and Fault Tolerant PHP Session Storage

As a new PHP application grows from a single server the database is usually the bottleneck. When the original server begins to struggle the database is moved to a dedicated machine or two and perhaps read-only slaves are added (this may require some application code changes -  MySQL Proxy offers
13 Jan 2011 5 min read
error

MySQL ERROR 1137 (HY000): Can't reopen table: 'tmp_journals'

When setting up a query using a temporary lookup table, I got this error: ERROR 1137 (HY000): Can't reopen table: 'tmp_journals' It transpires that since 4.1 the way MySQL handles temporary tables has changed. This affects joins, unions and subqueries. There is an obvious
18 Mar 2010
Page 1 of 1
Binary Sludge © 2026
Powered by Ghost