Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.3.7
-
None
-
pre-prod
Description
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.