MySQL

Documentation

• Homepage
• Documentation
• MySQL Tutorial
• MySQL Cheat Sheet
• A collection of mysql commands
• MySQL C API Functions
• MySQL joins
• MySQLForge Wiki
• Common mysql queries
• http://people.freebsd.org/~kris/scaling/mysql.html
• MySQL Replication

Show syntax

http://dev.mysql.com/doc/refman/5.1/en/show.html

Tuning MySQL

In my.cnf check out:

log_slow_queries

On prompt check out stuff like:

SHOW STATUS LIKE '%qcache%;
SHOW GLOBAL STATUS;
SHOW VARIABLES;

• 5.1.5 Status Variables
• Tuning MysQL

FAQ

Fix privileges

mysql_fix_privi­lege_tables

mysqldump: out of memory

mysqldump -q

clean up mysql-bin

purge logs;
purge binary logs to 'mysql-bin.xxxyy';