Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0(EOL)
-
None
Description
On some of my systems, the ibd file of mysql.gtid_slave_pos is very big. Those are running with parallel replication with many threads. It is actually the system I am talking about in the following:
file="my_mysql_data_dir/mysql/gtid_slave_pos.ibd"
|
list="...list of hosts..."
|
|
|
$ for s in $list; do echo "md5sum <<< $s; ssh $s stat -c %s $file"; done | parallel -j 10 -k
|
34efe8b2ba3316f8d6d93509bed3c5c2 *-
|
490733568
|
|
|
77399f822496dce163baea27d9592eac *-
|
247463936
|
|
|
820a25cfb0957d9643be3aed7f5317fa *-
|
310378496
|
|
|
37e53cd9b5a613cee05f50a746432960 *-
|
457179136
|
|
|
df3210a24fc65c149a8480740f97e689 *-
|
1027604480
|
|
|
d756e66aded1957ebbc85d2b9f2589b7 *-
|
385875968
|
|
|
7cbd541c85e02c12db63ec33bcc2b8e1 *-
|
322961408
|
|
|
ec93fff8ac68ad85ed92100decd081f8 *-
|
1073741824
|
|
|
2a291ed23819cf8555048505383bd055 *-
|
2969567232
|
|
|
12c35669ffedaff33159ac8488019bf8 *-
|
260046848
|
|
|
12505185df893d2072b4f642e9f719b4 *-
|
21210595328
|
|
|
76bc0389781bd2421d472c513f7ae476 *-
|
2084569088
|
|
|
9f0966e9107f05083902ad7afdd6f5ba *-
|
998244352
|
|
|
1492e8ac62c10d1fcf66485257c7ac63 *-
|
998244352
|
|
|
dc4ba45e21d05d115bfdd6b97c6bfd45 *-
|
272629760
|
|
|
18cb15f21feb0944e449a741cbe1c9be *-
|
234881024
|
|
|
85183b178739ba2f09d97138351d7105 *-
|
251658240
|
|
|
b337f58234dd325df87a0249f7fd748a *-
|
998244352
|
|
|
dab32b913d40aa9b5a638876238a9294 *-
|
3099590656
|
|
|
ebf8be428023bb69c833dc8be197e8ee *-
|
239075328
|
|
|
5faf2f569c71a040b735445dd651ab47 *-
|
876609536
|
Thanks in advance for looking into that,
JFG