Tag: InnoDB

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 >

InnoDB’s Adaptive Hash

With the popularity of multi-core machines (and innodb_thread_concurrency) on the rise, we are seeing more issues with adaptive hash index semaphore deadlocks. I guess there finally is a benefit to having MySQL Enterprise — the ability to disable InnoDB’s Adaptive Hash. If you want, you can hack the source code and compile your own version of MySQL. Only 4 file changes are needed to make the workaround happen, and the changes are detailed here.

Read More >