MySQL: Difference between revisions
From DWIKI
mNo edit summary |
m (→FAQ) |
||
| Line 34: | Line 34: | ||
==FAQ== | ==FAQ== | ||
===Fix privileges=== | ===Fix privileges=== | ||
mysql_fix_privilege_tables | |||
===mysqldump: out of memory=== | ===mysqldump: out of memory=== | ||
| Line 43: | Line 43: | ||
purge logs; | purge logs; | ||
purge binary logs to 'mysql-bin.xxxyy'; | purge binary logs to 'mysql-bin.xxxyy'; | ||
===mysqldump: Got error: 1040: Too many connections when trying to connect=== | |||
Revision as of 13:32, 26 March 2009
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;
FAQ
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';
