Reference - Using the New MySQL Query Profiler, http://dev.mysql.com/tech-resources/articles/using-new-query-profiler.html
- What should I do to make mysql 100% optimal?, http://stackoverflow.com/questions/1953640/what-should-i-do-to-make-mysql-100-optimal
- Optimizing Queries with EXPLAIN, http://dev.mysql.com/doc/refman/5.1/en/using-explain.html
- MySQL VIEW as performance troublemaker, http://www.mysqlperformanceblog.com/2007/08/12/mysql-view-as-performance-troublemaker/
- Does MySQL view always do full table scan?, http://stackoverflow.com/questions/637328/does-mysql-view-always-do-full-table-scan
- Linux and H/W optimizations for MySQL, http://yoshinorimatsunobu.blogspot.com/2011/04/slides-linux-and-hw-optimizations-for_14.html
- When does InnoDB compress and decompress pages?, http://www.facebook.com/notes/mysql-at-facebook/when-does-innodb-compress-and-decompress-pages/10150196544635933
- Failure to compress, http://www.facebook.com/notes/mysql-at-facebook/failure-to-compress/10150196507950933
- MySQL metrics for read workloads, http://dom.as/2011/05/19/mysql-metrics-for-read-workloads/
- Can you explain how buffer pools relate to MySQL and databases, in general?, http://searchenterpriselinux.techtarget.com/answer/Buffer-pools-in-MySQL
|
|