Tagged with "mysql"

2019-02-28 21:36 UTC

Fun MySQL fact of the day: chaos without `ORDER BY`

ANSI SQL-92 states that the order of a result set in the absence of an ORDER BY is implementation specific. This means that the same query without an ORDER BY clause run n times may return rows in n different orders. ... read more

2019-02-27 21:55 UTC

Fun MySQL fact of the day: no nested transactions

Nested transactions allow a client to begin and end multiple transactions within an outer transaction (within an outer transaction (within an outer transaction (within an outer transaction ...))). When would you use it? This type of mechanism is necessary to accomplish a pure Component Based Architecture. However, excepting BerkleyDB, nearly ... read more

2019-02-26 21:08 UTC

Fun MySQL fact of the day: `sync_binlog` is a counter

The D in ACID stands for Durability, which is the property that guarantees a committed transaction will be permanently recorded. Perfect durability is impossible, but MySQL allows us to improve our ability to offer this guarantee this through the sync_binlog flag. ... read more

2016-02-21 19:37 UTC

The Cost Of Consistency: When 9ms Is 1s Too Much

The CAP theorem remains one of the most important tools in my software developer's toolbelt. Used correctly, it can help create services and products that can offer an excellent user experience and protect revenue during partial failures. Used incorrectly, it can lead to a poor user experience and loss of ... read more

2016-02-07 23:24 UTC

Pessimistic Optimism: The Case Of Unexpected Deadlocks

Despite the fact I've been developing software in one way or another for almost 20 years, I'm constantly surprised how things work, and, once the frustration wears off, I'm intrigued when things break. Lucky for me, over the last few weeks, I've been surprised, frustrated, and intrigued by what, on ... read more

« Previous 6 7 8 9