Tag - InnoDB

Tuning MySQL/InnoDB Flushing for a Write-Intensive Workload

MySQL InnoDB Flushing

In this post, the third in a series explaining the internals of InnoDB flushing, we’ll focus on tuning. (Others in the series can be seen at InnoDB Flushing in Action for Percona Server for MySQL and Give Love to Your SSDs – Reduce innodb_io_capacity_max!)
Understanding the tuning process is very important since we don’t want to […]

Read more

Setting up an InnoDB Cluster With a Few Lines of Code

Setting up an InnoDB Cluster

In this day and age, large enterprise companies make use of Ansible, Puppet, or Chef to provision MySQL servers, be it replica sets or clusters. This eases the burden of deployment and workflow management.
However, for some smaller companies, the learning curve hampers the immediate adoption of automation software. This is where the MySQL Shell […]

Read more

[Warning] InnoDB: Difficult to Find Free Blocks in the Buffer Pool

InnoDB Buffer Pool

A couple of weeks ago, one of our customers reached us asking about the WARNING messages in their MySQL error log. After a while, there were a few more requests from some other customers asking whether to worry about these messages or not. In this post, I am going to write about the condition […]

Read more

Sysbench and the Random Distribution Effect

Sysbench and the Random Distribution Effect

What You May Not Know About Random Number Generation in Sysbench
Sysbench is a well known and largely used tool to perform benchmarking. Originally written by Peter Zaitsev in early 2000, it has become a de facto standard when performing testing and benchmarking. Nowadays it is maintained by Alexey Kopytov and can be found in […]

Read more

MySQL ERROR 1034: Incorrect Key File on InnoDB Table

MySQL ERROR 1034: Incorrect Key File on InnoDB Table

Sometimes, you may experience “ERROR 1034: Incorrect key file” while running the ALTER TABLE or CREATE INDEX command:

Shell

mysql> alter table ontime add key(FlightDate);
ERROR 1034 (HY000): Incorrect key file for table ‘ontime’; try to repair it

12

mysql> alter table ontime add key(FlightDate);ERROR 1034 (HY000): Incorrect key file for table ‘ontime’; try to repair it

As the error […]

Read more