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
UPDATE of table metadata. For a large table, instead of taking several hours, the operation would be completed in the blink of an eye.
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.
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:
The MySQL 5.7 April Labs release comes with a preview of spatial indexes for InnoDB, something that I've heard rumours about for quite a while but so far couldn't find any kind of actual confirmation for.
I ran into an interesting issue today, while examining some EXPLAIN outputs, and wanted to share the findings, as some of this is undocumented. Basically, you can start with a very simple InnoDB table - 2 INT columns, Primary Key (PK) on the 1st column, regular index on the 2nd:
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
.ibd files for the table.