MySQL: Difference between revisions
From DWIKI
m (→Tuning MySQL]) |
m (→Documentation) |
||
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