# Executed\_Gtid\_Set
**URL:** https://forums.percona.com/t/executed-gtid-set/4781
**Category:** Percona Server for MySQL 5.6
**Created:** [March 15, 2016, 9:18am UTC](https://forums.percona.com/t/executed-gtid-set/4781 "2016-03-15T09:18:04Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@EmergeBrandon](https://forums.percona.com/u/EmergeBrandon)
#### Post date: [March 15, 2016, 9:18am UTC](https://forums.percona.com/t/executed-gtid-set/4781/1 "2016-03-15T09:18:04Z")
Hello,
I have a 3 node galera cluster(multi master) running on:
Server version: 5.6.24-72.2-56-log Percona XtraDB Cluster (GPL), Release rel72.2, Revision 1, WSREP version 25.11, wsrep\_25.11
My slave hangs off node1 for replication.
Working on getting my slave back online and in replication, I ran the slave status and noticed a lot of GTID’s…
Why do I have so many GTID’s? any way to fix this?
Retrieved\_Gtid\_Set: 06fb5658-2486-ee1a-5161-953c56ca7bce:165832513-175386408
Executed\_Gtid\_Set: 04d7e815-4ae6-11e5-9823-f0921c053a58:1-1757,
06fb5658-2486-ee1a-5161-953c56ca7bce:1-165832512,
1e07439c-b527-ee1a-4b83-848aa25c4186:1-26751103,
2a2d73a5-b708-ee1a-5136-1959e7687657:1-5148177,
33ab8564-b8da-ee1a-4fe7-f0972d9df64e:1-4970416,
4269889c-dc59-11e5-a71b-f0921c051a08:1-2,
46d537bb-5e47-ee1a-4c83-2832623a6cf2:1-560922031,
4f5db2a5-ad7e-ee1a-60bf-20c5ae2584af:1-2017813,
4f619bf4-9fd9-ee1a-77fd-0884a0db9e85:1-26577,
5d59cde8-48fe-11e5-b325-f0921c051a08:1-5,
5df96a91-ad7f-ee1a-5cf1-418e928bedc9:1-5524,
63142e8b-57ba-11e5-9e0f-f0921c053a58:1-7693,
8a787515-6130-ee1a-47c9-1867dc7e88a3:1-23723494,
96512664-4672-11e5-8111-f0921c053a58:1-74,
a3d75afd-bcb6-ee1a-4c59-a4730998eef5:1-1600696,
afa4bd1a-259c-ee1a-6529-79cd9cb9ffca:1-12016218,
b7a2d638-c2b3-11e5-9b86-f0921c053a58:1-4336,
c65bd610-df6d-11e5-be75-f0921c053a50:1-213816,
cfad0778-9fd5-ee1a-6d27-7da8c3d55ff2:1-23490,
d780d0ae-9fd2-ee1a-5060-107a160688f7:1-187069468,
db5b0676-2bc1-ee1a-4b42-b473a4f16db0:1-71047185,
ef1ced5c-6d91-ee1a-5c8d-2183aa126dbe:1-89956800,
f0ec6f66-acf2-ee1a-4ba7-c0b12402f82e:1-36542094
Auto\_Position: 1
1 row in set (0.00 sec)
---
### Author:  [@BlairPage](https://forums.percona.com/u/BlairPage)
#### Post date: [March 15, 2016, 5:07pm UTC](https://forums.percona.com/t/executed-gtid-set/4781/2 "2016-03-15T17:07:33Z")
Hello,
Executed\_Gtid\_Set: is a representation of the set of all transactions that are logged in the binary log. Documentation for this variable here.
[url][MySQL :: MySQL 5.6 Reference Manual :: 17.1.4.5 Global Transaction ID Options and Variables](https://dev.mysql.com/doc/refman/5.6/en/replication-options-gtids.html#sysvar_gtid_executed%5B/url%5D)
Should you proceed to face difficulties with getting your slave back online, please include full output from the following.
SHOW SLAVE STATUS;
SHOW FULL PROCESSLIST;
Could you provide along with this please provide the output for pt-summary and pt-mysql-summary from the percona toolkit.
Thank You,
Blair Page
---
### Author:  [@EmergeBrandon](https://forums.percona.com/u/EmergeBrandon)
#### Post date: [March 16, 2016, 8:20am UTC](https://forums.percona.com/t/executed-gtid-set/4781/3 "2016-03-16T08:20:27Z")
Here is my show slave status:
mysql\> show slave status\G;
\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 1. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*
Slave\_IO\_State: Waiting for master to send event
Master\_Host: 10.0.3.20
Master\_User: cmon
Master\_Port: 3306
Connect\_Retry: 60
Master\_Log\_File: binlog.002755
Read\_Master\_Log\_Pos: 222302173
Relay\_Log\_File: mysqld-relay-bin.000002
Relay\_Log\_Pos: 399
Relay\_Master\_Log\_File: binlog.002697
Slave\_IO\_Running: Yes
Slave\_SQL\_Running: No
Replicate\_Do\_DB:
Replicate\_Ignore\_DB:
Replicate\_Do\_Table:
Replicate\_Ignore\_Table:
Replicate\_Wild\_Do\_Table:
Replicate\_Wild\_Ignore\_Table:
Last\_Errno: 1032
Last\_Error: Could not execute Update\_rows event on table person.user; Can’t find record in ‘user’, Error\_code: 1032; handler error HA\_ERR\_KEY\_NOT\_FOUND; the event’s master log binlog.002697, end\_log\_pos 858821513
Skip\_Counter: 0
Exec\_Master\_Log\_Pos: 858820463
Relay\_Log\_Space: 61695171377
Until\_Condition: None
Until\_Log\_File:
Until\_Log\_Pos: 0
Master\_SSL\_Allowed: No
Master\_SSL\_CA\_File:
Master\_SSL\_CA\_Path:
Master\_SSL\_Cert:
Master\_SSL\_Cipher:
Master\_SSL\_Key:
Seconds\_Behind\_Master: NULL
Master\_SSL\_Verify\_Server\_Cert: No
Last\_IO\_Errno: 0
Last\_IO\_Error:
Last\_SQL\_Errno: 1032
Last\_SQL\_Error: Could not execute Update\_rows event on table person.user; Can’t find record in ‘user’, Error\_code: 1032; handler error HA\_ERR\_KEY\_NOT\_FOUND; the event’s master log binlog.002697, end\_log\_pos 858821513
Replicate\_Ignore\_Server\_Ids:
Master\_Server\_Id: 11
Master\_UUID: b7a2d638-c2b3-11e5-9b86-f0921c053a58
Master\_Info\_File: /mysql/master.info
SQL\_Delay: 0
SQL\_Remaining\_Delay: NULL
Slave\_SQL\_Running\_State:
Master\_Retry\_Count: 86400
Master\_Bind:
Last\_IO\_Error\_Timestamp:
Last\_SQL\_Error\_Timestamp: 160315 10:20:25
Master\_SSL\_Crl:
Master\_SSL\_Crlpath:
Retrieved\_Gtid\_Set: 06fb5658-2486-ee1a-5161-953c56ca7bce:165832513-184761871
Executed\_Gtid\_Set: 04d7e815-4ae6-11e5-9823-f0921c053a58:1-1757,
06fb5658-2486-ee1a-5161-953c56ca7bce:1-165832512,
1e07439c-b527-ee1a-4b83-848aa25c4186:1-26751103,
2a2d73a5-b708-ee1a-5136-1959e7687657:1-5148177,
33ab8564-b8da-ee1a-4fe7-f0972d9df64e:1-4970416,
4269889c-dc59-11e5-a71b-f0921c051a08:1-2,
46d537bb-5e47-ee1a-4c83-2832623a6cf2:1-560922031,
4f5db2a5-ad7e-ee1a-60bf-20c5ae2584af:1-2017813,
4f619bf4-9fd9-ee1a-77fd-0884a0db9e85:1-26577,
5d59cde8-48fe-11e5-b325-f0921c051a08:1-5,
5df96a91-ad7f-ee1a-5cf1-418e928bedc9:1-5524,
63142e8b-57ba-11e5-9e0f-f0921c053a58:1-7693,
8a787515-6130-ee1a-47c9-1867dc7e88a3:1-23723494,
96512664-4672-11e5-8111-f0921c053a58:1-74,
a3d75afd-bcb6-ee1a-4c59-a4730998eef5:1-1600696,
afa4bd1a-259c-ee1a-6529-79cd9cb9ffca:1-12016218,
b7a2d638-c2b3-11e5-9b86-f0921c053a58:1-4338,
c65bd610-df6d-11e5-be75-f0921c053a50:1-213816,
cfad0778-9fd5-ee1a-6d27-7da8c3d55ff2:1-23490,
d780d0ae-9fd2-ee1a-5060-107a160688f7:1-187069468,
db5b0676-2bc1-ee1a-4b42-b473a4f16db0:1-71047185,
ef1ced5c-6d91-ee1a-5c8d-2183aa126dbe:1-89956800,
f0ec6f66-acf2-ee1a-4ba7-c0b12402f82e:1-36542094
Auto\_Position: 1
1 row in set (0.00 sec)
ERROR:
No query specified
Full process list:
mysql\> show full processlist;
±-----±------------±----------------±-------------------±--------±------±---------------------------------±----------------------±----------±--------------+
| Id | User | Host | db | Command | Time | State | Info | Rows\_sent | Rows\_examined |
±-----±------------±----------------±-------------------±--------±------±---------------------------------±----------------------±----------±--------------+
| 1 | cmon | 10.0.1.25:40838 | information\_schema | Sleep | 0 | | NULL | 414 | 414 |
| 2 | cmon | 10.0.1.25:40839 | websportal | Sleep | 2 | | NULL | 0 | 3 |
| 4 | system user | | NULL | Connect | 82707 | Waiting for master to send event | NULL | 0 | 0 |
| 1669 | root | localhost | NULL | Query | 0 | init | show full processlist | 0 | 0 |
±-----±------------±----------------±-------------------±--------±------±---------------------------------±----------------------±----------±--------------+
4 rows in set (0.00 sec)
---
### Author:  [@EmergeBrandon](https://forums.percona.com/u/EmergeBrandon)
#### Post date: [March 16, 2016, 8:22am UTC](https://forums.percona.com/t/executed-gtid-set/4781/4 "2016-03-16T08:22:40Z")
# pt-summary
# Percona Toolkit System Summary Report
# Network Config
Controller | Broadcom Corporation NetXtreme BCM5719 Gigabit Ethernet PCIe (rev 01)
Controller | Broadcom Corporation NetXtreme BCM5719 Gigabit Ethernet PCIe (rev 01)
Controller | Broadcom Corporation NetXtreme BCM5719 Gigabit Ethernet PCIe (rev 01)
Controller | Broadcom Corporation NetXtreme BCM5719 Gigabit Ethernet PCIe (rev 01)
Controller | Broadcom Corporation NetXtreme II BCM57810 10 Gigabit Ethernet (rev 10)
Controller | Broadcom Corporation NetXtreme II BCM57810 10 Gigabit Ethernet (rev 10)
FIN Timeout | 60
Port Range | 65000
# Interface Statistics
interface rx\_bytes rx\_packets rx\_errors tx\_bytes tx\_packets tx\_errors
========= ========= ========== ========== ========== ========== ==========
lo 225000000000 400000000 0 225000000000 400000000 0
eth0 4500000000000 6000000000 150 600000000000000 400000000000 0
eth1 90000000000000 125000000000 15000 600000000000000 400000000000 0
eth2 0 0 0 0 0 0
eth3 0 0 0 0 0 0
eth4 0 0 0 0 0 0
eth5 0 0 0 0 0 0
bond0 90000000000000 125000000000 15000 1000000000000000 800000000000 0
# Network Devices
Device Speed Duplex
========= ========= =========
bond0 20000Mb/s Full
eth0 10000Mb/s Full
eth1 10000Mb/s Full
eth2 Unknown! Unknown!
eth3 Unknown! Unknown!
eth4 Unknown! Unknown!
eth5 Unknown! Unknown!
# Network Connections
Connections from remote IP addresses
10.0.1.20 100
10.0.1.25 10
10.0.3.20 1
10.0.4.4 2
10.0.4.5 1
10.0.254.77 1
Connections to local IP addresses
10.0.3.23 125
Connections to top 10 local ports
10050 100
22 10
57802 1
65531 1
65532 1
65534 1
States of connections
ESTABLISHED 15
LISTEN 4
TIME\_WAIT 100
# Top Processes
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1646 root 20 0 15692 1796 808 R 3.8 0.0 0:00.03 top
6216 mysql 20 0 155g 11g 7720 S 3.8 4.4 40:27.73 mysqld
47847 zabbix 20 0 79180 1192 676 S 1.9 0.0 111:08.93 zabbix\_agentd
1 root 20 0 19356 716 472 S 0.0 0.0 0:17.88 init
2 root 20 0 0 0 0 S 0.0 0.0 0:00.96 kthreadd
3 root RT 0 0 0 0 S 0.0 0.0 66:04.28 migration/0
4 root 20 0 0 0 0 S 0.0 0.0 5:10.33 ksoftirqd/0
5 root RT 0 0 0 0 S 0.0 0.0 0:00.00 stopper/0
6 root RT 0 0 0 0 S 0.0 0.0 0:23.53 watchdog/0
# Notable Processes
PID OOM COMMAND
10325 -17 sshd
36036 -17 udevd
36037 -17 udevd
# Simplified and fuzzy rounded vmstat (wait please)
procs —swap-- -----io---- —system---- --------cpu--------
r b si so bi bo ir cs us sy il wa st
1 0 0 0 600 50 0 0 1 1 98 0 0
0 0 0 0 0 0 4000 3000 0 1 99 0 0
0 0 0 0 0 150 1500 1500 0 0 100 0 0
1 0 0 0 0 25 700 700 0 0 100 0 0
1 0 0 0 0 0 500 600 0 0 100 0 0
# The End
---
### Author:  [@EmergeBrandon](https://forums.percona.com/u/EmergeBrandon)
#### Post date: [March 16, 2016, 8:23am UTC](https://forums.percona.com/t/executed-gtid-set/4781/5 "2016-03-16T08:23:56Z")
pt-mysql-summary
# pt-mysql-summary
# Percona Toolkit MySQL Summary Report
System time | 2016-03-16 13:34:42 UTC (local TZ: CDT -0500)
# Instances
Port Data Directory Nice OOM Socket
===== ========================== ==== === ======
3306 /mysql 0 0 /var/lib/mysql/mysql.sock
# MySQL Executable
Path to executable | /usr/sbin/mysqld
Has symbols | No
# Report On Port 3306
User | root@localhost
Time | 2016-03-16 08:34:42 (CDT)
Hostname | [sql04.XXXXXXXXXXXXX.com](http://sql04.XXXXXXXXXXXXX.com)
Version | 5.6.24-72.2-56-log Percona XtraDB Cluster (GPL), Release rel72.2, Revision 1, WSREP version 25.11, wsrep\_25.11
Built On | Linux x86\_64
Started | 2016-03-15 09:27 (up 0+23:07:13)
Databases | 19
Datadir | /mysql/
Processes | 3 connected, 1 running
Replication | Is a slave, has 0 slaves connected
Pidfile | /mysql/mysqld.pid (exists)
# Processlist
Command COUNT(\*) Working SUM(Time) MAX(Time)
* * *
Connect 1 1 80000 80000
Query 1 1 0 0
Sleep 2 0 0 0
User COUNT(\*) Working SUM(Time) MAX(Time)
* * *
cmon 2 0 0 0
root 1 1 0 0
system user 1 1 80000 80000
Host COUNT(\*) Working SUM(Time) MAX(Time)
* * *
10.0.1.25 2 0 0 0
1 1 80000 80000
localhost 1 1 0 0
db COUNT(\*) Working SUM(Time) MAX(Time)
* * *
information\_schema 1 0 0 0
NULL 2 2 80000 80000
websportal 1 0 0 0
State COUNT(\*) Working SUM(Time) MAX(Time)
* * *
2 0 0 0
init 1 1 0 0
Waiting for master to send eve 1 1 80000 80000
# Status Counters (Wait 10 Seconds)
Variable Per day Per second 11 secs
Aborted\_clients 2
Aborted\_connects 4
Binlog\_snapshot\_position 1500
Binlog\_cache\_use 2
Bytes\_received 60000000000 700000 300000
Bytes\_sent 600000000 6000 9000
Com\_admin\_commands 400000 4 3
Com\_begin 5
Com\_commit 2
Com\_create\_db 700
Com\_create\_table 700
Com\_drop\_db 1500
Com\_drop\_table 700
Com\_insert 700
Com\_reset 1
Com\_select 100000 1 2
Com\_set\_option 25
Com\_show\_binlogs 300
Com\_show\_databases 3
Com\_show\_engine\_status 300
Com\_show\_master\_status 3000
Com\_show\_processlist 17500
Com\_show\_slave\_status 4500
Com\_show\_slave\_status\_nolock 300
Com\_show\_status 90000 1 1
Com\_show\_storage\_engines 300
Com\_show\_tables 1
Com\_show\_variables 3000
Com\_slave\_start 5
Com\_slave\_stop 1
Com\_truncate 20
Com\_update 5
Connections 1750 1
Created\_tmp\_disk\_tables 17500 1
Created\_tmp\_files 6
Created\_tmp\_tables 150000 1 8
Flush\_commands 1
Handler\_commit 1500
Handler\_external\_lock 300000 3 3
Handler\_read\_first 700
Handler\_read\_key 2250
Handler\_read\_next 60
Handler\_read\_rnd 150000 1 1
Handler\_read\_rnd\_next 40000000 450 450
Handler\_rollback 10
Handler\_write 35000000 400 450
Innodb\_background\_log\_sync 90000
Innodb\_buffer\_pool\_bytes\_data 60000000 700
Innodb\_buffer\_pool\_pages\_flushed 30000
Innodb\_buffer\_pool\_pages\_old 250
Innodb\_buffer\_pool\_read\_requests 450000 5
Innodb\_buffer\_pool\_reads 600
Innodb\_buffer\_pool\_write\_requests 150000 1
Innodb\_checkpoint\_max\_age 1750000000 20000
Innodb\_data\_fsyncs 9000
Innodb\_data\_read 9000000 100
Innodb\_data\_reads 600
Innodb\_data\_writes 45000
Innodb\_data\_written 1000000000 12500
Innodb\_dblwr\_pages\_written 30000
Innodb\_dblwr\_writes 1250
Innodb\_history\_list\_length 1750
Innodb\_ibuf\_free\_list 12500
Innodb\_ibuf\_segment\_size 12500
Innodb\_ibuf\_size 1
Innodb\_log\_write\_requests 12500
I
---
### Author:  [@EmergeBrandon](https://forums.percona.com/u/EmergeBrandon)
#### Post date: [March 16, 2016, 8:24am UTC](https://forums.percona.com/t/executed-gtid-set/4781/6 "2016-03-16T08:24:30Z")
nnodb\_log\_writes 8000
Innodb\_lsn\_current 6000000000000 70000000
Innodb\_lsn\_flushed 6000000000000 70000000
Innodb\_lsn\_last\_checkpoint 6000000000000 70000000
Innodb\_master\_thread\_active\_loops 700
Innodb\_master\_thread\_idle\_loops 90000
Innodb\_max\_trx\_id 9000000000 100000
Innodb\_mem\_adaptive\_hash 2500000000 30000
Innodb\_mem\_dictionary 600000000 7000
Innodb\_mem\_total 175000000000 2000000
Innodb\_mutex\_os\_waits 500
Innodb\_mutex\_spin\_rounds 25000
Innodb\_mutex\_spin\_waits 8000
Innodb\_os\_log\_fsyncs 3000
Innodb\_os\_log\_written 10000000 125
Innodb\_pages\_created 3000
Innodb\_pages\_read 600
Innodb\_pages\_written 30000
Innodb\_purge\_trx\_id 9000000000 100000
Innodb\_rows\_inserted 1500
Innodb\_rows\_read 1500
Innodb\_num\_open\_files 15
Innodb\_read\_views\_memory 300
Innodb\_descriptors\_memory 8000
Innodb\_s\_lock\_os\_waits 2000
Innodb\_s\_lock\_spin\_rounds 60000
Innodb\_s\_lock\_spin\_waits 2000
Innodb\_available\_undo\_logs 125
Innodb\_x\_lock\_os\_waits 9
Innodb\_x\_lock\_spin\_rounds 300
Innodb\_x\_lock\_spin\_waits 5
Key\_read\_requests 175
Key\_reads 1
Open\_table\_definitions 70
Opened\_files 125000 1 25
Opened\_table\_definitions 1500
Opened\_tables 800
Queries 600000 6 9
Questions 225000 2 5
Select\_full\_join 100000 1 1
Select\_scan 175000 2 2
Slave\_received\_heartbeats 1
Sort\_rows 150000 1 1
Sort\_scan 35000
Table\_locks\_immediate 150000 1 1
Table\_open\_cache\_hits 150000 1 1
Table\_open\_cache\_misses 800
Threads\_created 4
Uptime 90000 1 1
# Table cache
Size | 1024
Usage | 6%
# Key Percona Server features
Table & Index Stats | Disabled
Multiple I/O Threads | Enabled
Corruption Resilient | Enabled
Durable Replication | Not Supported
Import InnoDB Tables | Not Supported
Fast Server Restarts | Not Supported
Enhanced Logging | Disabled
Replica Perf Logging | Disabled
Response Time Hist. | Not Supported
Smooth Flushing | Not Supported
HandlerSocket NoSQL | Not Supported
Fast Hash UDFs | Unknown
# Percona XtraDB Cluster
wsrep\_on | OFF
# Plugins
InnoDB compression | ACTIVE
# Query cache
query\_cache\_type | OFF
Size | 0.0
Usage | 0%
HitToInsertRatio | 0%
# Schema
Specify --databases or --all-databases to dump and summarize schemas
# Noteworthy Technologies
SSL | No
Explicit LOCK TABLES | No
Delayed Insert | No
XA Transactions | No
NDB Cluster | No
Prepared Statements | No
Prepared statement count | 0# InnoDB #####################################################
Version | 5.6.24-72.2
Buffer Pool Size | 143.1G
Buffer Pool Fill | 0%
Buffer Pool Dirty | 0%
File Per Table | ON
Page Size | 16k
Log File Size | 2 \* 1.0G = 2.0G
Log Buffer Size | 96M
Flush Method | O\_DIRECT
Flush Log At Commit | 2
XA Support | ON
Checksums | ON
Doublewrite | ON
R/W I/O Threads | 4 4
I/O Capacity | 200
Thread Concurrency | 64
Concurrency Tickets | 5000
Commit Concurrency | 0
Txn Isolation Level | REPEATABLE-READ
Adaptive Flushing | ON
Adaptive Checkpoint |
Checkpoint Age | 0
InnoDB Queue | 0 queries inside InnoDB, 0 queries in queue
Oldest Transaction | 0 Seconds
History List Len | 1657
Read Views | 0
Undo Log Entries | 0 transactions, 0 total undo, 0 max undo
Pending I/O Reads | 0 buf pool reads, 0 normal AIO, 0 ibuf AIO, 0 preads
Pending I/O Writes | 0 buf pool (0 LRU, 0 flush list, 0 page); 0 AIO, 0 sync, 0 log IO (0 log, 0 chkp); 0 pwrites
Pending I/O Flushes | 0 buf pool, 0 log
Transaction States | 2xnot started
# MyISAM
Key Cache | 24.0M
Pct Used | 20%
Unflushed | 0%
# Security
Users | 41 users, 0 anon, 2 w/o pw, 2 old pw
Old Passwords | 0
# Binary Logging
Binlogs | 174
Zero-Sized | 0
Total Size | 171.2G
binlog\_format | ROW
expire\_logs\_days | 7
sync\_binlog | 0
server\_id | 101
binlog\_do\_db |
binlog\_ignore\_db |
# Noteworthy Variables
Auto-Inc Incr/Offset | 1/1
default\_storage\_engine | InnoDB
flush\_time | 0
init\_connect |
init\_file |
sql\_mode | NO\_ENGINE\_SUBSTITUTION
join\_buffer\_size | 256k
sort\_buffer\_size | 256k
read\_buffer\_size | 128k
read\_rnd\_buffer\_size | 256k
bulk\_insert\_buffer | 0.00
max\_heap\_table\_size | 64M
tmp\_table\_size | 64M
max\_allowed\_packet | 512M
thread\_stack | 256k
log |
log\_error | /var/log/mysqld.log
log\_warnings | 2
log\_slow\_queries |
log\_queries\_not\_using\_indexes | OFF
log\_slave\_updates | ON
# Configuration File
Config File | /etc/my.cnf
[MYSQLD]
user = mysql
basedir = /usr/
datadir = /mysql
socket = /var/lib/mysql/mysql.sock
pid\_file = mysqld.pid
port = 3306
log\_error = /var/log/mysqld.log
log\_warnings = 2
innodb\_buffer\_pool\_size = 146562M
innodb\_flush\_log\_at\_trx\_commit = 2
innodb\_file\_per\_table = 1
innodb\_data\_file\_path = ibdata1:100M:autoextend
innodb\_read\_io\_threads = 4
innodb\_write\_io\_threads = 4
innodb\_io\_capacity = 200
innodb\_doublewrite = 1
innodb\_log\_file\_size = 1024M
innodb\_log\_buffer\_size = 96M
innodb\_buffer\_pool\_instances = 8
innodb\_log\_files\_in\_group = 2
innodb\_thread\_concurrency = 64
innodb\_file\_format = barracuda
innodb\_flush\_method = O\_DIRECT
innodb\_autoinc\_lock\_mode = 2
innodb\_stats\_on\_metadata = 0
default\_storage\_engine = innodb
gtid\_mode = ON
log\_bin = binlog
log\_slave\_updates = 1
enforce\_gtid\_consistency = ON
expire\_logs\_days = 7
server\_id = 101
binlog\_format = ROW
slave\_net\_timeout = 60
key\_buffer\_size = 24M
tmp\_table\_size = 64M
max\_heap\_table\_size = 64M
max\_allowed\_packet = 512M
skip\_name\_resolve
memlock = 0
sysdate\_is\_now = 1
max\_connections = 200
thread\_cache\_size = 512
query\_cache\_type = 0
query\_cache\_size = 0
table\_open\_cache = 1024
lower\_case\_table\_names = 0
explicit\_defaults\_for\_timestamp = 1
# The End
---
### Author:  [@EmergeBrandon](https://forums.percona.com/u/EmergeBrandon)
#### Post date: [March 16, 2016, 8:26am UTC](https://forums.percona.com/t/executed-gtid-set/4781/7 "2016-03-16T08:26:45Z")
So what I did alread ywas create a backup of one of the masters and then ran this on the slave:
mysql\> reset master; mysql\> source /mysql/dump.sql;
mysql\> CHANGE MASTER TO MASTER\_HOST=“10.0.3.20”, MASTER\_USER=“cmon”, MASTER\_PASSWORD=“cmon”, MASTER\_PORT=3306, MASTER\_AUTO\_POSITION = 1;
mysql\> start slave;
mysql\> show slave status\G;
That starts replication again but it quickly errors out with the error you see above in the slave status. Is this becasue I reset the GTID and now its executing old binlogs that dont need to be executed?
---
### Author:  [@BlairPage](https://forums.percona.com/u/BlairPage)
#### Post date: [March 16, 2016, 11:46am UTC](https://forums.percona.com/t/executed-gtid-set/4781/8 "2016-03-16T11:46:56Z")
Hello,
Could you please the error.log entries around thelocations on both master and slaves.
Please also include pt-summary and pt-mysql-summary from the master server’s as well.
Thank You,
Blair Page
---
### Author:  [@EmergeBrandon](https://forums.percona.com/u/EmergeBrandon)
#### Post date: [March 17, 2016, 7:31am UTC](https://forums.percona.com/t/executed-gtid-set/4781/9 "2016-03-17T07:31:11Z")
I didnt have time to try and fix it. I just rebuilt the slave using this: [url][http://lostdomain.org/2013/01/01/fixing-mysql-slaves-with-percona-xtrabackup/[/url]](http://lostdomain.org/2013/01/01/fixing-mysql-slaves-with-percona-xtrabackup/%5B/url%5D)
It is working correctly now.