MySQL 5.5 + InnoDB 1.1: Performance & Scalability

[Edwin DeSouza]

Overview:
http://dev.mysql.com/tech-resources/articles/introduction-to-mysql-55.html

InnoDB Docs:
http://dev.mysql.com/doc/innodb-plugin/1.1/en/innodb-performance.html

InnoDB Presentations:
http://blogs.innodb.com/wp/2010/04/post-conference-roundup-of-innodb-related-info/

MySQL 5.5: InnoDB as Default Storage Engine
http://blogs.innodb.com/wp/2010/09/mysql-5-5-innodb-as-default-storage-engine/

MySQL Benchmarks: dbSTRESS
http://dimitrik.free.fr/blog/archives/2010/11/mysql-performance-55-and-innodb-thread-concurrency.html
http://dimitrik.free.fr/blog/archives/2010/09/mysql-performance-55-notes.html
http://dimitrik.free.fr/blog/archives/2010/05/mysql-performance-improving-stability.html
http://dimitrik.free.fr/blog/archives/2010/04/mysql-performance-554-dbstress.html

MySQL Performance: Quick Tips
http://dimitrik.free.fr/blog/archives/2010/04/mysql-performance-post-notes-after-uc2010.html

MySQL Performance Schema
http://blogs.innodb.com/wp/2010/04/innodb-performance-schema/
http://dimitrik.free.fr/blog/archives/2010/05/mysql-performance-using-performance-schema.html

InnoDB recovery is now faster…much faster!
http://blogs.innodb.com/wp/2010/04/innodb-performance-recovery/

InnoDB Better Scalability with Multiple Rollback Segments
http://blogs.innodb.com/wp/2010/04/innodb-multiple-rollback-segments/

MySQL Multiple Buffer Pools:
http://mikaelronstrom.blogspot.com/2010/09/multiple-buffer-pools-in-mysql-55.html

InnoDB log_sys mutex:
http://mikaelronstrom.blogspot.com/2010/09/split-logsys-mutex-in-mysql-55.html

InnoDB now supports native AIO on Linux:
http://blogs.innodb.com/wp/2010/04/innodb-performance-aio-linux/

InnoDB Purge Thread:
http://dimitrik.free.fr/blog/archives/2010/04/mysql-performance-why-purge-thread-in-innodb.html

InnoDB IO Capacity & Flushing:
http://dimitrik.free.fr/blog/archives/2010/07/mysql-performance-innodb-io-capacity-flushing.html

InnoDB Adaptive Flushing:
http://blogs.innodb.com/wp/2010/09/mysql-5-5-innodb-adaptive_flushing-how-it-works/

InnoDB Change Buffering:
http://blogs.innodb.com/wp/2010/09/mysql-5-5-innodb-change-buffering/



Edited 2 time(s). Last edit at 11/16/2010 11:25AM by Edwin DeSouza.