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

Tools

Create a diagram

• Create a dia diagram

Show syntax

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

Tuning MySQL

• http://www.mysqlperformanceblog.com/
• Optimizing MySQL server variables
• mytop

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

show mysql configuration

show variables

mysql error codes

http://dev.mysql.com/doc/refman/5.1/en/error-messages-client.html

separate lines in mysqldump

--extended-insert=FALSE --complete-insert=TRUE 

Fix privileges

mysql_fix_privilege_tables

mysqldump: out of memory

mysqldump -q

clean up mysql-bin

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

mysqldump: MySQL server has gone away (2006)

seems related to max_allowed_packet File:Example.jpg

ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0

Could be /etc/hosts.allow