Showing entries 1 to 1
Displaying posts with tag: qwz (reset)
MySQL UC2008 presentation "Grand Tour of the information schema" now online

Yup, the presentation slides as well as the scripts are now available online on the conference website.

The stuff you will find in there:

Diagram of the information schema
Slides for the UC presentation, "Grand Tour of the Information Schema"
script, returns one row for each index (rollup of information_schema.STATISTICS)
script, lists all redundant indexes. Redundancy rules:

  • two indexes with the same columns, type and uniqueness are interchangeable. The one with the largest index name is listed as redundant
  • if there is a unique …
[Read more]
Showing entries 1 to 1