MySQL: Difference between revisions
From DWIKI
m (→Documentation) |
m (→Tuning MySQL]) |
||
| Line 5: | Line 5: | ||
*[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 | ===Tuning MySQL=== | ||
In my.cnf check out: | |||
log_slow_queries | |||
On prompt check out stuff like: | |||
SHOW STATUS LIKE '%qcache%; | SHOW STATUS LIKE '%qcache%; | ||
SHOW GLOBAL STATUS; | SHOW GLOBAL STATUS; | ||
SHOW VARIABLES; | SHOW VARIABLES; | ||
*[http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html 5.1.5 Status Variables] | *[http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html 5.1.5 Status Variables] | ||
Revision as of 20:12, 22 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
