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]
===Tuning MySQL]===
SHOW STATUS LIKE '%qcache%;
SHOW GLOBAL STATUS;
SHOW VARIABLES;
*[http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html 5.1.5 Status Variables]
*[http://www.ibm.com/developerworks/web/library/l-tune-lamp-3.html Tuning MysQL]
*[http://www.ibm.com/developerworks/web/library/l-tune-lamp-3.html Tuning MysQL]



Revision as of 19:14, 22 December 2007

Documentation

Tuning MySQL]

SHOW STATUS LIKE '%qcache%;
SHOW GLOBAL STATUS;
SHOW VARIABLES;

FAQ

Fix privileges

mysql_fix_privi­lege_tables