Bug #40820 | Query string "normalization" for query cache. | ||
---|---|---|---|
Submitted: | 18 Nov 2008 12:44 | Modified: | 7 Jul 2017 9:44 |
Reporter: | Vlad GURDIGA | Email Updates: | |
Status: | Won't fix | Impact on me: | |
Category: | MySQL Server: Query Cache | Severity: | S5 (Performance) |
Version: | OS: | Any | |
Assigned to: | CPU Architecture: | Any |
[18 Nov 2008 12:44]
Vlad GURDIGA
[18 Nov 2008 13:08]
Valeriy Kravchuk
Thank you for a reasonable feature request.
[6 Jun 2009 0:25]
lukasz lury
totally agree with this request - i think it's faster to run tolower() for everything but '' contents than to generate another query plan for obviously same query. also reduces query cache usage.
[7 Jul 2017 9:44]
Erlend Dahl
MySQL will no longer invest in the query cache, see: http://mysqlserverteam.com/mysql-8-0-retiring-support-for-the-query-cache/