Products & Services‎ > ‎MySQL‎ > ‎

MySQL Performance Tuning




Reference 

  1. Using the New MySQL Query Profiler, http://dev.mysql.com/tech-resources/articles/using-new-query-profiler.html

  2. What should I do to make mysql 100% optimal?, http://stackoverflow.com/questions/1953640/what-should-i-do-to-make-mysql-100-optimal

  3. Optimizing Queries with EXPLAIN, http://dev.mysql.com/doc/refman/5.1/en/using-explain.html
  4. MySQL VIEW as performance troublemaker, http://www.mysqlperformanceblog.com/2007/08/12/mysql-view-as-performance-troublemaker/

  5. Does MySQL view always do full table scan?, http://stackoverflow.com/questions/637328/does-mysql-view-always-do-full-table-scan
  6. Linux and H/W optimizations for MySQL, http://yoshinorimatsunobu.blogspot.com/2011/04/slides-linux-and-hw-optimizations-for_14.html
  7. When does InnoDB compress and decompress pages?, http://www.facebook.com/notes/mysql-at-facebook/when-does-innodb-compress-and-decompress-pages/10150196544635933
  8. Failure to compress, http://www.facebook.com/notes/mysql-at-facebook/failure-to-compress/10150196507950933
  9. MySQL metrics for read workloads, http://dom.as/2011/05/19/mysql-metrics-for-read-workloads/
  10. Can you explain how buffer pools relate to MySQL and databases, in general?, http://searchenterpriselinux.techtarget.com/answer/Buffer-pools-in-MySQL