mysql database differences in 5.7 with GTID
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Toolkit moved to https://jira.percona.com/projects/PT |
New
|
Low
|
Carlos Salguero |
Bug Description
Update pt-table-checksum to deal with dynamic tables in MySQL 5.7 when using GTID. The tables are likely to contain different values.
Consider automatically excluding the dynamic mysql.gtid_executed table.
For example,
% pt-table-checksum --no-check-
TS ERRORS DIFFS ROWS CHUNKS SKIPPED TIME TABLE
04-30T02:31:59 0 0 1 1 0 0.060 heartbeat.heartbeat
04-30T02:31:59 0 0 0 1 0 0.061 mysql.columns_priv
04-30T02:31:59 0 0 18 1 0 0.059 mysql.db
04-30T02:31:59 0 0 2 1 0 0.057 mysql.engine_cost
04-30T02:31:59 0 0 0 1 0 0.060 mysql.event
04-30T02:31:59 0 0 3 1 0 0.062 mysql.func
04-30T02:32:00 0 1 1 1 0 0.059 mysql.gtid_executed
04-30T02:32:00 0 0 40 1 0 0.057 mysql.help_category
04-30T02:32:00 0 0 671 1 0 0.059 mysql.help_keyword
04-30T02:32:00 0 0 1307 1 0 0.058 mysql.help_relation
04-30T02:32:00 0 0 630 1 0 0.061 mysql.help_topic
04-30T02:32:00 0 0 0 1 0 0.059 mysql.ndb_
04-30T02:32:00 0 0 3 1 0 0.058 mysql.plugin
04-30T02:32:00 0 0 47 1 0 0.060 mysql.proc
04-30T02:32:00 0 0 0 1 0 0.059 mysql.procs_priv
04-30T02:32:00 0 0 6 1 0 0.060 mysql.proxies_priv
04-30T02:32:00 0 0 6 1 0 0.060 mysql.server_cost
04-30T02:32:01 0 0 0 1 0 0.312 mysql.servers
04-30T02:32:01 0 0 1 1 0 0.058 mysql.tables_priv
04-30T02:32:01 0 0 1765 1 0 0.060 mysql.time_zone
04-30T02:32:01 0 0 0 1 0 0.057 mysql.time_
04-30T02:32:01 0 0 1765 1 0 0.061 mysql.time_
04-30T02:32:01 0 0 118426 4 0 0.519 mysql.time_
04-30T02:32:02 0 0 8296 1 0 0.324 mysql.time_
04-30T02:32:02 0 0 25 1 0 0.063 mysql.user
04-30T02:32:02 0 0 6 1 0 0.060 sys.sys_config
% pt-table-checksum --no-check-
Differences on shrill-limit
TABLE CHUNK CNT_DIFF CRC_DIFF CHUNK_INDEX LOWER_BOUNDARY UPPER_BOUNDARY
mysql.gtid_executed 1 0 1
Differences on bold-band
TABLE CHUNK CNT_DIFF CRC_DIFF CHUNK_INDEX LOWER_BOUNDARY UPPER_BOUNDARY
mysql.gtid_executed 1 0 1
Comparing dumps of the two tables
275c275
< INSERT INTO `gtid_executed` VALUES ('7ace11db-
---
> INSERT INTO `gtid_executed` VALUES ('7ace11db-
Changed in percona-toolkit: | |
assignee: | nobody → Carlos Salguero (carlos-salguero) |
Changed in percona-toolkit: | |
importance: | Undecided → Low |
milestone: | none → 2.2.20 |
Changed in percona-toolkit: | |
milestone: | 2.2.20 → 2.2.21 |
Changed in percona-toolkit: | |
milestone: | 2.2.21 → none |
milestone: | none → 3.0.2 |
Changed in percona-toolkit: | |
milestone: | 3.0.2 → none |
pt-table-checksum 2.2.17
mysql Ver 14.14 Distrib 5.7.11-4, for Linux (x86_64) using 6.0
Server version: 5.7.11-4-log Percona Server (GPL), Release 4, Revision 5c940e1
CentOS release 6.7 (Final)