Tag - InnoDB

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

Simulating InnoDB Secondary Index Corruption

InnoDB Secondary Index Corruption

Working as a support engineer here at Percona is amazing, as you get a variety of requests, ranging from the most trivial questions to questions that require source code review and understanding of the internals of InnoDB, for example.
In our world where High Availability is a must, everything is about being pro-active, and when […]

Read more