Skip to content

Update the stats cache batch by batch instead of updating once in periodic statistics update worker #57953

@winoros

Description

@winoros

Enhancement

Image
In our big test cluster, many tables may be updated in one single round updating.
Image
Currently, we only call the UpdateStatsCache only once when we get all the tables finished.

It's not very efficient and may cause inconsistency issues since the interval between getting a table from the cache and pushing the table back to the cache may be quite long.

Metadata

Metadata

Assignees

No one assigned

    Labels

    affects-8.5This bug affects the 8.5.x(LTS) versions.sig/plannerSIG: Plannertype/enhancementThe issue or PR belongs to an enhancement.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions