pt 2430pc

One pt-osc is used, and the pt-osc is used. 1. Backup before use Mysqldump-uroot-p fission_statistics room_break_history> room_break_history_201704.dump 2.pt-osc run DDL Pt-online-schema-change -- user = 'root' -- host = 'localhost' -- ask-pass -- alter "CHANGE break_type INT (11) not null, CHANGE app_id INT (11) not n

In the work used to also more, in the load data large file, if the file too assembly lead to the problem of master-slave delay, it must be split into many small files, the use of this tool does not require manual cutting files. This tool works only on Unix-like operating systems. Specific can be viewed: http://www.mysqlperformanceblog.com/2008/07/03/how-to-load-large-files-safely-into-innodb-with-load-data-infile/ Execute the following command in a session: Perl

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 inconsistent, you must consider how to fix it. We recommend another important tool of percona-toolkit: pt-table-sync. Percon

First understand the basic concept: PX is to represent pixel, pixels, is the screen to display the most basic points of data, and PT is point, is the printing industry commonly used units, equal to 1/72 inches. In the web design CSS, often used fonts, and font size set units, commonly used in 2 kinds: px, pt. What's the difference between these two?First understand the basic concept: PX is to represent pixe

Tags: style blog http io os using AR strong forConsistency checking of master-slave data is a headache, and occasionally it is frustrating to be inconsistent with the master-slave data from a business complaint, or a few inconsistencies between the data from the library. Usually we only have one way to hot-spare the main library and then replace all the slave libraries. This is not only very costly, but also similar to the solution of a cure, it is very disturbing. So we need the right tools, at

Recently, colleagues have reflected that in the process of monitoring the master-slave replication delay using pt-heartbeat, if master down, Pt-heartbeat will fail to connect, but will try again. It's understandable, after all, from the user's point of view, I hope pt-heartbeat can keep retrying until you reconnect to the database. However, they found that repea

MySQL master-slave replication is an important part of the MySQL high-availability architecture. It can be used to achieve load balancing, high availability and failover, and provide backup. For master-slave replication monitoring, it is not reliable to rely solely on the showslavestatus provided by MySQL itself. Pt-heartbeat is a good choice for master-slave replication latency monitoring. This article describes MySQL master-slave replication is an i

Pt-kill is a good kill MySQL connection tool, is a part of Percona Toolkit, in the due to more idle connections cause more than the maximum number of connections, a problem of SQL causes MySQL load is high, you need to kill some connections, This tool is mainly used for this purpose. 1. Kill by user/usr/bin/pt-kill--busy-time--match-user= "dbUSER1 | DbUSER2,... "--victim all--interval 1--kill--daemonize--p

The PT (Percona Toolkit) tool is a Perl-written toolset developed by Percona, which contains a number of features, such as changing data table structures online, validating master-slave data, checking database status, analyzing slow queries, and so on, which are more cumbersome to do by hand. , easy to operate.InstallationSince it is a tool set for Perl language development, it is of course to install Perl dependent packages first.Yum install-y perl p

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 support! PERCONA provides several tools for managing and maintaining MySQL. It is integrated into PERCONA Toolkit and provides tools such as slow query and analysis, master-slave differential comparison, master-slave

First, the environment1. System environment system IP Host name Description server_id centos6.7 Masterip Master Database: Master 177 centos6.7 Slaveip Slave Database: From 148 2. Software Environment Software version Installation Method Description PT Tool 3.0.4 Compiling the insta

In CSS stylesheets, we often see the length units such as PT, Px,em,ex, in, and so on. What do they mean, what's the difference? I wrote another HTML example to test cm. In a CSS stylesheet, the length units are divided into two types: Relative length units, such as PX, EM, etc. Absolute length units, such as PT,MM, etc. Also talk about the difference between PX and PT