4.2 General Operations

These utilities are those designed to perform general operations such as reporting and searching.

  • mysqldiskusage

    • Show disk usage for databases

    • Generate reports in SQL, CSV, TAB, Grid, Vertical

  • mysqlfrm

    • Reads .frm files, optionally in byte-by-byte diagnostic mode

    • Generates CREATE statements from table definition data

  • mysqlindexcheck

    • Read indexes for one or more tables

    • Check for redundant and duplicate indexes

    • Generate reports in SQL, CSV, TAB, Grid, Vertical

  • mysqlmetagrep

    • Search metadata

    • Regexp, database search

    • Generate SQL statement for search query

  • mysqlprocgrep

    • Search process information

    • Generate SQL statement for search

    • Kill processes that match query

  • mysqluserclone

    • Clone a user account, to the same or different server

    • Show user grants

  • mysqluc

    • Command line client for running MySQL Utilities

    • Allows a persistent connection to a MySQL Server

    • Tab completion for utility names and options

    • Allows calling the commands with shorter names, such as using "serverinfo" instead of mysqlserverinfo

Download this Manual
PDF (US Ltr) - 1.2Mb
PDF (A4) - 1.2Mb
EPUB - 365.4Kb
HTML Download (TGZ) - 287.5Kb
HTML Download (Zip) - 298.6Kb
User Comments
Sign Up Login You must be logged in to post a comment.