This session is an overview of InnoDB’s internals from the perspective of what can be changed and how it influences InnoDB’s performance and functionality. There are many constants that were set in the olden days and are now irrelevant. For example, how can you change the insert buffer, how does it work, and why is it important? What is innodb_max_dirty_pages_pct about, and how can it help you? How can we get more information about InnoDB internals? How can we see what the InnoDB buffer pool contains? What is InnoDB currently locking? And of course, what is in the new InnoDB plugin’s INFORMATION_SCHEMA.INNODB* tables and how can we understand them?
Vadim Tkachenko is former MySQL performance engineer, currently running performance consulting company and blog mysqlperformanceblog.com. Co-author of “High Performance MySQL”, 2nd edition book.
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at firstname.lastname@example.org
Download the MySQL Sponsor/Exhibitor Prospectus
For media-related inquiries, contact Maureen Jennings at email@example.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.
View a complete list of MySQL contacts.