mysqlindexcheck(1) - Linux man page
Name
MySQL - manual page for MySQL Utilities mysqlindexcheck version 1.2.1 - MySQL Workbench Distribution
5.2.47
Synopsis
mysqlindexcheck --server=user:pass@host:port:socket db1.table1 db2 db3.table2
Description
mysqlindexcheck - check for duplicate or redundant indexes
Options
- --version
- show program's version number and exit
- --help
- display a help message and exit
- --server=SERVER
- connection information for the server in the form: <user>[:<password>]@<host>[:<port>][:<socket>] or
<login-path>[:<port>][:<socket>].
- -d, --show-drops
- display DROP statements for dropping indexes
- -i, --show-indexes
- display indexes for each table
- -s, --skip
- skip tables that do not exist
- -f FORMAT, --format=FORMAT
- display the list of indexes per table in either sql, grid (default), tab, csv, or vertical format
- --stats
- show index performance statistics
- --best=BEST
- limit index statistics to the best N indexes
- --worst=WORST
- limit index statistics to the worst N indexes
- -v, --verbose
- control how much information is displayed. e.g., -v = verbose, -vv = more verbose, -vvv = debug
Copyright
Copyright © 2010, 2013 Oracle and/or its affiliates. All rights reserved. This is a release of
dual licensed MySQL Utilities. For the avoidance of doubt, this particular copy of the software is released under the version 2 of the GNU General Public
License. MySQL Utilities is brought to you by Oracle.