hyperbo.la :: lifestream
permalink

Fourth most expensive query is selecting all lifestream items and pictures: a LEFT OUTER JOIN with ORDER BY DESC, LIMIT, and OFFSET. There is an index on the order by but MySQL prefers filesort. Table is only 500 rows though. #mysql

permalink

Most expensive queries on hyperbola are hashtag lookups because they use RLIKE. Top 3 queries are 4.3ms, 3.2ms, 2.1ms per query. #mysql

permalink

"we successfully avoided a split brain scenario due to master/master replication" #mysql #fail

permalink

took 1minute of downtime today for a #mysql 5.5 upgrade from ubuntu

permalink

Healed my first master-master data drift today #devops #mysql

permalink

Now I have #utf8 support in #MySQL. I thought I did http://hyperbo.la/lifestream/174/ but that was a #fail. Bitten by the difference between utf8 and utf8mb4. Alas, #Django 500's; no emoji for me

permalink

I still don't have zero-downtime #MySQL upgrades. Lost a nine #fail

permalink

next project: convert #hyperbola to UTC, server, #django, and #mysql

permalink

running alter tables in production is terrifying #mysql ... just converted from MyISAM to InnoDB and added a bunch of #indexes

permalink

Only minor drama when upgrading hyperbola to 12.04 LTS ... #mysql failed to cleanly upgrade to 5.5 and I forgot the correct URL for my staging environment #linux #fail

permalink

I don't ♥ manually managing character sets #fail Why doesn't #django ensure the #mysql db has #utf8 as its character set?