Sample Header Ad - 728x90

Tokudb ROW_FORMAT is not being accepted

1 vote
1 answer
821 views
I am trying to create some tokudb tables to experiment with the different row format options to compare the compression available. https://www.percona.com/doc/percona-server/5.7/tokudb/using_tokudb.html I have tried all the following TOKUDB_SNAPPY TOKUDB_ZLIB TOKUDB_DEFAULT With no effect. If I just ignore it the tables are created with row_fromat = fixed. MariaDB [eventlog]> show VARIABLES like "%row_format%"; +--------------------------------+-------------+ | Variable_name | Value | +--------------------------------+-------------+ | tokudb_hide_default_row_format | ON | | tokudb_row_format | tokudb_zlib | +--------------------------------+-------------+ MariaDB [eventlog]> 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 MariaDB server version for the right syntax to use near 'TOKUDB_DEFAULT' at line 1 MariaDB [eventlog]> CREATE TABLE stable1 ( column_a INT NOT NULL PRIMARY KEY, column_b INT NOT NULL) ROW_FORMAT=tokudb_default; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'tokudb_default' at line 1 MariaDB [eventlog]> CREATE TABLE stable1 ( column_a INT NOT NULL PRIMARY KEY, column_b INT NOT NULL) ENGINE=TokuDB; Query OK, 0 rows affected (0.09 sec) MariaDB [eventlog]> show table status from eventlog\G; *************************** 1. row *************************** Name: stable1 Engine: TokuDB Version: 10 Row_format: Fixed Rows: 0 Avg_row_length: 0 Data_length: 0 Max_data_length: 9223372036854775807 Index_length: 0 Data_free: 18446744073709551615 Auto_increment: NULL Create_time: 2017-02-20 12:26:18 Update_time: 2017-02-20 12:26:18 Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options: Comment: MariaDB [eventlog]> ALTER TABLE stable1 ROW_FORMAT=TOKUDB_SNAPPY; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TOKUDB_SNAPPY' at line 1 version | 10.1.21-MariaDB tokudb_version | 5.6.34-79.1
Asked by nelaaro (767 rep)
Feb 20, 2017, 11:07 AM
Last activity: Oct 19, 2017, 10:21 AM