Author: Peter Sylvester

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.

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.

In part 2 of this series, Peter Sylvester, Lead Database Consultant at Pythian, takes a closer look at I/O structure and log related variables.

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…

Peter Sylvester, Lead Database Consultant at Pythian, explains why you should consider explicitly defining a primary key, and how it should be formed.

My job is almost completely reliant upon my ability to perform work in lab of virtual machines. Almost every action plan I write is tested locally. When I need to troubleshoot an issue for a client one of the most…