O'Reilly logo

MySQL 8 Cookbook by Karthik Appigatla

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

mysqlindexcheck

Note that mysqlindexcheck ignores descending indexes. For example, full_name_desc (first_name descending and last_name) is treated as a duplicate index of full_name (first_name and last_name):

shell> mysqlindexcheck --server=<user>:<pass>@localhost:3306 employees --show-drops WARNING: Using a password on the command line interface can be insecure.# Source on localhost: ... connected.# The following indexes are duplicates or redundant for table employees.employees:#CREATE INDEX `full_name_desc` ON `employees`.`employees` (`first_name`, `last_name`) USING BTREE#     may be redundant or duplicate of:CREATE INDEX `full_name` ON `employees`.`employees` (`first_name`, `last_name`) USING BTREE#CREATE INDEX `first_name` ON `employees`.`employees` ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required