mysqltest – program to run test cases mysqltest_embedded – program to run embedded test cases Synopsis mysqltest [options] [db_name] mysqltest_embedded [options] [db_name]DescriptionThe mysqltest program runs a test case against a MariaDB server and optionally compares the output with a result file. This program reads input written in a special test language. Typically, you invoke mysqltest…
mysqlslap – load emulation client Synopsis mysqlslap [options]Descriptionmysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each stage. It works as if multiple clients are accessing the server. Invoke mysqlslap like this: shell> mysqlslap [options] Some options such as –create or –query enable you…
mysqlshow – display database, table, and column information Synopsis mysqlshow [options] [db_name [tbl_name [col_name]]]DescriptionThe mysqlshow client can be used to quickly see which databases exist, their tables, or a table’s columns or indexes. mysqlshow provides a command-line interface to several SQL SHOW statements. See Section 13.7.7, “SHOW Statements”. The same information can be obtained by…
mysqlserverinfo – Display Common Diagnostic Information from a Server Synopsis mysqlserverinfo [options] db1 [:db2] …DescriptionThis utility displays critical information about a server for use in diagnosing problems. The information displayed includes the following: • Server connection information• Server version number• Data directory path name• Base directory path name• Plugin directory path name• Configuration file location…
mysqlrplshow – Show Slaves for Master Server Synopsis mysqlrplshow [options]DescriptionThis utility shows the replication slaves for a master. It prints a graph of the master and its slaves labeling each with the host name and port number. You must specify the –discover-slaves-login option to provide the user name and password to discover any slaves in…
mysqlrplcheck – Check Replication Prerequisitiess Synopsis mysqlrplcheck [options]DescriptionThis utility checks the prerequisites for replication between a master and a slave. These checks (called tests) are designed to ensure a healthy replication setup. The utility performs the following tests: 1. Is the binary log enabled on the master?2. Are there binary logging exceptions (such as *_do_db…
mysqlrpladmin – Administration utility for MySQL replication Synopsis mysqlrpladmin [options]DescriptionThis utility permits users to perform administrative actions on a replication topology consisting of a master and its slaves. The utility is designed to make it easy to recover from planned maintenance of the master or from an event that takes the master offline unexpectedly. The…
mysqlreport – Makes a friendly report of important MySQL status values Syntaxmysqlreport [options] Descriptionmysqlreport makes a friendly report of important MySQL status values. Actually, it makes a friendly report of nearly every status value from SHOW STATUS. Unlike SHOW STATUS which simply dumps over 100 values to screen in one long list, mysqlreport interprets and…
mysqlreplicate – Set Up and Start Replication Between Two Servers Synopsis mysqlreplicate [options]DescriptionThis utility permits an administrator to start replication from one server (the master) to another (the slave). The user provides login information for the slave and connection information for connecting to the master. It is also possible to specify a database to be…
mysqlcheck – a table maintenance program Synopsis mysqlcheck [options] [db_name [tbl_name …]]DescriptionThe mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes tables. Each table is locked and therefore unavailable to other sessions while it is being processed, although for check operations, the table is locked with a READ lock only (see Section 13.3.6,…
mysqlpump – a database backup program Synopsis mysqlpump [options] [db_name [tbl_name …]]Description• mysqlpump Invocation Syntax• mysqlpump Option Summary• mysqlpump Option Descriptions• mysqlpump Object Selection• mysqlpump Parallel Processing• mysqlpump Restrictions The mysqlpump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table…
mysqlprocgrep – Search Server Process Lists Synopsis mysqlprocgrep [options]DescriptionThis utility scans the process lists for the servers specified using instances of the –server option and selects those that match the conditions specified using the –age and –match-xxx options. For a process to match, all conditions given must match. The utility then either prints the selected…
mysqlcheck – a table maintenance program Synopsis mysqlcheck [options] [db_name [tbl_name …]]DescriptionThe mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes tables. Each table is locked and therefore unavailable to other sessions while it is being processed, although for check operations, the table is locked with a READ lock only (see Section 13.3.6,…
mysqlmetagrep – Search Database Object Definitions Synopsis mysqlmetagrep [options] [pattern | server] …DescriptionThis utility searches for objects matching a given pattern on all the servers specified using instances of the –server option. It produces output that displays the matching objects. By default, the first nonoption argument is taken to be the pattern unless the –pattern…
mysqlman – default man page for mysql DescriptionCertain executables distributed with the MySQL database management system do not have specific man pages. See AlsoIn most cases, you can run the executable from the command line with a "–help" argument to display a brief summary of the executable’s arguments and function. For more information about MySQL,…
mysqlindexcheck – Identify Potentially Redundant Table Indexes Synopsis mysqlindexcheck [options] db[:table] …DescriptionThis utility reads the indexes for one or more tables and identifies duplicate and potentially redundant indexes. To check all tables in a database, specify only the database name. To check a specific table, name the table in db.table format. It is possible to…
mysqlimport – a data import program Synopsis mysqlimport [options] db_nametextfile1 …DescriptionThe mysqlimport client provides a command-line interface to the LOAD DATA SQL statement. Most options to mysqlimport correspond directly to clauses of LOAD DATA syntax. See Section 13.2.7, “LOAD DATA Statement”. Invoke mysqlimport like this: shell> mysqlimport [options] db_nametextfile1 [textfile2 …] For each text file…
mysqlhotcopy – a database backup program Synopsis mysqlhotcopy argumentsDescriptionmysqlhotcopy is a Perl script that was originally written and contributed by Tim Bunce. It uses FLUSH TABLES, LOCK TABLES, and cp or scp to make a database backup. It is a fast way to make a backup of the database or single tables, but it can…
mysqlfailover – Automatic replication failover Synopsis mysqlfailover [options]DescriptionThis utility permits users to perform replication health monitoring and automatic failover on a replication topology consisting of a master and its slaves. The utility is designed to run interactively or continuously refreshing the health information at periodic intervals. Its primary mission is to monitor the master for…
mysqldumpslow – Summarize slow query log files Synopsis mysqldumpslow [options] [log_file …]DescriptionThe MySQL slow query log contains information about queries that take a long time to execute (see Section 5.4.5, “The Slow Query Log”). mysqldumpslow parses MySQL slow query log files and summarizes their contents. Normally, mysqldumpslow groups queries that are similar except for the…