[MDEV-16531] Insert starts analyze table caulsing the insert process to be blocked with use_stat_tables = PREFERABLY - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Not a Bug
Affects Version/s: 10.3.7
Fix Version/s: N/A
Component/s: Data Manipulation - Insert, Optimizer
Labels:
None
Environment:
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.

Attachments

Activity

People

Assignee:: Unassigned

Reporter:: Ramesh

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2018-06-19 18:42

Updated:: 2018-06-20 20:09

Resolved:: 2018-06-20 20:09

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.