MySQL: Difference between revisions
From DWIKI
m (→Documentation) |
mNo edit summary |
||
| 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] | ||
*[http://www.tizag.com/mysqlTutorial/mysqljoins.php MySQL joins] | *[http://www.tizag.com/mysqlTutorial/mysqljoins.php MySQL joins] | ||
*[[MySQL replication]] | |||
===Tuning MySQL=== | ===Tuning MySQL=== | ||
| Line 19: | Line 20: | ||
*[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] | ||
*[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] | ||
==FAQ== | ==FAQ== | ||
===Fix privileges=== | ===Fix privileges=== | ||
mysql_fix_priviÂlege_tables | mysql_fix_priviÂlege_tables | ||
Revision as of 12:27, 26 February 2008
Documentation
- Homepage
- Documentation
- A collection of mysql commands
- MySQL C API Functions
- MySQL joins
- MySQL replication
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
