Cardinality=0 for all rows in a TokuDB table


George Lorch
May 22, 2017, 2:49 PM

I neglected to mention it here but is mentioned in TDB-2, be aware that there is the possibility of a negative performance impact by disabling partial evictions. It does not show everywhere and in some edge cases it may actually improve overall performance. So please keep a watchful eye on the instances where you change it.

jocelyn fournier
May 22, 2017, 2:48 PM

BTW in my case, I do not perform any server restart, so it's perhaps another issue?

jocelyn fournier
May 22, 2017, 2:45 PM

Ah thanks a lot, I've now disabled the partial_eviction on my side, I'll see if the row count continues to drop in my case.

George Lorch
May 22, 2017, 2:39 PM

Hello Jocelyn,
There is a fix for this that will appear in the next release of Percona Server that is undergoing testing right now. It is being tracked in the new Percona TokuDB JIRA project here and also discussed here in DB-1015.

Until the fix is released, you may try disabling tokudb_enable_partial_eviction following a row recount to help mitigate the problem.

jocelyn fournier
May 22, 2017, 9:11 AM

Hi George,

It's there's still some issue with the row counter, especially with INSERT ... ON DUPLICATE KEY (see the comments on This issue is really annoying as it regularly messed up the whole server. Any chance we could have an update on this issue?




George Lorch


George Lorch


External issue ID


Freshdesk Tickets