Pt-duplicate-key-checkerThe function is to find duplicate indexes and foreign keys from the MySQL table, the tool lists the duplicate indexes and foreign keys, and generates a statement to delete the duplicate index, which is very convenient find
Let's take a look at the basic features of MySQL:
1. Internal Components and portability
Written using C and C + +
Tested with a number of different compilers
Able to work on many different platforms. See 2.1.1 "MySQL Supported
today's plan to install the experience: Percona-toolkit_3.0.4-1.jessie_amd64.deb to detect MySQL indexes and slow query analysisbut encountered the lack of: libmysqlclient18 and Libdbd-mysql-perl
Usage of mysqltoolkit [memo] bitsCN.com
Mysql toolkit is a small plug-in used to monitor and analyze databases. it is usually used to call perl to analyze and compare the current environment and database. it is worth learning.
Analysis of index transformation in MYSQL management
As a mysql dba, you need to regularly check the indexing status of the server, especially when you arrive at a new environment and start to take over some database maintenance work, you need to
Here is the MHA from boot, to failover's complete manager.log, and all of the MySQL General.log in the cluster. We can learn more about the workings of MHA through these logs. There is a lot of help in using good MHA.The architecture is as
More comprehensive MySQL optimization reference (next) 8 replies. This article has compiled some general MySQL optimization methods, a simple summary share, designed to help those who do not have full-time MySQL DBA to do basic optimization work, as
Introduction of Percona-toolkit Tools
The Percona-toolkit, "PT Tool", is a collection of advanced command-line tools for performing various MySQL and system tasks that are complex and cumbersome to perform by hand, including:
Check the consistency
Background Description: Friends Unit OA system soon completed upgrade big transformation, back end with the MySQL storage data, on-line ran for a month, complaining about the phone began to dozen, not here, is not open, there is no response, some
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.