server icon indicating copy to clipboard operation
server copied to clipboard

Published 20 hours ago • verified publisher icon MariaDB

Fix MDEV-29076. If thd->time_zone_used is not used, do not store time…

Open wangteng13 opened this issue 3 years ago • 7 comments

The Jira issue number for this PR is: MDEV-29076 Dynamically update time_zone caused Query_cache stored repetitive select queries.

Description

For the same "Select *" operation, the Query_cache failed to identify them and stores the redundant queries, if changing the option "time_zone" dynamically. This patch identifies whether the query used time_zone, and reduces the redundant queries when changing option "time_zone". Specially, If thd->time_zone_used is not used, do not store 'time_zone' as Query_cache_query_flags.

wangteng13 avatar Jul 11 '22 08:07 wangteng13