Mysql--percona-toolkit Command Line Toolset

Source: Internet
Author: User
Tags mysql version install perl percona

Percona Toolkit is a set of advanced command-line toolsets for managing MySQL and system tasks, mainly including:
1, master and slave status detection and repair
2. Detection of delay from library replication
3, slow query, log analysis
4. detecting MySQL Server Status
5. Detection from logs and tcpdump

1. Installing Perl related modules

Yum Install PERL-DBI

Yum Install Perl-dbd-mysql

Yum Install Perl-time-hires

Yum Install Perl-io-socket-ssl

2, download and install per-dependency package, Percona Toolkit Package

wget http://pkgs.repoforge.org/perl-TermReadKey/perl-TermReadKey-2.30-1.el3.rf.x86_64.rpm

RPM-IVH perl-termreadkey-2.30-1.el3.rf.x86_64.rpm

wget https://www.percona.com/downloads/percona-toolkit/2.2.14/RPM/percona-toolkit-2.2.14-1.noarch.rpm  rpm -ivh percona-toolkit-2.2.14-1.noarch.rpm  

Use
Server Summary
Pt-summary

Server disk Monitoring
Pt-diskstats

MySQL Service Status summary
Pt-mysql-summary----User=root--password=root

Slow Query Log Analysis statistics
Pt-query-digest/data/logs/mysql/mysql-slow.log

Table Sync Tool, like the Mk-tables-sync function, is there a slight difference in usage?, –print results more detailed
Pt-table-sync--execute--print--no-check-slave--database=world h= ' 127.0.0.1 '--user=root--password=123456 h= ' 192.168.0.212 '--user=root--password=123456

Master-Slave status monitoring, provided to it a MySQL server IP user name password, you can analyze the entire master-slave architecture of each server information, including but not limited to MySQL version, IP address, server Id,mysql service startup time, role (master/slave), Slave Status (lag behind the primary server for how many seconds, there are no errors, slave is not running).

[Email protected] ~]# pt-slave-find--host=localhost--user=rhce6--password=rhce6

localhost

Version 5.5.23-log

Server ID 1

Uptime 05:16:10 (started 2012-08-08t09:32:03)

Replication is not a slave, have 1 slaves connected, is not read_only

Filters

Binary Logging STATEMENT

Slave status

Slave Mode STRICT

Auto-increment increment 1, offset 1

InnoDB version 1.1.8

+-192.168.0.168

Version 5.5.23-log

Server ID 10

Uptime 38:19 (started 2012-08-08t14:09:54)

Replication is a slave, have 0 slaves connected, is not read_only

Filters

Binary Logging STATEMENT

Slave status 0 seconds behind, running, no errors

Slave Mode STRICT

Auto-increment increment 1, offset 1

InnoDB version 1.1.8

MySQL Deadlock monitoring
Pt-deadlock-logger h= ' 127.0.0.1 '--user=root--password=123456

Primary key conflict Check
Pt-duplicate-key-checker--database=world h= ' 127.0.0.1 '--user=root--password=123456

Monitoring replication latency from the library??? # # #经过测试? Running this command causes an exception to be dropped from the SQL thread on the library
Pt-slave-delay--host 192.168.0.206--user=root--password=123456

Mysql--percona-toolkit Command Line Toolset

Related Article

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.