Questions tagged [tokudb]
Storage engine for MySQL and MariaDB, designed for write-heavy workloads
45
questions
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 ...
- 189
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 ...
- 61
4
votes
1
answer
23k
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 ...
- 727
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 ...
- 471
3
votes
2
answers
802
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 ...
- 131
3
votes
2
answers
174
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 ...
- 471
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 ?
- 151
3
votes
1
answer
841
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 ...
- 31
3
votes
0
answers
255
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, ...
- 31
3
votes
1
answer
717
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 ...
- 333
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:
...
- 251
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 ...
- 21
2
votes
1
answer
483
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 ...
- 135
2
votes
1
answer
465
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` );
...
- 125
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.
- 151
2
votes
1
answer
124
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 ...
- 121
1
vote
2
answers
651
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 ...
- 5,273
1
vote
1
answer
789
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....
- 727
1
vote
1
answer
564
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 ...
- 111
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
`...
- 111
1
vote
1
answer
232
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/...
- 369
1
vote
1
answer
191
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 ...
- 5,273
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, ...
- 2,368
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 ...
- 11
1
vote
0
answers
193
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.
...
- 11
1
vote
1
answer
277
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 ...
- 11
1
vote
0
answers
596
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 ...
- 727
1
vote
0
answers
871
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 ...
- 111
1
vote
1
answer
177
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 ...
- 11
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 ...
- 119
1
vote
0
answers
692
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 ...
- 157
0
votes
2
answers
292
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 ...
0
votes
2
answers
542
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 ...
- 5,273
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
- 101
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 ...
- 109
0
votes
1
answer
111
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 ...
- 727
0
votes
1
answer
436
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. ...
- 227
0
votes
2
answers
758
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 ...
- 121
0
votes
1
answer
50
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 ...
- 125
0
votes
1
answer
180
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, ...
- 471
0
votes
0
answers
43
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 ...
- 141
0
votes
0
answers
105
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 ...
- 1
0
votes
1
answer
422
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 ...
- 121
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 ...
- 367
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, ...
- 111