Percona-XtraDB

innodb_stats_method=nulls_ignore is inaccurate in specific situation

Bug #520823 reported by Yasufumi Kinoshita
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona patches
Won't Fix
Medium
Unassigned
Percona-XtraDB
Won't Fix
High
Unassigned

Bug Description

innodb_stats_method=nulls_ignore is inaccurate for the index which has many null values for its key.
It causes bad effect to the query plan.

Yasufumi Kinoshita (yasufumi-kinoshita)
Changed in percona-xtradb:
status: New → Confirmed
status: Confirmed → In Progress
Changed in percona-patches:
status: New → Confirmed
Changed in percona-xtradb:
importance: Undecided → High
Changed in percona-patches:
importance: Undecided → Medium
Changed in percona-xtradb:
assignee: nobody → Yasufumi Kinoshita (yasufumi-kinoshita)
Revision history for this message
Stewart Smith (stewart) wrote :

All development of XtraDB has moved under the Percona Server project - https://launchpad.net/percona-server - If this bug can be reproduced against current Percona Server, please file this bug against percona-server (you can simply do so by using the "Also affects project" link above).

Thanks,
Stewart Smith
Director of Server Development
Percona.

Changed in percona-xtradb:
status: In Progress → Won't Fix
Changed in percona-patches:
status: Confirmed → Won't Fix
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.