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
6
votes
1 answer

GROUP BY WHERE range AND const ref without temporary

A really basic table containing quotes on instruments across multiple exchanges leveraging the TokuDB storage engine: CREATE TABLE `quotes` ( `ticker` char(4) NOT NULL, `timestamp` time(3) NOT NULL, `price` decimal(7,2) unsigned NOT NULL, …
Steve-o
  • 12,678
  • 2
  • 41
  • 60
5
votes
1 answer

Are Bε Trees guarded by patents?

I have been considering to implement Bε tree indexes in open source project. As far as I understand PerconaFT key value store uses them as a base for their Fractal Indexes, and they claim that they use several US patents - No. 8,185,551 and No.…
Andrey Lomakin
  • 637
  • 3
  • 12
4
votes
2 answers

Switching from MySQL to MariaDB

From my reading of things setting up MariaDB and activating TokuDB on a 64 bit Debian/Ubuntu server is a relatively easy task. I currently use mySQL and have a great deal of (well written, I think) SQL in PHP that uses PDO to access the database. I…
DroidOS
  • 8,530
  • 16
  • 99
  • 171
3
votes
1 answer

How to use XtraDB and TokuDB in Percona?

After trying several times, I finally installed Percona on my Macbook using Homebrew and successfully connected to it via MySQL Workbench, but when I want to create XtraDB tables: Operation failed: There was an error while applying the SQL script to…
user5483434
  • 492
  • 7
  • 17
3
votes
3 answers

mysql_query() keeps running after php exits

I've noticed that if I execute a long running mysql query with php using mysql_query() (I know I'm not supposed to use that) and then the php process gets killed then the query continues to run on the mysql server. This is not a persistent…
crickeys
  • 3,075
  • 3
  • 26
  • 27
3
votes
2 answers

Speed up tokudb "alter table ... engine=TokuDB”

I'm trying to convert a 400 million row Innodb table to the tokudb engine. When I start with "alter table ... engine=TokuDB" things run really fast in the beginning, (Using SHOW PROCESSLIST) I see it reading in about 1 million rows every 10 seconds.…
crickeys
  • 3,075
  • 3
  • 26
  • 27
2
votes
2 answers

Is it fit using TokuDB engine when the record average length is 3k?

The table have two fields: id, content, and only one Primary key(id). The field id type is bigint. The field content type is TEXT, for this field is var-lenth, maybe some record will be 20k, and average length of record is 3k. Table schema: CREATE…
Ben
  • 391
  • 6
  • 13
2
votes
1 answer

MYSQL /MariaDB - TokuDB ... no space left on device

Although there is some space left on the hard drive any insert on a table with the tokuDB storage engine fails with the error: Error Code: 1021. Disk full (); waiting for someone to free some space... (errno: 189 "Disk full") Inserts on other…
mmx73
  • 972
  • 1
  • 8
  • 19
2
votes
1 answer

Creating temporary table from TokuDB query too slow

I have this table in one server: CREATE TABLE `mh` ( `M` char(13) NOT NULL DEFAULT '', `F` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `D` char(6) DEFAULT NULL, `A` int(11) DEFAULT NULL, `DC` char(13) DEFAULT NULL, `S` char(22)…
rasputino
  • 691
  • 1
  • 8
  • 24
2
votes
2 answers

How to handle large amounts of data in MySQL database?

Background I have spent couple of days trying to figure out how I should handle large amounts of data in MySQL. I have selected some programs and techniques for the new server for the software. I am probably going to use Ubuntu 14.04LTS running…
Firze
  • 3,939
  • 6
  • 48
  • 61
2
votes
3 answers

Why TokuDB and InnoDB insert is so slow compared to MyISAM

I have prepared the following SQL statements to compare the performance behavior of MyISAM, InnoDB, and TokuDB (INSERT is executed for 100000 times): MyISAM: CREATE TABLE `testtable_myisam` (`id` bigint(20) NOT NULL AUTO_INCREMENT, `value1` INT…
Ye Huang
  • 639
  • 2
  • 10
  • 21
2
votes
2 answers

Installing tokudb under mariadb, plug in not found

I'm trying to install tokudb under mariadb the lazy way using the debs given here (ubuntu 13.04) https://mariadb.com/kb/en/how-to-enable-tokudb-in-mariadb/ I should run sudo apt-get install mariadb-tokudb-engine-5.5 but if I apt-cache search I get…
Paul Hewson
  • 141
  • 3
2
votes
2 answers

MySQL select optimization

I have several queries that could use some optimization since they take a considerable amount of time, so after reading many of the posts on this site I started to modify my schema and adding/changing indexes to appropriately speed up queries. In…
user1509366
  • 21
  • 1
1
vote
0 answers

Is there any way to disable rollback for TokuDB?

I have Percona MySql v8.0.18-9 installed with TokuDB enabled. I started a LOAD DATA query where I was loading a 100GB file into a TokuDB table. Based on the initial speed of the load, it seemed like the query would take 24 hours. After 24 hours, it…
Akash
  • 11
  • 2
1
vote
1 answer

Problem with "Transparent Huge Pages" on Windows 10 when using Docker

When running percona/percona-server:5.7 image and enable TokuDB it complained about transparent huge pages (THP) is enabled. However I have turned it off under: "Computer Configuration\Windows Settings\Security Settings\Local Policies\User Rights…
krimson.jaron
  • 11
  • 2
1
2 3 4