query cache to disable totally
Bug #609027 reported by
Vadim Tkachenko
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Medium
|
Oleg Tsarev |
Bug Description
even if query cache is not used (size=0), sometimes I see stalls like
4 pthread_
Query_cache:
Query_cache:
Query_cache:
Query_cache:
mysql_update(
mysql_execute_
mysql_parse(
dispatch_
do_command(
handle_
start_thread
clone
We need to avoid any query_cache call if it is not used ( size=0)
Changed in percona-server: | |
status: | New → Triaged |
importance: | Undecided → Medium |
assignee: | nobody → Oleg Tsarev (tsarev) |
milestone: | none → 5.1-12.0 |
Changed in percona-server: | |
status: | Triaged → In Progress |
Changed in percona-server: | |
status: | In Progress → Fix Committed |
Changed in percona-server: | |
status: | Fix Committed → In Progress |
Changed in percona-server: | |
status: | In Progress → Fix Committed |
Changed in percona-server: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
In MySQL 5.5 it is my understand that the query cache mutex is never
held if the server starts with query_cache_type=0. Maybe we should
backport that to Percona Server?
On Fri, Jul 23, 2010 at 12:28 AM, Oleg Tsarev <email address hidden> wrote: /bugs.launchpad .net/bugs/ 609027
> ** Changed in: percona-server
> Status: Triaged => In Progress
>
> --
> query cache to disable totally
> https:/
> You received this bug notification because you are a member of Percona
> developers, which is the registrant for Percona Server.
>