Shulou(Shulou.com)05/31 Report--

This article will explain in detail what is the use of the Utilities tool in MySQL. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

MySQL Utilities is an official MySQL management tool, which is developed with python and has all kinds of functions. There are mainly five levels of tools: database level (replication, comparison, difference, export, import), audit log level, server level (instance cloning, instance information), system level (disk usage, redundant index, search metadata, process), high availability level (master-slave replication, failover, master-slave synchronization).

There are the following commands, which are described as follows:

Mysqlauditadmin-Allows users to perform maintenance action on the audit log

Mysqlauditgrep-Allows users to search the current or an archived audit log

Mysqlbinlogmove-Binary log relocate utility

Mysqlbinlogpurge-Binary logpurge utility

Mysqlbinlogrotate-Binary logrotate utility

Mysqldbcompare-Compare Two Databases and Identify Differences

Mysqldbcopy-Copy Database Objects Between Servers

Mysqldbexport-Export Object Definitions or Data from a Database

Mysqldbimport-Import Object Definitions or Data into a Database

Mysqldiff-Identify Differences Among Database Objects

Mysqldiskusage-Show Database Disk Usage

Mysqlfailover-Automatic replication health monitoring and failover

Mysqlfrm-File reader for .frm files.

Mysqlgrants-Display grants by object

Mysqlindexcheck-Identify Potentially Redundant Table Indexes

Mysqlmetagrep-Search Database Object Definitions

Mysqlprocgrep-Search Server Process Lists

Mysqlreplicate-Set Up and Start Replication Between Two Servers

Mysqlrplms-Set Up and Start Replication Among a Slave and Multiple Masters

Mysqlrpladmin-Administration utility for MySQL replication

Mysqlrplcheck-Check Replication Prerequisites

Mysqlrplshow-Show Slaves for Master Server

Mysqlrplsync-Replication synchronization checker

Mysqlserverclone-Clone Existing Server to Create New Server

Mysqlserverinfo-Display Common Diagnostic Information from a Server

Mysqlslavetrx-Slave transaction skip utility

Mysqluc-Command line client for running MySQL Utilities

Mysqluserclone-Clone Existing User to Create New User

This is the end of this article on "what is the use of Utilities tools in MySQL". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it out for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.