Tag - Storage Engine

The Road Story of a MyRocks/MariaDB Migration

myrocks migration

This post has been written in collaboration with Nicolas Modalvsky of e-planning. Nicolas and I recently worked together on a tuning engagement involving MyRocks on MariaDB. While it is easy to find online articles and posts about InnoDB performance, finding information about MyRocks tuning is more difficult. Both storage engines are well documented but […]

Read more

MariaDB S3 Engine: Implementation and Benchmarking

MariaDB S3 Engine

MariaDB 10.5 has an excellent engine plugin called “S3”. The S3 storage engine is based on the Aria code and the main feature is that you can directly move your table from a local device to S3 using ALTER. Still, your data is accessible from MariaDB client using the standard SQL commands. This is […]

Read more

A MongoDB Prototype With New Heterogeneous-Memory Storage Engine (Hse)

mongodb heterogeneous memory storage engine

Introducing a new MongoDB Storage Engine
Q. What is the Heterogeneous-memory Storage Engine?
A key value store library developed (and open-sourced) by Micron that will work with any normal storage but works especially well with emerging SSDs or NVDIMMS (or other Storage Class Memory) that have faster even NVM media in them (Bleeding-edge NAND, or Optane […]

Read more

DBA Concerns About Next-Gen, Non-Volatile Memory Storage Products

DBA Concerns Memory Storage

Abstract: Storage engine algorithmic gains have mostly settled and Moore’s law for CPU speed is bottoming out, but database performance still stands to increase ~10x thanks to continuing NAND Flash improvement, Optane, Flash-idiomatic SSD drives (e.g. OpenChannel, Zoned Namespaces), KeyValue SSD, etc. The downside is each storage engine revolution historically has broken encapsulation/reuse and […]

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