Tag: InnoDB

Rejoining a Node to MySQL’s InnoDB Cluster

Derek Downey, OSDB Practice Advocate at Pythian, gives you the steps to setup and deploy a local sandbox Cluster as well as the steps to kill a node.

Read More >

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)

In part 3 of this series, Peter Sylvester, Lead Database Consultant at Pythian, continues looking at I/O, specifically the mechanics on how data gets written to table files.

Read More >

Exposing 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 >

Things To Consider When Deciding On A Primary Key For Your INNODB Table

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

Read More >

Log Buffer #450: A Carnival of the Vanities for DBAs

This Log Buffer Editions picks few blog posts from Oracle, SQL Server and MySQL.

Read More >

Log Buffer #432: A Carnival of the Vanities for DBAs

Yet again, this log buffer edition brings some rich blog posts from Oracle, SQL Server and MySQL.

Read More >

Log Buffer #429: A Carnival of the Vanities for DBAs

This Log Buffer Edition gathers a wide sample of blogs and then purifies the best ones from Oracle, SQL Server and MySQL.

Read More >

About MySQL 5.6

I am very excited and thrilled to use the latest release of MySQL 5.6 in production. This is probably the most notable and innovative release from many years, if not ever. I this post I take a detailed look at what is new in MySQL 5.6 and why I think its the best version of MySQL to date

Read More >