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...

This article is a cross post from Pythian’s blog Having good historial metrics monitoring in place is critical for properly operating, maintaining and troubleshooting database systems, and Percona Monitoring and Management is one of the options we recommend to our clients for this. One common concern among potential users is...