Advanced MySQL Optimization Tutorial

1MySQ L U sers C onference 2005 , A pril 18-21 | A dvanced MySQ L Optimization Tutorial | © MySQ L A B 2005 | w ww.mysql.com Advanced MySQL Performance OptimizationPeter Zaitsev, Tobias A splundMySQ L A BMySQ L U sers C onference 2005Santa C lara, C A A pril 18-21© MySQL AB 20052MySQ L U sers C onference 2005 , A pril 18-21 | A dvanced MySQ L Optimization Tutorial | © MySQ L A B 2005 | w ww.mysql.comIntroductions• Peter Zaitsev, MySQ L Inc– Senior Performance E ngineer– MySQ L Performance G roup Manager– MySQ L Performance consulting and partner relationships• To bias A splund – MySQ L Training C lass Instructor– MySQ L Performance Tuning C onsultant3MySQ L U sers C onference 2005 , A pril 18-21 | A dvanced MySQ L Optimization Tutorial | © MySQ L A B 2005 | w ww.mysql.comTable of Contents• A bit of Performance/Benchmarking theory• A pplication A rchitecture issues• Schema design and query optimization• Sever Settings O ptimizations• Storage E ngine O ptimizations• Replication • C lustering• Hardware and O S optimizations• Real world application problems 4MySQ L U sers C onference 2005 , A pril 18-21 | A dvanced MySQ L Optimization Tutorial | © MySQ L A B 2005 | w ww.mysql.comQuestion Policy• Interrupt us if something is unclear• Keep long generic questions to the end• A pproach us during the conference • Write us: peter@ mysql.com, tobias@m ysql.com5MySQ L U sers C onference 2005 , A pril 18-21 | A dvanced MySQ L Optimization ...