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 accurate statics back
- Recenly. The statics were updated to the same value including some column as gender.
I have tried with below ways but don't work:
- Analyze table
- Drop some index and re-create
- Optimize table & Analyze table
I found a lot people had get the same problem before. Can anyone share some experience?