How-To

Two quick one-liners that count how many unique remote IPs are connected to port 80, using either netstat or ss. Handy for spotting unexpected traffic or verifying that only expected clients are hitting your web server.

Learn how to extract dynamic symbols from the mysqld binary and use them to resolve a crash stack dump into readable function names.

A quick awk one-liner that pulls RPM package URLs from log files or package lists by matching lines containing both ‘autoinstall’ and ‘.rpm’.

A quick bash script to identify and repair MySQL tables with invalid or corrupted MYI key files, then force a rebuild using USE_FRM.

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.

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.