[MXS-4215] Allow manual clearing of schemarouter caches Created: 2022-07-25  Updated: 2023-06-28  Resolved: 2023-06-28

Status: Closed
Project: MariaDB MaxScale
Component/s: schemarouter
Affects Version/s: None
Fix Version/s: 23.08.0

Type: New Feature Priority: Major
Reporter: markus makela Assignee: markus makela
Resolution: Fixed Votes: 0
Labels: None

Attachments: File schemarouter-clear-caches.patch    
Sprint: MXS-SPRINT-184, MXS-SPRINT-185

 Description   

As described in MXS-4214, there's a need to have finer control over when the schemarouter caches are emptied as the act of populating the cache causes a one-time increase in query latency.

Being able to manually clear the cache, both globally and for a single user, would make it easier to manage when the expensive work of loading the database and table information takes place.



 Comments   
Comment by markus makela [ 2022-09-06 ]

I needed this for testing of some other stuff so I wrote a patch for it (attached to the issue).

Comment by markus makela [ 2023-06-14 ]

The command should also allow the cache to be marked a stale instead of clearing it completely. This way the cache can still be used if max_staleness is set to a high value.

Generated at Thu Feb 08 04:27:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.