Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Methods of using mysql-utilities to manage toolsets

2025-04-05 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

I don't know if you have any knowledge of previous articles like using the mysql-utilities management toolset, but today I'm going to tell you a little bit about it. If you are interested, let's take a look at the text. I'm sure you'll get something after reading the method of using the mysql-utilities management toolset.

Use of the mysql-utilities management toolset:

For more detailed parameters, refer to the official document: https://dev.mysql.com/doc/mysql-utilities/

Go directly to the MySQL official website to download the rpm package and install it. If you are prompted that the mysql-connector-python version is too low during installation, go to the mysql official website to download the latest package.

The notes are not listed here for features that are not used or are not commonly used in the community version.

Mysqldbcopy clone the entire library

Example: mysqldbcopy-- source=root:'123456'@localhost:3306:/tmp/mysql.sock-- destination=root:'123456'@localhost:3306:/tmp/mysql.sock db:db_clone

Mysqldiskusage statistical table space, volume occupied by various log files

Example: mysqldiskusage-- server=root:'123456'@localhost:3306:/tmp/mysql.sock-- all-v

Mysqlfrm extracts a table structure according to frm in case of failure (excluding foreign key constraints, self-growing sequence numbers)

Example: mysqlfrm-- basedir=/usr/local/mysql / data/hellodb/classes.frm-- port=3310-- user=root # Note that this port is created at random

Mysqlindexcheck finds redundant indexes under a certain database.

Example: mysqlindexcheck-- server=root:'123456'@localhost:3306:/tmp/mysql.sock grafana-f vertical-r-d-- stats

Mysqlprocgrep finds user connections that meet certain criteria

Parameters:

-G,-- basic-regexp,-- regexp

Use 'REGEXP' operator to match pattern. Default is to

Use 'LIKE'.

-Q,-- print-sql,-- sql

Print the statement instead of sending it to the

Server. If a kill option is submitted, a procedure

Will be generated containing the code for executing

The kill.

-- sql-body only print the body of the procedure.

-- kill-connection kill all matching connections.

-- kill-query kill query for all matching processes.

-- print print all matching processes.

-f FORMAT,-- format=FORMAT

Display the output in either grid (default), tab, csv

Or vertical format

-v,-- verbose control how much information is displayed. E.g.,-v =

Verbose,-vv = more verbose,-vvv = debug

-- match-id=PATTERN match the 'ID' column of the PROCESSLIST table.

-- match-user=PATTERN match the 'USER' column of the PROCESSLIST table.

-- match-host=PATTERN match the 'HOST' column of the PROCESSLIST table.

-- match-db=PATTERN match the 'DB' column of the PROCESSLIST table.

-- match-command=PATTERN

Match the 'COMMAND' column of the PROCESSLIST table.

-- match-info=PATTERN match the 'INFO' column of the PROCESSLIST table.

-- match-state=PATTERN

Match the 'STATE' column of the PROCESSLIST table.

-- age=AGE show only processes that have been in the current

State more than a given time.

Example: # user connection in which kill has lost its sleep status and has been in sleep for more than 90 seconds:

Mysqlprocgrep-- server=root:'123456'@localhost:3306:/tmp/mysql.sock-f vertical-- match-command='Sleep'-- age=90s-- kill-connection

Mysqlrpladmin

For this tool, you can refer to Lanchun's blog https://yq.aliyun.com/articles/59234#.

Mysqlserverinfo lists the details of the database (- d displays each default value,-- format=vertical column display)

Example: mysqlserverinfo-- server=root:'123456'@localhost:3306:/tmp/mysql.sock-d-- format=vertical

Mysqlbinlogpurge cleans out-of-date binlog files

Example: mysqlbinlogpurge-server=root:'123456'@localhost:3306:/tmp/mysql.sock

After reading this article on how to use the mysql-utilities management toolset, what do you think? If you want to know more about it, you can continue to follow our industry information section.

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report