The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
28 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 ...
0
votes
1answer
107 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 ...
0
votes
1answer
478 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
0
votes
1answer
172 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 ...
0
votes
1answer
33 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 ...
1
vote
1answer
104 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` ); ...
0
votes
1answer
161 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, ...
0
votes
1answer
133 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 ...
1
vote
2answers
219 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 ...
0
votes
0answers
655 views

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

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, ...
0
votes
1answer
101 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, ...
1
vote
2answers
455 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 ...
3
votes
2answers
68 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 ...
1
vote
0answers
285 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 ...
1
vote
2answers
1k 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 ...
4
votes
2answers
796 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 ...
1
vote
1answer
552 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.
3
votes
1answer
918 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 ?
1
vote
2answers
196 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 ...
5
votes
5answers
7k 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 ...