Tag: internals

In part 5 of this series, Peter Sylvester, Lead Database Consultant at Pythian, looks at variables that relate to enforcing data consistency, and how index statistics are handled and stored.

In part 4 of this series, Peter Sylvester, Lead Database Consultant at Pythian, looks at the mechanics that impact CPU resourcing and how InnoDB handles concurrent threads.

Introduction A couple of months ago I decided to give myself a refresher on the mechanics of InnoDB. Having a high level understanding of what’s going on under the hood can help provide the context needed in order to resolve…