Re: [ERROR] Unknown/unsupported storage engine: TokuDB

[Tim Callaghan]

Chandu,

After starting TokuDB with your change for the default storage engine, you need to install the plugins.  As per "3.4 Replace an Existing MySQL Instance" of our Getting Started Guide available at http://www.tokutek.com/resources/product-docs/

mysql> install plugin tokudb soname 'ha_tokudb.so';
mysql> install plugin tokudb_user_data soname 'ha_tokudb.so';
mysql> install plugin tokudb_user_data_exact soname 'ha_tokudb.so';
mysql> install plugin tokudb_file_map soname 'ha_tokudb.so';
mysql> install plugin tokudb_fractal_tree_info soname 'ha_tokudb.so';
mysql> install plugin tokudb_fractal_tree_block_map soname 'ha_tokudb.so';
mysql> set global default_storage_engine=TokuDB;

After running these commands you'll see TokuDB in the list of storage engines via the "show engines;" command.

-Tim


On Thursday, June 6, 2013 5:48:49 AM UTC-4, Chandu Nannapaneni wrote:

Hi everyone,

I have downloaded the tokutek CE -  mysql-5.5.30-tokudb-7.0.1-linux-x86_64.tar.gz
trying to use it against my existing data.
Had to add 'datadir=/ssd/mysql' to my.cnf as thats where my existing 5.5 db data is.

When starting mysql with out any further changes to my.cnf i am getting a

130606 14:33:29 mysqld_safe Starting mysqld daemon with databases from /ssd/mysql
130606 14:33:29 InnoDB: The InnoDB memory heap is disabled
130606 14:33:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130606 14:33:29 InnoDB: Compressed tables use zlib 1.2.3
130606 14:33:29 InnoDB: Using Linux native AIO
130606 14:33:29 InnoDB: Initializing buffer pool, size = 128.0M
130606 14:33:29 InnoDB: Completed initialization of buffer pool
130606 14:33:29 InnoDB: highest supported file format is Barracuda.
130606 14:33:29  InnoDB: Waiting for the background threads to start
130606 14:33:30 InnoDB: 5.5.30-tokudb-7.0.1 started; log sequence number 102161668838
130606 14:33:30 [ERROR] Unknown/unsupported storage engine: TokuDB
130606 14:33:30 [ERROR] Aborting

If i add "default_storage_engine=myisam" to my.cnf , its working but list of storage engines does not show TokuDB

what did i miss ?
running ubuntu 12.10 64 bit if that matters

/Chandu