MySQL: Difference between revisions

From DWIKI
Line 3: Line 3:
*[http://dev.mysql.com/doc/ Documentation]
*[http://dev.mysql.com/doc/ Documentation]
*[http://dev.mysql.com/doc/refman/5.1/en/tutorial.html MySQL Tutorial]
*[http://dev.mysql.com/doc/refman/5.1/en/tutorial.html MySQL Tutorial]
*[http://www.nparikh.org/unix/mysql.php MySQL Cheat Sheet]
*[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]

Revision as of 20:51, 16 March 2008

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