512 MB, 150 concurrent visitors, and a box that swaps before the CPU is busy. Replacing Apache and mod_php with nginx and PHP-FPM, in three stages that each…
long_query_time was an integer in MySQL 5.0, so one second became the conventional slow-query threshold and stayed there out of habit. It has taken a float since 5.1.…
Two pages read the same column and only one of them was right. Dumping, rewriting and reloading 52,000 rows without turning every accent into a question mark.