Buy Percona ServicesBuy Now!
  March, 2014
   Fernando Laudares Camargos, Michael Benshoof, Muhammad Irfan, Nickolay Ihalainen

InnoDB Performance Optimization

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.


Fernando Laudares Camargos
Senior Technical Services 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. He's now focusing on the universe of MySQL with a particular interest in understanding the intricacies of database systems. Fernando lives in the island of Florianópolis, Brazil, with his wife and kids. He enjoys spending time with them doing whatever activity they choose and resort to swimming, cycling and running in his search of balance to a life surrounded by computers. He also has a personal interest in education in general and loves to discuss the subject.

Michael Benshoof
Technical Account Manager
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
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
Senior Technical Services 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. His experience includes extensive hands-on work with a broad range of technologies, including SQL, MySQL, PHP, C, C++, Python, Java, XML, OS parameter tuning (Linux, Solaris), caching techniques (e.g., memcached), RAID, file systems, SMTP, POP3, Apache, networking and network data formats, and many others. He is an expert in scalability, performance, and system reliability. Nickolay has a degree from Moscow State University. His hobbies are Subaru and Mitsubishi Evo engine performance tuning and roller skating. He lives in Moscow with his wife and son.

Visit Percona Store


General Inquiries

For general inquiries, please send us your question and someone will contact you.