Advanced MySQL Optimization Tutorial

1M ySQ L Users Conference 2006 , April 24-27 | M ySQ L P erformance 4.1 vs 5.0 | © M ySQ L AB 2006 | w ww.mysql.comMySQL Performance 4.1 vs 5.0P eter Zaitsev, M ySQ L ABM ySQ L Users Conference 2006Santa Clara, CA April 24-27© MySQL AB 20062M ySQ L Users Conference 2006 , April 24-27 | M ySQ L P erformance 4.1 vs 5.0 | © M ySQ L AB 2006 | w ww.mysql.comIntroduction• Software life cycle performance evolution– What do you think ?• M ySQ L 5.0 vs 4.1 P erformance– Using Well optimized M ySQ L 4.1 features– Implicit usage of M ySQ L 5.0 new featrues– Explicit usage of M ySQ L 5.0 new features3M ySQ L Users Conference 2006 , April 24-27 | M ySQ L P erformance 4.1 vs 5.0 | © M ySQ L AB 2006 | w ww.mysql.comWhat is new version ?• Bugs are fixed– Often meaning more checks are being added, optimizations restricted• New features are added – Requiring more hooks – Increasing code base, data structure sizes, indirection– Algorithms changes required• Local code optimizations– Same algorithms implemented better• Global optimizations– New algorithms and data structures are implemented. M ore efficient4M ySQ L Users Conference 2006 , April 24-27 | M ySQ L P erformance 4.1 vs 5.0 | © M ySQ L AB 2006 | w ww.mysql.comWhat is about MySQL 5.0 ?• New Fe atures:– Stored P rocedures, Triggers, Views • Significantly increase parser complexity• M ore complex data structires, increased level of redirection• M any checks to handle these featues in other ...