Mysql

A quick reference for repairing corrupted MyISAM index files with myisamchk, including the exact command and what to expect when running it against a database directory.

Learn how to measure InnoDB table fragmentation using information_schema queries and interpret the resulting ratio to decide when a table needs optimization.

A quick walkthrough of enabling, configuring, and querying the MySQL general log to capture every statement that hits your server.

A quick reference for viewing and applying MySQL GRANT statements, including the specific privileges needed for routine and view management.

A quick reference for the four types of SQL JOIN operations in MySQL, with plain-language explanations and a simple example for each.