accessing information_schema.partitions causes plans to change
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
|||
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
High
|
Sergei Glushchenko | ||
5.5 |
Fix Released
|
High
|
Sergei Glushchenko | ||
5.6 |
Fix Released
|
High
|
Sergei Glushchenko |
Bug Description
This is to track upstream bug http://
All credits to Justin Swanhart.
[9 May 4:22] Justin Swanhart
Description:
MySQL 5.6 supposed supports persistent statistics.
I enabled persistent statistics in my "my.cnf" and I also enabled them with the ALTER TABLE statement. However, in my testing, a read-only workload quickly resets the statistics as evidenced by query plans changes which result in severe performance loss.
In my testing, the first few batches of test queries will execute in 20 seconds or less with the data in the buffer pool, but then a batch of queries will start taking 80 seconds or more. An examination of the EXPLAIN plan on one of the queries in the batch shows a query plan change.
Reproduction steps are described in upstream bug report.
Related branches
- Alexey Kopytov (community): Approve
-
Diff: 181 lines (+103/-4)3 files modifiedPercona-Server/mysql-test/r/percona_bug1192354.result (+39/-0)
Percona-Server/mysql-test/t/percona_bug1192354.test (+38/-0)
Percona-Server/sql/sql_show.cc (+26/-4)
- Alexey Kopytov (community): Approve
-
Diff: 181 lines (+103/-4)3 files modifiedPercona-Server/mysql-test/r/percona_bug1192354.result (+39/-0)
Percona-Server/mysql-test/t/percona_bug1192354.test (+38/-0)
Percona-Server/sql/sql_show.cc (+26/-4)
tags: | added: upstream |
In order to set triage, what is the reason for copying a MySQL bug to Percona Server bug db?