We have a loader job that runs inserts into 250GB database which gets blocked by analyze process (I suppose the auto analyze).
turning off innodb_stats_auto_recalc does not help.
Is there any other dependent parameter that needs to be changed .
Looks like a reproducible issue.
If I change use_stat_tables = NEVER (default) there is no blocking since the analyze does not run with cost based optimization not used.