"TokuDB: Auto scheduling background analysis" continuously appearing in log file

Hello Vlasky,
First, I am curious why you are using TokuDB for tables with only 1 and 20 rows. TokuDB was designed for ‘big data’, tables with millions and billions of rows. It will not perform as well as InnoDB for smaller data sets.

So on to your question:

The new auto analysis behavior is described here [url]https://www.percona.com/doc/percona-server/5.7/tokudb/tokudb_background_analyze_table.html[/url]

It was modeled loosely on similar functionality that exists within InnoDB but with more flexibility and intending to be as lock-less as possible since analysis can take some time.

Since your tables are so small, you might want to disable the ‘automatic’ nature of this feature by setting the global variables tokudb_auto_analyze=0 and tokudb_analyze_in_background=false. It will then behave as it did in 5.5/5.6 where TokuDB index cardinality statistics will need to be manually updated by explicitly executing “ANALYZE TABLE …”


George O. Lorch III
Software Engineer, Percona