Feb. 13, 2011, 2:37 p.m.
—
Permalink
Have you ever needed to get all the data for a single customer from a MySQL database? All their orders, the products they've viewed, their billing preferences, everything. I needed to do this for Conversocial when debugging a problem a customer was having. More recently, I've needed to do this ...
Read more
Jan. 30, 2011, 7:43 p.m.
—
Permalink
Whenever you do a schema change in MySQL you run the risk of locking tables for a long time and making the database unavailable to anything that wants to read from the tables being altered. We (Conversocial) have been looking at how best to do MySQL schema changes whilst keeping ...
Read more
Aug. 22, 2011, 5:10 p.m.
—
Permalink
In a previous post I looked at the performance hit you get in MongoDB when the working set is larger than the memory available. I thought I'd have a look to see how MySQL fares under similar conditions. The experiment was very similar experiment to the experiment for MongoDB. Setup ...
Read more
