Stack Overflow
Stack Overflow

Questions tagged [tokudb]

TokuDB is a storage engine for MySQL that is designed for high performance on write-intensive workloads while providing high compression and schema flexibility.

TokuDB is a storage engine for MySQL that is designed for high performance on write-intensive workloads. It uses Fractal Tree indexing, which is based on cache-oblivious algorithms (algorithms designed to take advantage of a CPU cache without having the size of the cache as an explicit parameter). TokuDB also enables high compression and schema flexibility, as indexes can be added and columns add/dropped/expanded without downtime.

51 questions
1
vote
0 answers

TokuDB: Index cardinality drops to zero

I use TokuDb from Percona on some of our db servers. I set up the db, add first chunks of data and every thing works fine. After a while and adding millions of entries I notice a heavy lose in db performance. Turns out, the indexes of some tables…
Sebastian
  • 41
  • 5
1
vote
2 answers

Why does TokuDB impose a limit of 64 keys per table?

Why does TokuDB impose a limit of 64 keys per table by default, while systems like Elasticsearch allow any number of fields to be indexed (limited only by available resources)?
user553965
  • 1,199
  • 14
  • 15
1
vote
0 answers

I have a table without a PRIMARY KEY, but a there is a UNIQUE KEY present should I set it to PRIMARY?

I created a new table to store 20 Giga of data, I mistaken when I set indexes. In fact all my indexes are good, and one of them is a UNIQUE KEY between 3 columns. Normally this key should have been the PRIMARY KEY. I estimated the cost in time of…
Sébastien Bémelmans
  • 869
  • 2
  • 8
  • 17
1
vote
1 answer

How to do more then 50.000 inserts per second with tokudb?

Currently I'm testing out TokuDB and I'm very impressed. At this moment the inserts per second have peaked to just over 50.000 per second with two simultanious jobs running. The average insert rate is between 38.000 and 42.000 inserts per second. I…
Robbert
  • 444
  • 5
  • 13
1
vote
0 answers

What is the better way to insert / replace 10-20 millions of records into a table in mysql(tokudb)

Data Structure : Main table (500 Millions) : CREATE TABLE USER_DETAILS ( visitor_id varchar(50) DEFAULT NULL, partition_id INT, related_text longtext, creation_date timestamp DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (visitor_id,partition_id) )…
Harshada Madav
  • 11
  • 1
1
vote
1 answer

MySQL5.6 vs Percona 5.7 implicit conversion issue

We've recently begun testing an upgrade from mySQL5.6 to percona server 5.7 and the use of tokuDB tables. The database is serving our PHP 5.5 application which use PDO library for parameterized querying. Upon loading up percona with identical data…
Ross
  • 1,639
  • 1
  • 18
  • 22
1
vote
0 answers

Tokudb hot backup in MariaDB

how Tokudb hot backup can be used in MariaDB comminuty edition? (https://github.com/percona/tokudb-backup-plugin) I have read that now this library is included in community edition, but this SQL gives out error: set…
Vadim
  • 11
  • 2
1
vote
1 answer

Restore/Recover/Recreate tokudb table (from missing status file)

I have a TokuDB table that for some reason has a missing ***_status.tokudb file. I am not yet sure, whether the file is missing due to a TokuDB crash or not. Question is: Is there a way to recover or recreate the status file from the main and key…
Kshitij Banerjee
  • 1,678
  • 1
  • 19
  • 35
1
vote
1 answer

Percona TokuDB recovery running over 24 hours

Background Yesterday, we had a situation that presented (at least to my eyes) like a deadlock. A Truncate table (running against an un-contended) table, had been issued, it's status was "query completed" but never cleared from the process list. …
MDB
  • 21
  • 3
1
vote
0 answers

workaround for "Too many keys specified; max 64 keys allowed" error in MariaDB / TokuDB?

I need to create more than 64 indexes on a table but am running into the "Too many keys specified; max 64 keys allowed" error. Is there some workaround that would allow me to increase this limit beyond 1000 for MariaDb / TokuDB? or is there a reason…
user3911479
  • 83
  • 2
  • 9
1
vote
1 answer

Tokudb and Fractal trees Index

I have a doubt regarding the use of fractal trees index in my tables. I create table specifing the TokuDB engine CREATE TABLE `My_table` ( ... ) ENGINE=TokuDB Documentation says: "TokuDB uses a particular data structure called fractal trees, which…
Andrea Zonzin
  • 1,124
  • 2
  • 11
  • 26
1
vote
1 answer

TokuDB sorting time different between ASC vs DESC

This is MariaDB + TokuDB 7.1 community downloaded from Tokutek. Please accept my ignorance if this is normal behavior but I have a question about sorting results. I'm experiencing huge time difference in sorting between the two sort directions -…
user1765811
  • 73
  • 4
0
votes
1 answer

Strange phantom table in the MySQL Percona 8.0

I have MySQL server: mysql Ver 8.0.21-12 for Linux on x86_64 (Percona Server (GPL), Release 12, Revision 7ddfdfe). Used to have several TokuDB tables. Changed them to InnoDB, disabled the TOKU plugin. Trying to migrate to a new instance without…
Maxim Demkin
  • 1,215
  • 11
  • 13
0
votes
2 answers

How to install Percona 5.7 with TokuDB from tar file

How use Percona 5.7 with engine TokuDB using the tar file? I want to install the binary that can be found here: https://www.percona.com/downloads/Percona-Server-5.7/LATEST/ I have done the following steps: mkdir -p ./service mkdir -p…
Reyansh
  • 1
0
votes
1 answer

Index not working properly while joining tables with two different engines (TokuDB and InnoDB)

I am trying to join two tables which are on two different engines. One is on Innodb and other is on Tokudb. Query is something like: select * from table1 t1, table2 t2 where t1.a = t2.x and t1.b = 'xyz'; Here table1 has a(indexed), b(indexed), c…
MrTambourineMan
  • 1,025
  • 1
  • 11
  • 19
1
2
3 4