Fixing MySQL Invalid Keys
A quick bash script to identify and repair MySQL tables with invalid or corrupted MYI key files, then force a rebuild using USE_FRM.
read more
Forceing MySQL Logs to File
Learn how to configure MySQL’s log_output variable to write slow query and general logs to files instead of tables, and why that matters for performance and log management.
read more
Generate Random Passwords with Perl
A compact Perl one-liner that produces cryptographically random passwords of a specified length. Perfect for quickly generating strong credentials without reaching for a dedicated tool.
read more
InnoDB Corruption and Recovery Guide
A practical, step-by-step guide for diagnosing and recovering from common InnoDB corruption issues, covering first response, log analysis, checksum verification, and data restoration techniques.
read more
Locate Files Based on Time Modified with find
A quick reference for using find with -mtime and -mmin to locate files by how long ago they were last modified, including the common off-by-one confusion around the +1 flag.
read more
MySQL General Log
A quick walkthrough of enabling, configuring, and querying the MySQL general log to capture every statement that hits your server.
read more