Four unversioned libraries in application/libraries, two of them edited in place. Moving the application onto Composer and PSR-0 without giving up the framework’s own loader.
MySQL 5.5 made InnoDB the default engine, which is often read as “we are on 5.5, so we have transactions”. Tables created under 5.1 keep MyISAM through an…
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.
By default mysqldump locks every table it is reading, which on a busy database means writes queue behind the backup for as long as it runs. –single-transaction instead…