mysql-transfer2.3 Release

Transfer 2.3 Released,

This release is in addition to upgrading the based version

* Optimize the synchronization performance of index-free tables

* Optimized memory consumption of large transactions in slave mode

*transfer mode-related function changes more

* Fixed a bug where large transactions might fail synchronization in transfer mode

Since two of the company's classmates are using 5.5.31, this version of the change is backport to 5.5.31,

Release Notes

1, based on version Percona 5.5.34, simple usage is to first install the official or PS version 5534, and then replace with transfer mysqld

If you are using the slave mode, the direct substitution does not require modification of parameters.

FAQ: If you start the following error after the direct replacement, "" error message file '/mysql/share/english/errmsg.sys ' had only ... ", then you need to download this file to replace to the error location.

2. New Parameters

transfer_parallel_on
Description: 1) on-multithreaded replication, off-single-threaded default on
2) can only be modified in the Stop slave state

Transfer_mode

Description: 1) on–transfer mode, Off-slave mode default value off

2) read-only parameters

Transfer_slave_*
Description: 1) These four parameter descriptions are described in version 2.2 and are valid only in transfer mode
2) can only be modified in the Stop slave state
3) Transfer_slave_password parameter is displayed as * * * regardless of Set value

============================

Historical version Changes

2.2

New observation Parameters com_ts_*

In the process of pressure measurement, the following commands can be used to observe

Mysqladmin--socket=run/mysql.sock-uroot extended-status--relative--sleep=1 | grep com_ts

Get examples Like

Description:

1) Com_ts_serial_number: Number of serial executions. Represents a transaction that is not using multithreading. Normal should be 0, a non-0 most likely factor is the presence of statement formatted statements, such as DDL, or the Binlog format error of the main library.

2) Com_ts_thread_0: Number of execution transactions for thread number No. 0. The normal should be 0. The most likely factor in the presence of non-0 is a table with no primary key and a unique key in the database.

3) Com_ts_thread_n: The 1th to 15th thread is the normal transfer worker.

is master doing random insertions. It is reasonable to focus on a few threads earlier. It is necessary to pay attention to the previous threads more evenly, the purpose of multi-thread synchronization is achieved.

3. New configuration Parameters Transfer_verbos

Description: The default value for this parameter is off. It says that Com_ts_serial_number normal should be 0. If it is not 0, the statement that causes serial execution can be output in errlog by changing the Transfer_verbos to on.

http://dinglin.iteye.com/blog/1983541