All Questions

Tagged with
Filter by
Sorted by
Tagged with
0
votes
0answers
22 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 ...
3
votes
0answers
161 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, ...
1
vote
1answer
192 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 ...
1
vote
0answers
141 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. ...
3
votes
1answer
626 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 ...
3
votes
2answers
593 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 ...
1
vote
2answers
562 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 ...