First, IntroductionPt-table-checksum is one of the Percona-toolkit series tools that can be used to detect the consistency of the data in the master and from the database. The principle is to run on the Main library, checksum the synchronized tables
First, IntroductionPt-table-checksum is one of the Percona-toolkit series tools that can be used to detect the consistency of the data in the master and from the database. The principle is to run on the main library, checksum the synchronized tables
Use pt-table-sync to restore inconsistent data
In the previous article, pt-table-checksum was used to verify data consistency. This section describes how to verify master-slave data consistency. when determining whether master-slave data is
Pt-table-checksum check and pt-table-sync repair data, checksum Check Tool1. Download the ToolkitLog on to the website and download the corresponding toolkit https://www.percona.com/downloads/percona-toolkit/LATEST/2. Installation(1) yum
Use pt-query-digest to find the SQL statement that is not suitable, pt-query-digestsql
Overview of pt-query-digest1.
Indexes can be executed more quickly, but there must be unreasonable indexes. If you want to find those indexes that are not very
Essays-66 Articles-0 comments-MySQL slow query (ii)-Pt-query-digest detailed slow query log one, Introduction Pt-query-digest is a tool for analyzing MySQL slow query, it can analyze Binlog, Gene RAL Log, Slowlog, can also be analyzed via
Principles and Application of pt-online-schema-change, ptonlinechangeschema
If it is reprinted, please indicate the source of the blog: www.cnblogs.com/xinysu/. The copyright belongs to xiaoradish in the blog garden. Thank you for your
A Download and install Toolshttp://www.percona.com/downloads/percona-toolkit/Currently the latest version is percona-toolkit_2.2.12.tar.gzAfter uploading to the server, unzip and set to environment variablesAdd path to MySQL user's environment
In the application of the MySql master-slave replication architecture, after various exceptions occur in the running DB for a long time, there may be inconsistency between the master and slave databases, and occasionally an error occurs in the same
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.