Cardinality=0 for all rows in a TokuDB table

Activity

Show:
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 https://bugs.launchpad.net/percona-server/+bug/1651844). This issue is really annoying as it regularly messed up the whole server. Any chance we could have an update on this issue?

Thanks!

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 https://jira.percona.com/browse/TDB-2 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, 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.

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?

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.

Fixed

Assignee

George Lorch

Reporter

George Lorch

Labels

External issue ID

None

Freshdesk Tickets

None

Priority

Major
Configure