MySQL: Difference between revisions

From DWIKI
Line 4: Line 4:
*[http://www.pantz.org/database/mysql/mysqlcommands.shtml A collection of mysql commands]
*[http://www.pantz.org/database/mysql/mysqlcommands.shtml A collection of mysql commands]
*[http://dev.mysql.com/doc/refman/5.0/en/c-api-functions.html MySQL C API Functions]
*[http://dev.mysql.com/doc/refman/5.0/en/c-api-functions.html MySQL C API Functions]
*[http://www.tizag.com/mysqlTutorial/mysqljoins.php MySQL joins]


===Tuning MySQL===
===Tuning MySQL===

Revision as of 22:05, 26 December 2007

Documentation

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_privi­lege_tables