MySQL: Difference between revisions
From DWIKI
m (→Documentation) |
mNo edit summary |
||
| Line 10: | Line 10: | ||
*[http://www.artfulsoftware.com/infotree/queries.php Common mysql queries] | *[http://www.artfulsoftware.com/infotree/queries.php Common mysql queries] | ||
*[[MySQL Replication]] | *[[MySQL Replication]] | ||
===Show syntax=== | |||
http://dev.mysql.com/doc/refman/5.1/en/show.html | |||
===Tuning MySQL=== | ===Tuning MySQL=== | ||
Revision as of 12:53, 17 July 2008
Documentation
- Homepage
- Documentation
- MySQL Tutorial
- MySQL Cheat Sheet
- A collection of mysql commands
- MySQL C API Functions
- MySQL joins
- MySQLForge Wiki
- Common mysql queries
- MySQL Replication
Show syntax
http://dev.mysql.com/doc/refman/5.1/en/show.html
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
