EmergencyEMERGENCY? Get 24/7 Help Now!

Beware the Innodb Table Monitor

 | November 29, 2011 |  Posted In: Insight for DBAs, MySQL

As I stated in my last post, I decided to use the Innodb Table monitor to diagnose an Index count mismatch error a customers found in their mysqld.err log to verify if the problem still existed. The Innodb Table Monitor has existed for basically forever in Innodb (the MySQL manual discusses it back in the 4.1 […]

Read More

Innodb vs MySQL index counts

 | November 29, 2011 |  Posted In: MySQL

I had a customer recently who a few strange errors in their mysqld.err log:

This customer was running Percona Server 5.1 and they got this error on two tables during a maintenance window when they were adding indexes to the same tables.  We had a suspicion that it had something to do with Fast […]

Read More

Avoiding auto-increment holes on InnoDB with INSERT IGNORE

 | November 29, 2011 |  Posted In: MySQL

Are you using InnoDB tables on MySQL version 5.1.22 or newer? If so, you probably have gaps in your auto-increment columns. A simple INSERT IGNORE query creates gaps for every ignored insert, but this is undocumented behaviour. This documentation bug is already submitted. Firstly, we will start with a simple question. Why do we have […]

Read More

A Case for Write Optimizations in MySQL

 | November 21, 2011 |  Posted In: Tokutek, TokuView

As a storage engine developer, I am excited for MySQL 5.6. Looking at http://dev.mysql.com/tech-resources/articles/whats-new-in-mysql-5.6.html, there has been plenty of work done to improve the performance of reads in MySQL for all storage engines (provided they take advantage of the new APIs). What would be great to add is API improvements to increase the performance of […]

Read More

Should MySQL update the default innodb_log_file_size?

 | November 21, 2011 |  Posted In: Insight for DBAs, MySQL

Now that InnoDB is the default storage engine in MySQL, is it time to update the default configuration for the InnoDB log file size (innodb_log_file_size) setting? In general, there are two settings that simply can’t be left at their historical defaults for a production installation. MySQL 5.5 increased the default buffer pool size to something […]

Read More