pt hub

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 showprocesslist or MySQL protocol data captured by Tcpdump. The analysis results can be exported to a file, the analysis process is the parameters of the query statement,

Version: Pt-table-checksum 2.1.5, Pt-table-sync 2.1.5 Pt-table-checksum and Pt-table-sync are twins. Pt-table-checksum is used to detect data synchronization between the master and slave tables. Pt-table-sync is used to synchron

Introduction to common killing process parameters of pt-kill and parameters of pt-kill Pt-kill is an excellent tool for kill MySQL connection and is part of percona toolkit, when the maximum number of connections is exceeded due to a large number of idle connections and a problematic SQL statement causes a high mysql load, you must kill some connections. This too

often use some tools provided by percona-toolkit. By the way, I will simply record them. 1. About pt-table-checksum and pt-table-sync? Pt-table-checksum and pt-table-sync are some useful performance diagnostic tools provided by percona for mysql DBAs. In addition, XtraBackup is often used for backup, this physical ba

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 variable fileVI. bash_profileExport path= $PATH:/mysqldata/soft/percona-toolkit-2.2.12/bin Two. Use the Pt-table-checksum command to find inconsistent data The primary concern is diffs, 0 is consistent, 1 is in

TbsourceOfficialWebsite (expired): http://www.tbsource.com/: http://www.ipv6bbs.com/thread-5152-1-1.htmlUse site: ccfbitsProgram Introduction: Tbsource should be regarded as the oldest PT source, on December 1, 2005 released an alpha version, the code stopped the update, it is released under the GPL protocol, can implement PHP database TrackR, butForum function not, PHP script is relatively easy to read, the domestic current Nexus project is also base

Tags: statement replicat specify element test load diff database family technology"Pt-table-checksum"Pt-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 and record them. It then compares the checksum of the main table to determine

MySQL -- pt-osc tool learning, mysql -- pt-osc Tool ##=================================================== ====================== ##Pt-osc workflow:1. Check whether the table has a primary key or a unique index and whether a trigger exists.2. Check the TABLE structure of the modified TABLE, create a temporary TABLE, and execute the alter table statement on the new

A: PT (Private Tracker) download is actually a BT download, but there are two obvious improvements: one is the private small-scale download, the second is to carry out traffic statistics, based on the amount of upload to determine your permissions.When BT downloads, The software will analyze the. torrent seed file to get the tracker address, and then connect to the tracker server, the server returns the IP of the other downloader, the downloader then

Using pt-heartbeat to monitor the replication latency of MySQL, pt-heartbeatmysql Pt-heartbeat During database master-slave replication, whether the replication status and data delay are normal is a critical indicator. How can we monitor it? Pt-heartbeat is a centralized tool developed by PERCONA to monitor replication

Use pt-kill to kill the connection method according to certain rules, pt-killkill Pt-kill is an excellent tool for kill MySQL connection and is part of percona toolkit, when the maximum number of connections is exceeded due to a large number of idle connections and a problematic SQL statement causes a high mysql load, you must kill some connections. This tool is

I. Pt-table-checksum1. Create a new account on both master and slaveGRANT SELECT, PROCESS, SUPER, REPLICATION SLAVE on * * to ' checksum ' @ ' 192.168.1.% ' identified by ' xxx ';2. Our Lord new Percona database3. Give all the permissions of the checksum account to the Percona database ( It is not required, it is already super privilege )GRANT all privileges on ' Percona '. * to ' checksum ' @ ' 192.168.118.126 ' with GRANT OPTION;4. The Lord performs