Continuity and open collaboration

Posts tagged InnoDB

Table and tablespace encryption on MariaDB 10.1.3

Introduction For the moment, the only engines that fully support encryption are XtraDB and InnoDB. The Aria storage engine also supports encryption, but only for temporary tables. MariaDB supports 2 different way to encrypt data in InnoDB/XtraDB: Specified table encryption: Only tables which you create with PAGE_ENCRYPTION=1 are encrypted. This feature was created by eperi. […]


MariaDB 10.1.1: Defragmenting unused space on InnoDB tablespace

Introduction When you e.g. delete rows, these rows are just marked as deleted not really physically deleted from indexes and free space introduced is not returned to operating system for later reuse. Purge thread will physically delete index keys and rows, but still free space introduced is not returned to operating system and this operation […]


MariaDB 10.1.1: Monitoring progress and temporal memory usage of Online DDL in InnoDB

Introduction Online DDL is a new feature in MariaDB 10.0. Online DDL is processed through below 4 tasks in sequence. InnoDB::ha_prepare_inplace_alter_table(..) InnoDB::ha_inplace_alter_table(..) InnoDB::ha_commit_inplace_alter_table(..) mysql_rename_table(..) InnoDB storage engine allocates temporal memory buffer for transaction logging in phase 1 where row changes during this phase are logged. Size of this buffer is at start sort_buffer_size and it […]


Performance evaluation of MariaDB 10.1 and MySQL 5.7.4-labs-tplc

Introduction Evaluating the performance of database systems is a very demanding task. There are a lot of hard choices to be made, e.g.: What operating system and operating system version is to be used What configuration setup is to be used What benchmarks are to be used and how long are the warm-up and measure […]


Significant performance boost with new MariaDB page compression on FusionIO

The MariaDB project is pleased to announce a special preview release of MariaDB 10.0.9 with significant performance gains on FusionIO devices. This is is a beta-quality preview release. Download MariaDB 10.0.9-FusionIO preview Background The latest work between MariaDB and FusionIO has focused on dramatically improving performance of MariaDB on the high-end SSD drives produced by Fusion-IO […]


Contribute Effortlessly

Activate Your User Feedback Plugin

Tweets by @mariadb

Code statistics