Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

data modification latency enhancement for table cache #32485

Open
dbsid opened this issue Feb 21, 2022 · 1 comment
Open

data modification latency enhancement for table cache #32485

dbsid opened this issue Feb 21, 2022 · 1 comment
Assignees
Labels
type/enhancement The issue or PR belongs to an enhancement.

Comments

@dbsid
Copy link
Contributor

dbsid commented Feb 21, 2022

Enhancement

Currently, for the tables which is cached(by alter table xxx cache). if there is data modification, the session needs to wait for tidb_table_cache_lease seconds to make sure the cached data is invalidated on all the tidb instances, then proceeds the dml statement.

We need a more efficient way. When executing modification statement on cache tables, notifications should be sent to all other TiDB instances, to invalidate the cached data immediately. In normal case, the wait time should be shorten around milliseconds. In the case when some TiDB instance failing to response, we can fall back to the current wait-for-lease-time-out mechanism.

@dbsid dbsid added the type/enhancement The issue or PR belongs to an enhancement. label Feb 21, 2022
@dbsid dbsid changed the title data modification enhancement for table cache data modification latency enhancement for table cache Feb 21, 2022
@tiancaiamao
Copy link
Contributor

Ref #25293

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/enhancement The issue or PR belongs to an enhancement.
Projects
None yet
Development

No branches or pull requests

2 participants