MySQL: Difference between revisions

From DWIKI
mNo edit summary
Line 8: Line 8:
*[http://www.tizag.com/mysqlTutorial/mysqljoins.php MySQL joins]
*[http://www.tizag.com/mysqlTutorial/mysqljoins.php MySQL joins]
*[http://forge.mysql.com/wiki/Main_Page MySQLForge Wiki]
*[http://forge.mysql.com/wiki/Main_Page MySQLForge Wiki]
*[http://www.artfulsoftware.com/infotree/queries.php Common mysql queries]
*[[MySQL Replication]]
*[[MySQL Replication]]



Revision as of 16:29, 7 July 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