Make it possible to disable indexes

Bug #697801 reported by Peter Zaitsev
14
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.5
Won't Fix
Wishlist
Unassigned
5.6
Won't Fix
Wishlist
Unassigned
5.7
Triaged
Wishlist
Unassigned
8.0
Fix Committed
Wishlist
Unassigned

Bug Description

Make it possible to disable index usage by optimizer. This is to be used to validate if index can be dropped or not.

In many cases it is hard to ensure index is not used and if it is dropped wrongly adding the index may be very expensive.

This is especially issue with XtraDB/Innodb plugin which can drop index instantly so it can be done with no downtime, adding indexes though require a lot

Stewart Smith (stewart)
Changed in percona-server:
importance: Undecided → Wishlist
status: New → Confirmed
Stewart Smith (stewart)
Changed in percona-server:
status: Confirmed → Triaged
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2339

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

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