Sql

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.

Tuning Galera’s gcache size and page size can reduce disk I/O during replication and keep write-set lookups in memory. A quick configuration change that pays off on busy clusters.

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.