In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.