]]> ]]>

You are here

InnoDB Performance Optimization

March, 2014

In this eBook we'll begin with a review of InnoDB performance optimization basics and continue with the revelation of one common pitfall you'll want to avoid when working with InnoDB file formats. Next we'll show you how to move the InnoDB log sequence number (LSN) forward (when it is stuck in the future) and finally we'll open the hood of MySQL 5.6 and expose InnoDB Memcached Plugin as a caching layer.

Stored Under: Percona Server, Performance Optimization

Authors

Fernando Laudares Camargos

Fernando Laudares Camargos

Support engineer

Fernando joined Percona in early 2013 after working 8 years for a Canadian company specialized in offering services based in open source technologies. Fernando's work experience includes the architecture, deployment and maintenance of IT infrastructures based on Linux, open source software and a layer of server virtualization. From the basic services such as DHCP & DNS to identity management systems, but also including backup routines, configuration management tools and thin-clients.


Michael Benshoof

Michael Benshoof

Senior Consultant

Michael works as a US based consultant. Prior to joining Percona, Michael spent several years in a DevOps role in a company that developed and maintained a SaaS application specializing in social networking. His experiences include application development and scaling, systems administration, along with database administration and design. He enjoys designing extensible and flexible solutions to problems and has a strong background in HA systems. He lives with his family in Norman, Oklahoma. When not working, he enjoys golfing, grilling, watching sports, and spending time with the family.


Muhammad Irfan

Muhammad Irfan

Software Engineer

Muhammad Irfan is vastly experienced in the LAMP Stack. He joined Percona in December 2012 as Support Engineer. Prior to joining Percona, he worked in the role of MySQL DBA & LAMP Administrator, maintained high traffic websites, and worked as a Consultant. His professional interests focus on MySQL scalability and on performance optimization. In his spare time, he normally spends time with family and friends and loves to play and watch cricket. He currently lives in Karachi, Pakistan, with his wife and son.


Nickolay Ihalainen

Nickolay Ihalainen

Senior support engineer

Nickolay joined Percona in December 2010, after working for several years at what is now the most popular cinema site in Russia. During the time he was there, Nickolay and a small team of developers were responsible for scaling the site into one which now serves over a million unique visitors per day. Prior to that, he worked for several other companies, including NetUp, which provides ISP billing and IPTV solutions, and eHouse, the oldest Russian e-commerce company. Nickolay has a great deal of experience in both systems administration and programming.



]]>