October 11, 2017

Instant ADD COLUMN for InnoDB

Perhaps one of the most important InnoDB changes coming in MariaDB Server 10.3 is Instant ADD COLUMN for InnoDB tables. Normally, adding a column to a table requires the full table to be rebuilt. With instant ADD COLUMN, all that is needed is a special kind of an INSERT or UPDATE of table metadata. For a large table, instead of taking several hours, the operation would be completed in the blink of an eye.

Read More

May 23, 2017

What's New in MariaDB Server 10.2

We are happy to announce the general availability (GA) of MariaDB Server 10.2! MariaDB Server 10.2 is the newest major version of MariaDB Server, the fastest growing open source relational database.

Read More

October 26, 2016

Does InnoDB page size matter?

From MariaDB 10.1 there is a feature where the InnoDB page size can be configured to be larger than the default 16K for normal, uncompressed tables. However, there has been little performance results that show whether the page size really effects  the transaction performance or response time. In this blog, we study effects of page size on three different storage devices using the same benchmark(s). These devices are:

Read More

March 25, 2014

Get rid of orphaned InnoDB temporary tables, the right way

If InnoDB or XtraDB in MySQL or MariaDB are interrupted while performing an ALTER TABLE, they'll leave a temporary table sitting in your data directory. This thing will be taking up space, which is no good. If you're using innodb-file-per-table, or course, you can solve that problem by removing the .frm and .ibd files for the table.

Read More