pt hub

1. Introduction to ToolsPt-query-digest is a tool for analyzing slow queries for MySQL, which analyzes Binlog, general log, Slowlog, It can also be analyzed using showprocesslist or MySQL protocol data crawled by tcpdump. The analysis results can be exported to a file, the analysis process is the parameters of the query statement, and then the parameterized query after the grouping statistics, statistics of the query execution time, frequency, percentage, etc., can be used to identify problems w

MySQL's online table structure is modified because of inefficient and blocking read and write. has been criticized. As for the principle of alter TABLE, see my previous article. MySQL modifies the large table structure online. After reading, found that the problem is still locked, and for the online update of this block is not very good processing, so can only be understood theoretically, applied to the online library or there is a problem. The latest data is not guaranteed.Today we see the same

JSON (repeated Cr into pT Object Notation) Advantages:1. The data format is relatively simple, easy to read and write, the format is compressed, and the bandwidth usage is small2. It is easy to parse this language. The client-end javascr into pT can simply read JSON data through eval ().3. Supports multiple languages, including actionscr platinum PT, C, C #, Cold

A script for slow query log tracking based on pt-query-digest Percona-toolkit is called MySQL DBA's "Switzerland ***", and its strength is self-evident. The slow query and analysis tool "pt-query-digest" provides many additional attributes, such as flexible filters, compared with the official "mysqldumpslow, database and table-based analysis and sorting. Today, we will share a small script that automaticall

The width of a 10 pt font is required for a webpage today. After thinking about it for a long time, I did not calculate it. I checked the information and finally calculated it. by the way, let's take a look at the pt ps and DPI concepts: PT: in the printed layout, "point" is an absolute unit. It is equal to 1/72 inch. It can be measured by a ruler in a physical

Pt-Osc Test 1. The original table must have the primary key or unique key. The new table `darren`.`_t_user_new` does not have a PRIMARY KEY or a unique index which is required for the DELETE trigger.Please check you have at least one UNIQUE and NOT NULLABLE index. 2. For tables with foreign key constraints, add the -- alter-foreign-keys-method = rebuild_constraints parameter. 3. triggers cannot exist in the original table by default. But the -- preser

Tags: ons slist number partition full table scan nts ges OTA htmFirst, IntroductionPt-query-digest is a tool for analyzing slow queries for MySQL, which analyzes Binlog, general log, Slowlog, It can also be analyzed using showprocesslist or MySQL protocol data crawled by tcpdump. The analysis results can be exported to a file, the analysis process is the parameters of the query statement, and then the parameterized query after the grouping statistics, statistics of the query execution time, freq

Recently played MySQL, found a very good tool, can be the MySQL slow query can be seen, convenient for us to find and analyze the slow inquiry statement, the steps are not many, but on-line detailed tutorials less, not enough detailed, accidentally, estimated that the egg pain a while, hahaPercona Toolkit is an advanced set of command-line tools for managing MySQL and system tasks, mainly including:1. Verify the consistency of the master node and replicated data2. Effective archiving of record l

First, IntroductionPt-query-digest is a tool for analyzing slow queries for MySQL, which analyzes Binlog, general log, Slowlog, It can also be analyzed using showprocesslist or MySQL protocol data crawled by tcpdump. The analysis results can be exported to a file, the analysis process is the parameters of the query statement, and then the parameterized query after the grouping statistics, statistics of the query execution time, frequency, percentage, etc., can be used to identify problems with t

In fact, for a small DBA, sometimes these problems cannot be avoided. Therefore, we need a tool to check whether the master-slave replication is normal and whether an error has occurred. In fact, for a small DBA, sometimes these problems cannot be avoided. Therefore, we need a tool to check whether the master-slave replication is normal and whether an error has occurred. In fact, for a small DBA, sometimes these problems cannot be avoided. Therefore, we need a tool to check whether the mast

Display Unit: pixel, dip, and SP Dip: Device Independent pixels (device independent pixel ). different devices have different display effects, which are related to the hardware of the device. We recommend that you use this function to support WVGA, hvga, and qvga without pixels. Px: pixels (pixels). Different devices have the same display effect. Generally, we use hvga to represent 320x480 pixels, which is usually used. PT: point, a standard unit of l

Dip: Device Independent pixels (device independent pixel ). different devices have different display effects, which are related to the hardware of the device. We recommend that you use this function to support WVGA, hvga, and qvga without pixels. Px: pixels (pixels). Different devices have the same display effect. Generally, we use hvga to represent 320x480 pixels, which is usually used. If PX is used, it will be drawn with the actual pixel. For example, draw a horizontal line with a length of 4

Note: This article from the real production case, thank the Netizen small dolphin to provide, I have to reproduce the fault check.SceneIn order to tidy up the line of independent table space fragmentation, so the use of Pt-online-schema-change in the slave from the Library, the purpose is to avoid affecting the main Library CPU, maintain a master-slave switchover, and then shrink the table space fragmentation on the main library. Slave commands execu

The width of a 10 pt font is required for a webpage today. After thinking about it for a long time, I did not calculate it. I checked the information and finally calculated it. by the way, let's take a look at the pt ps and DPI concepts: PT: in the printed layout, "point" is an absolute unit. It is equal to 1/72 inch. It can be measured by a ruler in a physica

PX,DP,SP,PT analysis and conversion of common unit of measurement in New ui---Reprint Please indicate source: Coder-pig, welcome reprint, do not use for commercial use!Piglet Android Development Exchange Group has been established, welcome everyone to join, both novice, rookie, Big God can, piglet a person'sStrength is limited after all, the writing out of things will certainly have a lot of flaws, welcome to point out, brainstorm, let the pig's blogM

HTML Font Size setting unit pt differs from PX Font size of the set units, commonly used in 2 kinds: px, pt.Basic concepts:px:pixel, pixel, the smallest unit displayed on the screen, for web design, intuitive and convenient;PT:Point, a standard unit of length, 1pt=1/72 inch, for printing, very simple to use;em: that is,%, in CSS, 1em=100%, is a ratio that combines CSS inheritance relationships with flexibility.PPI (DPI): Pixel (dot) per inch, th

css px,pt,em, REM, percent difference and usage px that is, the average domestic website uses more , The default size is 16px; PT Printing Industry common units em relative units, relative units of parent element properties rem The advantages of combining relative positioning and absolute positioning, relative to the root element html html size is ok conversi

, thread cache and so on to enhance the IO, we are relatively easy to get his memory, hit rate, the number of files, but it is not intuitive to know exactly how much data it read and write to the physical IO device.Ioprofile is a tool that provides intuitive quantitative data to describe the real-world read and write volume of a process to an IO device.Because the implementation is injected into the thread using Strace, sudo is required at run time, as in this way:sudo./

Tags: completely database getting server wholeIf you ' re just completely itching to start using the This tool, here's what you need:1, a MySQL database to store query analysis data in.2, Pt-query-digest. You could as well just get the whole Percona Toolkit when you ' re at it:)3, a slow query log from a MySQL server (see the slow query log for info on getting one)4, a webserver with PHPThe first first[Email protected] anemometer]# wget percona.com/ge

Cisco PT Simulation Lab (3) vswitch Telnet remote login configuration, ciscotelnet Cisco PT Simulation Lab (3) vswitch Telnet Remote logon Configuration Objective: To master the vty line configuration of a vswitch and implement remote management of the vswitch through telnet. Tutorial Background: After you configure the switch for the first time in the equipment room, you can remotely manage the switch in t