This article is a cross post from Pythian’s blog In a recent post, I summarized what I consider to be the minimal topics one should be familiar with in order to do technical work with databases. One thing I left out, except for it being implicitly included in “Hardware Basics”...

This article is a cross post from Pythian’s blog I’ve been interviewing and mentoring candidates for technical database positions for almost ten years, and a common question from those who either don’t make it or feel they’re not ready yet to apply to the position they’re looking for is: What...

A recent Hacker News discussion inspired me to write a short post on my org-mode workflow, with the hope that it may help others. The thing I like the most about org-mode is that it supports heavy customization. This is not surprising, since Emacs itself is all about customization. You...

What is a good cache hit ratio? Taking MySQL as an example: what is a good query cache hit ratio? At the time of writing this, I get over 600 results if I enter that question into Google and limit the results to stackexchange.com. If I change ‘ratio’ to ‘rate,’...

This article is a cross post from Pythian’s blog I was recently discussing benchmarking options for Cassandra with some colleagues and given my background with MySQL, sysbench was the first tool I thought of. Sysbench is a high performance and flexible benchmark tool that can be used to run both...