Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [tokudb]

Storage engine for MySQL and MariaDB, designed for write-heavy workloads

45 questions
9
votes
5 answers

TokuDB not much faster than MySQL

I have converted a MySQL database with 80.000.000 rows to TokuDB. Now when I run: select count(id) from xxx where active=1 it takes 90% of the time of the normal MySQL request. What do I have to further optimize so that it runs faster? The table…
Ploetzeneder
  • 189
  • 1
  • 1
  • 3
6
votes
2 answers

TokuDB optimize table does not reclaim disk space

Was running an optimize table command against one of my tables about 11Gig in size, surprisingly used disk space grew by 2Gig immediately after optimization process finished. I would expect the optimization to reclaim a space. What's…
user27133
  • 61
  • 1
  • 2
5
votes
1 answer

How do I add a partition to an existing table in mariadb / mysql?

I have the following table. I want to add partitions too. CREATE TABLE `app_log_Test` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `dateCreated` datetime NOT NULL, `host` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `label`…
nelaaro
  • 767
  • 3
  • 10
  • 22
4
votes
3 answers

How can I repair a TokuDB table?

I have a TokuDB table that works fine for most queries, but segfaults on others. I did a CHECK TABLE which indicated that the table had errors. However, TokuDB doesn't support REPAIR TABLE. How can I fix a corrupted TokuDB table? mysql> check table…
Thomas Johnson
  • 481
  • 2
  • 5
  • 13
3
votes
2 answers

Why does TokuDB say to remove innodb_buffer_pool_%?

The TokuDB quick start guide says "After converting your tables to TokuDB, you should comment out the global options related to memory caches (ie: innodb_buffer_pool%)." If TokuDB supports both TokuDB and InnoDB database engines, why would I…
Thomas Johnson
  • 481
  • 2
  • 5
  • 13
3
votes
1 answer

How to convert innodb engine tables to tokudb engine

Hi I want to migarate my server newly installed tokudb engine. i want to convert each table of database from innodb to tokudb. How can I do that using sed command ?
KK Patel
  • 151
  • 1
  • 8
3
votes
0 answers

TokuDB/Percona - Insert Performance worse as table grows

We have a bunch of existing servers which run just fine, inserting our thousand rows/second, but the new batch just will not do it. As the day goes on and the table grows, it gets slower and slower, until we are millions of rows behind. I've tried…
user1576419
  • 31
  • 2
3
votes
1 answer

Tokudb 5.7 [Warning] The partition engine is deprecated and will be removed in a future release

I am running upgrade from Tokudb 5.6.30 to 5.7.17 (Percona distribution) and I am getting this warning [Warning] The partition engine, used by table ‘my_table’, is deprecated and will be removed in a future release. Please use native partitioning…
Michael
  • 31
  • 1
3
votes
2 answers

How to make TokuDB engine on Percona delete faster

I've done some reading on the percona website, most notably MySQL Partitioning: A Flow Chart where they recommend TokuDB as a solution to faster(er) deletes over innoDB rather than partitioning. I've taken a sample table, and have added the same 20M…
Erik
  • 131
  • 4
3
votes
1 answer

TokuDB vs InnoDB Database data size

I have two percona servers, one running with TokuDB tables and the other with InnoDB tables. On each server, i have create a single database, with a single table in it containing 10 millions records using sysbench. But using the query below, i…
The Georgia
  • 343
  • 6
  • 21
2
votes
1 answer

How do I create fractal index using tokudb engine?

I install MariaDb and configured it to use TokuDb Engine. I need to use Fractal-Index Built-in on TokuDb Engine. I have create my index as follow: ALTER TABLE `table__name` ADD INDEX ( `column` ); I Do this following TokuDb wiki. When i go on…
theShadow89
  • 125
  • 3
2
votes
2 answers

InnoDB + TokuDB fills up RAM then start swapping

I'm trying to face difficulties with my database lately. I've migrated from MyISAM to TokuDB v7.0.4 and InnoDB. I'm using MariaDB - 5.5.34-MariaDB-1~wheezy-log. My problem is that MariaDB fills up RAM to about 90% and then starts swapping. After…
pyro
  • 21
  • 3
2
votes
1 answer

TokuDB database size unknown in phpmyadmin

In mysql server, I installed the TokuDB storage engine. I converted database engine InnoDB to TokuDB, but my table sizes show unknown in phpmyadmin.
KK Patel
  • 151
  • 1
  • 8
2
votes
1 answer

Any "faster" methods of backing up databases in mariadb?

I am coming from the Microsoft SQL Server world of databases, and have been there for about 7 years. My new role is solely based in various open source database engines. As I have been prepping for some migrations to AWS RDS and/or newer versions of…
Randoneering
  • 135
  • 9
2
votes
2 answers

Percona 5.7 tokudb poor query performance - wrong (non-clustered) index chosen

I have a table with about 8.5m rows in it. The table is tokudb and it has the indexes described below. I'm experiencing dismal performance when trying to run update statements like the following: update retail.lw_item_discovery set price = 'X',…
Ross
  • 251
  • 2
  • 8
1
2 3