TokuDB Differences
You are viewing an old version of this article. View
the current version here.
Because we, the MariaDB developers, don't want to add a lot of new features or big code changes to a stable release, not all TokuDB features will be merged at once into MariaDB. Instead they will be added in stages.
On this page we list all the known differences between the TokuDB from Tokutek and the default MariaDB version from MariaDB.org:
All MariaDB versions
- TokuDB is not the default storage engine.
- If you want to enable this, you have to start mysqld with:
--default-storage-engine=tokudb
.
- If you want to enable this, you have to start mysqld with:
- Auto increment for second part of a key behaves as documented (and as it does in MyISAM and other storage engines).
- The DDL syntax is different. While binaries from Tokutek have the patched SQL parser, TokuDB in MariaDB uses the special Storage Engine API extension. Thus in Tokutek binaries you write
CLUSTERED KEY (columns)
and, for example,ROW_FORMAT=TOKUDB_LZMA
. And in MariaDB you writeKEY (columns) CLUSTERING=YES
andCOMPRESSION=TOKUDB_LZMA
. - IMPORTANT: If
COMPRESSION=
is not included inCREATE TABLE
orALTER TABLE ENGINE=TokuDB
then the TokuDB table will not be compressed, as the compression type does not currently default to thetokudb_row_format
session variable as it does with Tokutek's builds.
Features missing in MariaDB 5.5
- No online ALTER TABLE.
- All alter table that changes data or indexes requires a table copy.
- No online OPTIMIZE TABLE.
- No
INSERT NOAR
orUPDATE NOAR
commands. - No gdb stack trace on sigsegv
Features missing in MariaDB 10.0
MariaDB 10.0 (starting from 10.0.5) has online ALTER TABLE. So the features missing will be:
- No
INSERT NOAR
orUPDATE NOAR
commands.- We are working with Tokutek to improve this feature before adding it to MariaDB.
- No online OPTIMIZE TABLE
- No gdb stack trace on sigsegv
Version of the TokuDB plugin included on MariaDB
The status variable tokudb_version
contains the TokuDB version of the plugin included on MariaDB.
In MariaDB 5.5.33, MariaDB 10.0.5, and MariadB 10.0.6 the version included is 7.0.4
.
In MariaDB 5.5.34, the version included is 7.1.0
.
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.