Tag: mysql configuration

Exposing Innodb internals via system variables: part 5, consistency / statistics handling

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.

Read More >

Exposing Innodb Internals via system variables: part 4, concurrency

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.

Read More >

Exposing Innodb internals via system variables: part 3, I/O (table data)

Peter Sylvester takes a look at the mechanics of how data gets written to table files as well as how background threads read from them.

Read More >

Exposing Innodb Internals via System Variables: Part 1, MemoryExposing Innodb Internals via System Variables: Part 1, Memory

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…

Read More >