Skip to main content

Questions tagged [tokudb]

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

Filter by
Sorted by
Tagged with
2 votes
1 answer
626 views

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 ...
Randoneering's user avatar
0 votes
0 answers
46 views

Performance drop on INSERT INTO SELECT FROM

We have a "system" with a website. When data is added (never updated old data), we create large "temp_data" table fill it with the new data - couple of million rows, then insert ...
Nick's user avatar
  • 141
0 votes
0 answers
108 views

Percona: Analyze table doesn't work

I have a Percona 5.6.28 servers with a=some TokuDB tables. The biggest table has ~120 million rows. Statics keeps changeing in the past hald year: At first. Analyze table with recount model toke ...
Zak's user avatar
  • 1
4 votes
1 answer
24k views

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 ...
nelaaro's user avatar
  • 727
3 votes
0 answers
259 views

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, ...
user1576419's user avatar
0 votes
2 answers
294 views

question about using tokuDB or InnoDB for financial data

we want to use Percona xtraDBcluster for clustering 4 nodes (Master-Master) and we have a finance project which should have a rather large database. The number of tables is not more than 40, but we ...
Ali Fattahi's user avatar
0 votes
1 answer
113 views

how can I get mariadb tokudb to put all its files in directories per database

Is there a way to get tokudb to put all the files it creates for a database into subdirectories. When I started using tokudb the most irritating thing I have found is that it puts all its files into ...
nelaaro's user avatar
  • 727
1 vote
1 answer
268 views

Percona-Server: slow TokuDB queries after upgrading from 5.6 to 5.7. ANALYZE TABLE doesn't resolve the problem

After upgrading from Percona-TokuDB 5.6.29-76.2 to 5.7.19-17 we see some very slow queries on some tables without primary keys, but multiple non-unique indexes. The box we migrated to is pretty well ...
Ralf Engler's user avatar
1 vote
0 answers
198 views

TokuDB table stats row count decreases very fast while adding/updateing data

We run an Percona server with the newest version(5.7.19-17). After a while the cardinality of multiple tables drop to zero. A new created index also have an cardinality of 0 if the existing are zero. ...
Sebastian's user avatar
1 vote
1 answer
305 views

Query sometime not using index

Starting in the middle of last night (of course) I have a query that stops using an index and when that happens, it takes over an hour to complete vs. about 3 seconds when it uses the index. This ...
Jeff Ward's user avatar
1 vote
0 answers
602 views

how do I set the compression level in tokudb

Tokudb has various algorithms, lmza, zlib, zstd etc. These algorithms have the ability to be configured. In that, you can set the compression level to a value between 1 and 10 depending on the ...
nelaaro's user avatar
  • 727
1 vote
0 answers
879 views

MariaDB memory usage growing

I am using MariaDB 10.2.6 + TokuDB plugin on Debian Stretch. Each storage eninge, InnoDB and TokuDB, is set to a buffer/cache size of 12G. This configuration worked fine with MariaDB 10.1.25 on Debain ...
Gabscap's user avatar
  • 111
0 votes
1 answer
443 views

Tokudb buggy and plugin gone missing causing mysql to stop starting?

I have actually installed percona mysql and trying to move from oracle mysql. I have been using innodb for quite some time. I heard and read a lot of about tokudb being able to support large db etc. ...
user8012596's user avatar
3 votes
1 answer
844 views

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 ...
Michael's user avatar
  • 31
1 vote
1 answer
796 views

Tokudb ROW_FORMAT is not being accepted

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....
nelaaro's user avatar
  • 727
1 vote
1 answer
178 views

TokuDB Hot Column Expansion

I need to expand a varchar field length from 255 to 4000. I am using tokudb_version: tokudb-7.5.8 running on Linux 3.16.0-60-generic #80~14.04.1-Ubuntu SMP Wed Jan 20 13:37:48 UTC 2016 x86_64 x86_64 ...
Kyalo's user avatar
  • 11
0 votes
1 answer
424 views

MariaDB 5.5.47 but cannot Install TokuDB

This is on CentOS 7.1, sudo yum install MariaDB-tokudb-engine says there's no such package and if I try to start the server with plugin-load=ha_tokudb in my.cnf I get [ERROR] Can't open shared ...
Recct's user avatar
  • 121
1 vote
1 answer
222 views

TokuDB table stats row count decreases to 1

I have a few Percona 5.6.30 servers with a TokuDB table that has ~120 million rows. On some of these servers, row count in SHOW TABLE STATUS mysteriously decreases until is hits 1. This is accompanied ...
che's user avatar
  • 119
2 votes
2 answers
1k views

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: ...
Ross's user avatar
  • 251
1 vote
1 answer
235 views

Does TokuDB need any regular cleanup/maintenance?

PostgreSQL has vacuum and InnoDB has purge. Does TokuDB have any required maintenance/cleanup operations? I couldn't find anything in the online docs: https://www.percona.com/software/mysql-database/...
da99's user avatar
  • 369
3 votes
2 answers
806 views

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 ...
Erik's user avatar
  • 131
3 votes
1 answer
719 views

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 ...
The Georgia's user avatar
2 votes
1 answer
125 views

Which Table Will Get Locked With This Query

INSERT INTO stats.cps (time_stamp,entries,cust_id) select start_time, count(*) , c_id from gb.str where start_time between '$DATE10' and '$DATE' group by start_time, src_id order by start_time ASC I ...
Recct's user avatar
  • 121
0 votes
2 answers
545 views

Tokudb HotBackup

I was trying to evaluate the latest tokudb Hotbackup for percona's tokudb engine. This install is under debian (Ubuntu 14) I was able to get all the packages installed with out error and get all the ...
atxdba's user avatar
  • 5,273
0 votes
1 answer
96 views

handler socket on tokudb engine

I am trying to setup handler socket to work with tokudb engine. Database I am running is percona server and i have got tokudb enabled and the tables all have tokudb engine. I was wondering if anyone ...
roger moore's user avatar
1 vote
1 answer
192 views

Can anyone explain TokuDBs seemingly large amount of data_free for an append only table?

I have a large table I've been maintaining replicating in parallel in innodb in one slave and tokudb in another. I'm seeing promising results in expected compression ratios but am noticing something ...
atxdba's user avatar
  • 5,273
0 votes
2 answers
760 views

TokuDB + MariaDB 10: should I use a clustered index

I have a large table (200 Columns.. I know, but it wasn't my design) that will grow fast and I will have a lot of useless rows in it, identified by an IP (a varchar 32 column). The table will get ...
Recct's user avatar
  • 121
0 votes
1 answer
1k views

Tokudb storage engine as mysql-cluster storage engine

Can we use tokudb storage engine as mysql-cluster storage engine? If can, how? I search over google and found nothing
oentoro's user avatar
  • 101
1 vote
1 answer
565 views

In which situations is TokuDB higher performance? [closed]

I noticed that WordPress runs quite a bit faster when I use XtraDB (MariaDB's InnoDB replacement) instead of TokuDB. This is strange, because TokuDB is advertised as being 20x faster. However, I ...
Andrew Sun's user avatar
0 votes
1 answer
51 views

Join Operation using index defined?

I need to optimize some queries with several joins. I plan to create some indexes for these queries. I am currently using MariaDB with TokuDB storage engine. Should I expect the indexes for the join ...
theShadow89's user avatar
2 votes
1 answer
466 views

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` ); ...
theShadow89's user avatar
1 vote
1 answer
509 views

Install MariaDB 10 Generic Binaries + TokuDB

I used to install MariaDB from Generic Binaries on a Debian Wheezy 64bits: mariadb-10.0.13-linux-x86_64.tar.gz (from downloads.mariadb.org) I would like to use TokuDB as Storage Engine. However, ...
Nicolas Payart's user avatar
0 votes
1 answer
336 views

How to install TokuDB on MAMP

I'm by no means a DB admin. Just a hobbyist actually, and more of a programmer than a database person. I have MAMP 3.05, PHP 5.5.10, Mac OSX 10.9.3. I have a big suite of PHP applications and a ...
SaganRitual's user avatar
1 vote
2 answers
652 views

Any way to force "garbage collection" in TokuDB?

Playing around with TokuDB I'm finding even after "optimize table" for things such as changing row compression or other DDLs it takes a non deterministic amount of time for freed space to be reflected ...
atxdba's user avatar
  • 5,273
0 votes
0 answers
1k views

TokuDB fails to load in MariaDB, even when transparent hugepages are disabled [closed]

Earlier, I upgraded my website server to Ubuntu 14.04 LTS. I had a very nice setup with MariaDB and the TokuDB engine. However, the setup was kind of messed up when TokuDB refused to load properly, ...
Andrew Sun's user avatar
0 votes
1 answer
182 views

Is there a table size above which SELECT performance degrades significantly?

In MySQL, does SELECT performance degrade significantly after a certain table size? I have a table with about 107 million rows and some queries seem stuck in "Sending data" for a long time. Of course, ...
Thomas Johnson's user avatar
4 votes
3 answers
2k views

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 ...
Thomas Johnson's user avatar
3 votes
2 answers
175 views

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 ...
Thomas Johnson's user avatar
1 vote
0 answers
693 views

Missing rows in MyISAM tables with 10-20 billion records

I've got 2 tables with 10-20 billion records each. Currently these are in MyISAM (MySQL). They only require to be built and indexed once, after this only SELECT is used. They are currently ...
Alasdair's user avatar
  • 157
2 votes
2 answers
2k views

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 ...
pyro's user avatar
  • 21
6 votes
2 answers
2k views

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 ...
user27133's user avatar
2 votes
1 answer
1k views

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's user avatar
  • 151
3 votes
1 answer
2k views

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's user avatar
  • 151
1 vote
2 answers
255 views

TokuDB/InnoDB Question

What's the faster scheme for insert data to TokuDB or InnoDB Engine? Over 200 Insert per second. That's okay to answer of one engine. TABLE: `game` `gameId` bigint 20 (PK) `gameMapId` int 4 `...
kargnas's user avatar
  • 111
9 votes
5 answers
18k views

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 ...
Ploetzeneder's user avatar