Doing data that's bigger than most anyone else's data since 1999. Analytics. Front-end databases. Acronym soup.
Transaction Isolation Level (TXIL) Subtleties in MySQL
Continuing the discussion around transactions, consistency, and MySQL, we consider transaction isolation levels. Setting the TXIL Per Session Remember in MySQL we have auto-commit=1. When you set the transaction isolation level with a statement, that only lasts one transaction if you don't specify the session keyword, so the TXIL
How Much Does Consistency Matter?
What's Been Happening Recently Is consistency even important? We know it's contentious. Some people find it extremely important, and we all at least pay lip service to it. But really... how much effort should we put toward making sure we've got it? As you might have noticed, recently we saw
On the Usefulness (Or Lack Thereof) of Foreign Keys
Preamble I recently spoke with Sebastian Machuca (a Sydney-based engineer) about the concept of having FK constraints in Dev and Staging environments, but disabled in Production. Here is the ensuing dialogue, edited for brevity and for making-me-look-like-a-genius. Our dialogue was good, but we were unable to come up with a