在“TOKUDB_DEFAULT”附近使用正确的语法

Question

mysql> CREATE TABLE stable1 ( column_a INT NOT NULL PRIMARY KEY, column_b INT NOT NULL) ENGINE=TokuDB, ROW_FORMAT=TOKUDB_DEFAULT;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TOKUDB_DEFAULT' at line 1

CREATE TABLE stable1 ( column_a INT NOT NULL PRIMARY KEY, column_b INT NOT NULL) ENGINE=TokuDB ROW_FORMAT=tokudb_zlib;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tokudb_zlib' at line 1

它在PerconaServer8.0上

为什么？?

Answer 1

很可能是JIRA链接中的更改：https://jira.percona.com/browse/PS-4942

若要使用特定的row_format或tokudb_row_format，请执行以下操作：

SET SESSION tokudb_row_format=TOKUDB_LZMA;
CREATE TABLE stable1 ( column_a INT NOT NULL PRIMARY KEY, column_b INT NOT NULL) ENGINE=TokuDB;

要检查表使用了什么压缩方法，可以从shell中运行以下命令：

tokuftdump --header <tablename>_main*.tokudb