MySQL

From DWIKI

Documentation

Tools

Create a diagram

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;


FAQ

show mysql configuration

show variables

mysql error codes

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


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: Got error: 1040: Too many connections when trying to connect

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