mariadb-index-checker for MariaDB Tools

Overview

The mariadb-index-checker utility.

mariadb-index-checker Options for MariaDB Tools

Option

Argument

Description

--all-structs

Compare indexes with different structs (BTREE, HASH, etc)

--ask-pass

Prompt for a password when connecting to MariaDB

--charset (-A)

string

Default character set

--clustered

PK columns appended to secondary key is duplicate ( default yes). Disable using: --noclustered

--config

string

Read this comma-separated list of config files; if specified, this must be the first option on the command line

--databases (-d)

string

Check only this comma-separated list of databases

--defaults-file (-F)

string

Only read mysql options from the given file

--engines (-e)

string

Check only tables whose storage engine is in this comma- separated list

--help

Show help and exit

--host (-h)

string

Connect to host

--ignore-databases

string

Ignore this comma-separated list of databases

--ignore-engines

string

Ignore this comma-separated list of storage engines

--ignore-order

Ignore index order so KEY(a,b) duplicates KEY(b,a)

--ignore-tables

string

Ignore this comma-separated list of tables

--key-types

string

Check for duplicate f=foreign keys, k=keys or fk=both ( default fk)

--password (-p)

string

Password to use when connecting

--pid

string

Create the given PID file

--port (-P)

integer

Port number to use for connection

--set-vars

string

Set the MariaDB variables in this comma-separated list of variable=value pairs

--socket (-S)

string

Socket file to use for connection

--sql

Print DROP KEY statement for each duplicate key ( default yes). Disable using: --nosql

--summary

Print summary of indexes at end of output (default yes). Disable using: --nosummary

--tables (-t)

string

Check only this comma-separated list of tables

--user (-u)

string

User for login if not current user

--verbose (-v)

Output all keys and/or foreign keys found, not just redundant ones

--version

Show version and exit