Tag - InnoDB

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

Examining MySQL InnoDB Persistent Statistics

MySQL InnoDB Persistent Statistics

A few days ago I wrote about how grossly outdated statistics returned through MySQL’s Information_Schema can be. In that post, Øystein Grøvlen suggested taking a look at mysql.innodb_table_stats and mysql.innodb_index_stats as a better source of information. Let’s do just that!
Let’s start with the good news. Unlike MySQL Data Dictionary Tables (mysql.table_stats, etc),  mysql.innodb_table_stats and […]

Read more

MySQL Encryption: Master Key Encryption in InnoDB

master key encryption innodb

In the previous blog post of this series, MySQL Encryption: Talking About Keyrings, I described how keyrings work. In this post, I will talk about how master key encryption works and what the pros and cons are of using envelope encryption such as a master key.
The idea behind envelope encryption is that you use […]

Read more