Kevin Pirnie's MySQL Articles

Restic Python Backup to S3 Compatible Storage

Restic Python Backup to S3 Compatible Storage

Forward In my quest to get my servers fully automated, I realized I needed a reliable way to backup and restore my sites and databases.  Including a way to either browse the backups, or restore them to any other machine I have access to. At first I thought... mmm...  duplicity…

Performance Tweaks for Big Wordpress Sites

Tip #1 We backed up the the wp_posts table and then used a simple MySQL command to remove old post revisions. This decreased the table size from 400MB to 120MB: DELETE FROM `wp_posts` WHERE post_type = 'revision' AND post_date NOT LIKE '2012-%' Long-term solution There are WordPress plugins which can…