November 16, 2016 at 10:25 PM CST

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

November 16, 2016 at 10:23 PM CST

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

April 3, 2016 at 03:02 AM PDT

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

permalink

July 21, 2015 at 09:06 PM PDT

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

permalink

March 9, 2015 at 11:41 PM PDT

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

permalink

October 27, 2014 at 11:30 PM PDT

Now I have #utf8 support in #MySQL. I thought I did 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

October 19, 2014 at 08:28 PM PDT

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

permalink

January 15, 2014 at 10:32 PM PST

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

permalink

November 30, 2013 at 08:52 PM PST

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

permalink

November 8, 2013 at 01:02 AM PST

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

March 1, 2012 at 01:32 PM EST

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

permalink