Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-2511

LP #1733006: User statistics: track USE/FORCE/IGNORE INDEX

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: On Hold
    • Priority: Low
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Federico last update 11-12-2017 14:49:02

      If a non-existing index is mentioned in a USE/FORCE/IGNORE INDEX clause, the query will fail with an error. This makes extremely dangerous to drop an index, even if we know that it is duplicate, or has a low cardinality. Even for a consultant it is dangerous to suggest to drop an index.

      Please consider adding new columns in INDEX_STATISTICS table, which count how many times the index has been explicitally USEd, FORCEd or IGNOREd.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                1 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: