Why is disk IO higher on Debian 10 (MariaDB 10.3) with MySQL replication?

I have a MySQL/MariaDB master-master replication setup that has been working well for several years, the db and tables are not very large (under 200MB for 18 tables). These were on 2 servers running Debian 9 and MariaDB 10.1.44. Now I’ve spun up 2 new servers running Debian 10 and I’m in the process of moving things over to them, but stopped half-way because I’m seeing much higher disk IO usage on the new servers (about 6x more).

So currently, one of the Debian 9 servers and one of the Debian 10 servers are in master-master relationship, with one Debian 9 still being a slave of the master Debian 9 server, and same on the Debian 10 side of things.

I didn’t notice the increased disk IO until after all read/write operations were moved to the Debian 10 master. I was trying to browse tables and saw how slow it was outputting the query results, and it felt like I was on a dial-up connection watching the rows scroll across. It turned out there was some disk contention with the virtual host that was partly responsible, and that problem is now mostly gone.

Now, as you can imagine, none of this is crashing the server with such a “small” set of tables, but as things continue to grow, I’m concerned that there is some underlying mis-configuration which will rear its ugly head at an inopportune time. On the Debian 9 servers, iotop shows steady write IO at around 300-600Kb/s, but on Debian 10 it spikes as high as 6MB/s, and averages around 3MB/s.

Here is the standard config on all 4 servers, everything else is default Debian settings (or MariaDB, as the case may be), full config for Debian 10 at https://pastebin.com/Lk2FR4e3:

max_connections = 1000
query_cache_limit       = 4M
query_cache_size        = 0
query_cache_type        = 0
server-id               = 1 # different for each server
log_bin                 = /var/log/mysql/mysql-bin.log
binlog_do_db            = optimizer
replicate-do-db         = optimizer
report-host             = xyz.example.com #changed obviously
log-slave-updates       = true
innodb_log_file_size    = 32M
innodb_buffer_pool_size = 256M

Here are some other settings I’ve tried that don’t seem to make any difference (checked each one by one):

binlog_annotate_row_events = OFF
binlog_checksum = NONE
binlog_format = STATEMENT
innodb_flush_method = O_DIRECT_NO_FSYNC
innodb_log_checksums = OFF
log_slow_slave_statements = OFF
replicate_annotate_row_events = OFF

I’ve gone through all the settings here that have changed from MariaDB 10.1 to 10.3, and can’t seem to find any that make a difference: https://mariadb.com/kb/en/replication-and-binary-log-system-variables/

I also did a full listing of the server variables and compared the configs on 10.1 to the 10.3 configuration and didn’t find anything obvious. But either I’m missing something, or the problem lies with Debian 10 itself.

Results of SHOW ENGINE INNODB STATUS are here: https://pastebin.com/mJdLQv8k

Now, how about that disk IO, what is it actually doing? I include 3 screenshots here to show what I mean by increased disk IO:
Resource graphs on the Debian 10 master

That is from the Debian 10 master, and you can see where I moved operations back to the Debian 9 server (more on that in a second). Notice the disk IO does go down slightly at that point, but not to the levels that we’ll see on the Debian 9 master. Also note that the public bandwidth chart is pretty much only replication traffic, and that the disk IO far outstrips the replication traffic. The private traffic is all the reads/writes from our application servers.

Resource graphs on Debian 9 master

This is the Debian 9 master server, and you can see where I moved all operations back to this server, the private traffic shoots up, but the write IO hovers around 500kB/s. I didn’t have resource graphs being recorded on the old servers, thus the missing bits on the left.

Debian 10 slave server resource graphs

And lastly, for reference, here is the Debian 10 slave server (that will eventually be half of the master<–>master replication). There are no direct reads/writes on this server, all disk IO is from replication.

Just to see what would happen (as I alluded to above), I reverted all direct read/write operations to the Debian 9 master server. While disk IO did fall somewhat on the Debian 10 server, it did not grow on the Debian 9 server to any noticeable extent.

Also, on the Debian 10 slave server, I did STOP SLAVE once to see what happened, and the disk IO went to almost nothing. Doing the same on the Debian 10 master server barely did not have the same drastic effect, though it’s possible there WAS some change that wasn’t obvious; the disk IO numbers on iostat fluctuate much more wildly on the Debian 10 servers than they do on the Debian 9 servers.

So, what is going on here? How can I figure out why MariaDB is writing so much data to disk apparently and/or how can I stop it?

Thanks in advance!

Socks5 Proxy Service Cheap Socks5

SOCKS Proxy List from Tisocks.net
If you need Socks5, please visit the service and add money via PM, BTC WMZ. Thank you all !!
Add funds: https://tisocks.net/addfund
Check socks5 online here: https://checksocks5.com
LIVE | 113.137.109.136:38801 | 2,846 | SOCKS5 | Shaanxi | Unknown | China Telecom | China | Checked at https://tisocks.net
LIVE | 113.137.110.255:38801 | 0.936 | SOCKS5 | Shaanxi | Unknown | China Telecom | China | Checked at https://tisocks.net
LIVE | 175.165.230.36:38801 | 1,222 | SOCKS5 | Liaoning | Unknown | China Unicom Liaoning | China | Checked at https://tisocks.net
LIVE | 183.166.145.100:38801 | 1,874 | SOCKS5 | Anhui | Unknown | China Telecom | China | Checked at https://tisocks.net
LIVE | 49.85.51.40:38801 | 1.605 | SOCKS5 | Jiangsu | Unknown | China Telecom | China | Checked at https://tisocks.net
LIVE | 125.78.14.28:38801 | 2,024 | SOCKS5 | Fujian | Unknown | China Telecom | China | Checked at https://tisocks.net
LIVE | 60.166.129.79:38801 | 1,232 | SOCKS5 | Unknown | Unknown | China Telecom | China | Checked at https://tisocks.net
LIVE | 60.189.121.52:38801 | 4,615 | SOCKS5 | Zhejiang | Unknown | 52.121.189.60.broad.tz.zj.dynamic.163data.com.cn | China | Checked at https://tisocks.net
LIVE | 114.238.25.224:38801 | 1,047 | SOCKS5 | Jiangsu | Unknown | China Telecom | China | Checked at https://tisocks.net
LIVE | 49.88.156.40:38801 | 3,898 | SOCKS5 | Jiangsu | Unknown | China Telecom | China | Checked at https://tisocks.net
LIVE | 175.155.138.127:38801 | 5,079 | SOCKS5 | Sichuan | Unknown | China Unicom Liaoning | China | Checked at https://tisocks.net
LIVE | 114.104.183.50:38801 | 1,092 | SOCKS5 | Anhui | Unknown | China Telecom | China | Checked at https://tisocks.net
LIVE | 119.52.41.15:38801 | 1,155 | SOCKS5 | Jilin | Unknown | 15.41.52.119.adsl-pool.jlccptt.net.cn | China | Checked at https://tisocks.net
LIVE | 123.169.37.30:38801 | 1,136 | SOCKS5 | Guangdong | Unknown | China Telecom | China | Checked at https://tisocks.net
LIVE | 198.12.157.28:21778 | 4,385 | SOCKS5 | Unknown | Unknown | ip-198-12-157-28.ip.secureserver.net | United States Checked at https://tisocks.net
LIVE | 113.103.52.27:38801 | 2,933 | SOCKS5 | Guangdong | Unknown | China Telecom | China | Checked at https://tisocks.net

Tisocks
Reviewed by Tisocks on
.
[Tisocks.net] – Socks5 Proxy Service Cheap Socks5
SOCKS Proxy List from Tisocks.net
If you need Socks5, please visit the service and add money via PM, BTC WMZ. Thank you all !!
Add funds: https://tisocks.net/addfund
Check socks5 online here: https://checksocks5.com
LIVE | 113.137.109.136:38801 | 2,846 | SOCKS5 | Shaanxi | Unknown | China Telecom | China | Checked at https://tisocks.net
LIVE | 113.137.110.255:38801 | 0.936 | SOCKS5 | Shaanxi | Unknown | China Telecom | China | Checked at https://tisocks.net
LIVE | 175.165.230.36:38801 | 1,222 |

Rating: 5

Send a direct message to the contact via WhatsApp in Delphi / Firemonkey 10.3 (Mobile)

So far, I was only able to open the contact selection screen and not directly on the specified contact.

Message: string;
ret: boolean;
IntentWhats: JIntent;

    mensagem := 'https://web.whatsapp.com/send?1=pt_BR&phone=5581000000000';
    {$IFDEF ANDROID}
    IntentWhats.setType(StringToJString('text/plain'));
    number := 5581994903073;
    IntentWhats.setPackage(StringToJString('com.whatsapp'));
    SharedActivity.startActivity(IntentWhats.addCategory(number));
    {$ENDIF ANDROID}
    {$IFDEF IOS}
    NSU := StrToNSUrl(mensagem);
    ret := SharedApplication.openUrl(NSU);
    IntentWhats.putExtra()

Socks5 Proxy Service Cheap Socks5SOCKS Proxy

SOCKS Proxy List from Tisocks.net
If you need Socks5, please visit the service and add money via PM, BTC WMZ. Thank you all !!
Add funds: https://tisocks.net/addfund
Check socks5 online here: https://checksocks5.com
LIVE | 54.36.244.133:50922 | 0.776 | SOCKS5 | Texas | 75447 | Northeast Texas Broadband, LLC | United States Checked at https://tisocks.net
LIVE | 103.46.128.49:15572 | 0.803 | SOCKS5 | California | 90017 | 192.69.90.173.16clouds.com | United States Checked at https://tisocks.net
LIVE | 13.229.103.107:56420 | 1,016 | SOCKS5 | Unknown | Unknown | ec2-13-229-103-107.ap-southeast-1.compute.amazonaws.com | Unknown | Checked at https://tisocks.net
LIVE | 104.238.97.215:5613 | 0.702 | SOCKS5 | Unknown | Unknown | ip-104-238-97-215.ip.secureserver.net | United States Checked at https://tisocks.net
LIVE | 66.33.209.41:39173 | 1,429 | SOCKS5 | Unknown | Unknown | kronleuchter.dreamhost.com | United States Checked at https://tisocks.net
LIVE | 162.243.210.52:4453 | 0.042 | SOCKS5 | New York | 10011 | yncu.co-gug2012.com | United States Checked at https://tisocks.net
LIVE | 157.119.207.10:6667 | 1,652 | SOCKS5 | Unknown | Unknown | | Unknown | Checked at https://tisocks.net
LIVE | 70.183.39.3:25012 | 0.862 | SOCKS5 | Unknown | Unknown | Cox Communications | Unknown | Checked at https://tisocks.net
LIVE | 64.90.52.203:48309 | 1.33 | SOCKS5 | Unknown | Unknown | sublimity.dreamhost.com | Unknown | Checked at https://tisocks.net
LIVE | 216.144.228.130:15378 | 0.863 | SOCKS5 | Unknown | Unknown | | Unknown | Checked at https://tisocks.net
LIVE | 96.44.183.149:55225 | 0.83 | SOCKS5 | Unknown | Unknown | | Unknown | Checked at https://tisocks.net
LIVE | 64.90.49.151:48309 | 1.206 | SOCKS5 | Unknown | Unknown | sublimity.dreamhost.com | United States Checked at https://tisocks.net
LIVE | 198.12.154.22:26159 | 1.02 | SOCKS5 | Unknown | Unknown | | Unknown | Checked at https://tisocks.net
LIVE | 51.81.31.62:17284 | 0.223 | SOCKS5 | Minnesota | 55902 | 96-42-83-118.dhcp.roch.mn.charter.com | United States Checked at https://tisocks.net
LIVE | 42.112.20.116:7200 | 0.782 | SOCKS5 | Unknown | Unknown | | Unknown | Checked at https://tisocks.net
LIVE | 13.229.103.107:16974 | 1,424 | SOCKS5 | Unknown | Unknown | Amazon.com | Unknown | Checked at https://tisocks.net

Tisocks
Reviewed by Tisocks on
,
[Tisocks.net] – Socks5 Proxy Service Cheap Socks5SOCKS Proxy
SOCKS Proxy List from Tisocks.net
If you need Socks5, please visit the service and add money via PM, BTC WMZ. Thank you all !!
Add funds: https://tisocks.net/addfund
Check socks5 online here: https://checksocks5.com
LIVE | 54.36.244.133:50922 | 0.776 | SOCKS5 | Texas | 75447 | Northeast Texas Broadband, LLC | United States Checked at https://tisocks.net
LIVE | 103.46.128.49:15572 | 0.803 | SOCKS5 | California | 90017 | 192.69.90.173.16clouds.com | United States Checked at https://tisocks.net

Rating: 5

[Vn5socks.net] Auto update 24/7 – good socks 10h30 pm

LIFE ~ 98.143.145.30:62353 | 0.193 | los Angeles | CA. | 90014 | United States | Checked at vn5socks.net
LIFE ~ 72.11.148.222:56533 | 0.191 | los Angeles | CA. | 90014 | United States | Checked at vn5socks.net
LIFE ~ 216.144.230.233:15993 | 0.192 | Van Nuys | CA. | 91411 | United States | Checked at vn5socks.net
LIFE ~ 45.32.251.42:1085 | 0.156 | Unknown | Unknown | Unknown | Unknown | Checked at vn5socks.net
LIFE ~ 88.99.149.206:9050 | 0.33 | Unknown | Unknown | Unknown | United Kingdom | Checked at vn5socks.net
LIFE ~ 124.65.145.126:7302 | 0,241 | Peking | 22 | Unknown | China | Checked at vn5socks.net
LIFE ~ 70.183.39.2:25013 | 0.296 | Unknown | Unknown | Unknown | United States | Checked at vn5socks.net
LIFE ~ 114.106.150.70:20086 | 0.415 | Hefei | 01 | Unknown | China | Checked at vn5socks.net
LIFE ~ 47.75.70.100:9999 | 0,036 | Ottawa | ON | k1y4h7 | Canada | Checked at vn5socks.net
LIFE ~ 159.69.198.82:9050 | 0,339 | Jacksonville | FL | 32202 | United States | Checked at vn5socks.net
LIFE ~ 72.221.164.35:60670 | 0.415 | Unknown | Unknown | Unknown | United States | Checked at vn5socks.net
LIFE ~ 13.229.103.107:40689 | 0.06 | Norwalk | CT | 06850 | United States | Checked at vn5socks.net
LIFE ~ 166.62.118.88:17993 | 0.437 | Unknown | Unknown | Unknown | Unknown | Checked at vn5socks.net
LIFE ~ 128.199.232.56:9050 | 0,049 | Unknown | Unknown | Unknown | United Kingdom | Checked at vn5socks.net
LIFE ~ 216.144.228.130:15378 | 0.191 | Van Nuys | CA. | 91411 | United States | Checked at vn5socks.net
LIFE ~ 98.181.99.197:10368 | 0.653 | Unknown | Unknown | Unknown | United States | Checked at vn5socks.net
LIFE ~ 66.110.216.105:39431 | 0,585 | Atlanta | GA | 30328 | United States | Checked at vn5socks.net
LIFE ~ 24.249.199.14:57335 | 0.663 | Unknown | Unknown | Unknown | United States | Checked at vn5socks.net

Fire Heaven
Reviewed by Fire Heaven on
,
[Vn5socks.net] Auto Update 24/7 – Good Socks 10h30 PM
LIVE ~ 98.143.145.30:62353 | 0.193 | Los Angeles | CA | 90014 | United States Checked at vn5socks.net
LIVE ~ 72.11.148.222:56533 | 0.191 | Los Angeles | CA | 90014 | United States Checked at vn5socks.net
LIVE ~ 216.144.230.233:15993 | 0.192 | Van Nuys | CA | 91411 | United States Checked at vn5socks.net
LIVE ~ 45.32.251.42:1085 | 0.156 | Unknown | Unknown | Unknown | Unknown | Checked at vn5socks.net
LIVE ~ 88.99.149.206:9050 | 0.33 | Unknown | Unknown |

Rating: 5

Socks5 Proxy Service Cheap Socks5

SOCKS Proxy List from Tisocks.net
If you need Socks5, please visit service and add funds via PM, BTC WMZ. Thank you all !!
Add funds: https://tisocks.net/addfund
Check socks5 online here: https://checksocks5.com
LIVE | 54.36.244.137:31034 | 0.875 | SOCKS5 | California | 95811 | 32-174-222-146.myvzw.com | United States Checked at https://tisocks.net
LIVE | 54.36.244.91:49698 | 0.768 | SOCKS5 | Pennsylvania | 19608 | mobile-107-77-202-60.mobile.att.net | United States Checked at https://tisocks.net
LIVE | 54.36.244.148:57705 | 0.897 | SOCKS5 | Texas | 78209 | cpe-173-173-110-85.satx.res.rr.com | United States Checked at https://tisocks.net
LIVE | 37.152.176.65:2020 | 1,191 | SOCKS5 | Unknown | Unknown | | Unknown | Checked at https://tisocks.net
LIVE | 51.81.31.65:56888 | 0.318 | SOCKS5 | California | 90026 | cpe-107-184-42-82.socal.res.rr.com | United States Checked at https://tisocks.net
LIVE | 64.118.87.36:56952 | 0.871 | SOCKS5 | Unknown | Unknown | 4RWEB | United States Checked at https://tisocks.net
LIVE | 51.81.31.65:37423 | 0.141 | SOCKS5 | Unknown | Unknown | | Unknown | Checked at https://tisocks.net
LIVE | 134.73.173.12:6666 | 0.409 | SOCKS5 | Unknown | Unknown | Global Frag Networks United States Checked at https://tisocks.net
LIVE | 174.76.35.29:36177 | 0.363 | SOCKS5 | California | 92114 | | United States Checked at https://tisocks.net
LIVE | 212.129.45.147:34046 | 0.421 | SOCKS5 | Occitanie | 30200 | 176-141-87-204.abo.bbox.fr | France | Checked at https://tisocks.net
LIVE | 208.109.52.52:36836 | 0.259 | SOCKS5 | Unknown | Unknown | ip-208-109-52-52.ip.secureserver.net | United States Checked at https://tisocks.net
LIVE | 208.113.154.97:13080 | 0.109 | SOCKS5 | Unknown | Unknown | accomack.dreamhost.com | United States Checked at https://tisocks.net
LIVE | 103.250.157.43:6667 | 1,346 | SOCKS5 | Unknown | Unknown | GTPL broadband India | Checked at https://tisocks.net
LIVE | 51.81.31.62:41865 | 0.242 | SOCKS5 | Florida | 33823 | 072-187-043-073.res.spectrum.com | United States Checked at https://tisocks.net
LIVE | 51.81.31.63:57056 | 0.335 | SOCKS5 | Arizona | 85022 | ip72-211-179-211.tc.ph.cox.net | United States Checked at https://tisocks.net
LIVE | 134.73.173.212:6666 | 0.365 | SOCKS5 | Unknown | Unknown | Global Frag Networks United States Checked at https://tisocks.net

Tisocks
Reviewed by Tisocks on
,
[Tisocks.net] – Socks5 Proxy Service Cheap Socks5
SOCKS Proxy List from Tisocks.net
If you need Socks5, please visit service and add funds via PM, BTC WMZ. Thank you all !!
Add funds: https://tisocks.net/addfund
Check socks5 online here: https://checksocks5.com
LIVE | 54.36.244.137:31034 | 0.875 | SOCKS5 | California | 95811 | 32-174-222-146.myvzw.com | United States Checked at https://tisocks.net
LIVE | 54.36.244.91:49698 | 0.768 | SOCKS5 | Pennsylvania | 19608 | mobile-107-77-202-60.mobile.att.net | United States Checked around

Rating: 5

,

linux – InnoDB: Error: table "mysql". "mysql.transaction_registry" was not found after upgrading to mariadb 10.3

Create tables for mariadb 10

CREATE TABLE `gtid_slave_pos` (
`domain_id` int(10) unsigned NOT NULL,
`sub_id` bigint(20) unsigned NOT NULL,
`server_id` int(10) unsigned NOT NULL,
`seq_no` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`domain_id`,`sub_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Replication slave GTID state';

CREATE TABLE `innodb_index_stats` (
`database_name` varchar(64) COLLATE utf8_bin NOT NULL,
`table_name` varchar(64) COLLATE utf8_bin NOT NULL,
`index_name` varchar(64) COLLATE utf8_bin NOT NULL,
`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`stat_name` varchar(64) COLLATE utf8_bin NOT NULL,
`stat_value` bigint(20) unsigned NOT NULL,
`sample_size` bigint(20) unsigned DEFAULT NULL,
`stat_description` varchar(1024) COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`database_name`,`table_name`,`index_name`,`stat_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE `innodb_table_stats` (
`database_name` varchar(64) COLLATE utf8_bin NOT NULL,
`table_name` varchar(64) COLLATE utf8_bin NOT NULL,
`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`n_rows` bigint(20) unsigned NOT NULL,
`clustered_index_size` bigint(20) unsigned NOT NULL,
`sum_of_other_index_sizes` bigint(20) unsigned NOT NULL,
PRIMARY KEY (`database_name`,`table_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

CREATE TABLE `slave_master_info` (
`Number_of_lines` int(10) unsigned NOT NULL COMMENT 'Number of lines in the file.',
`Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the master binary log currently being read from the master.',
`Master_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The master log position of the last read event.',
`Host` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'The host name of the master.',
`User_name` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The user name used to connect to the master.',
`User_password` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The password used to connect to the master.',
`Port` int(10) unsigned NOT NULL COMMENT 'The network port used to connect to the master.',
`Connect_retry` int(10) unsigned NOT NULL COMMENT 'The period (in seconds) that the slave will wait before trying to reconnect to the master.',
`Enabled_ssl` tinyint(1) NOT NULL COMMENT 'Indicates whether the server supports SSL connections.',
`Ssl_ca` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file used for the Certificate Authority (CA) certificate.',
`Ssl_capath` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The path to the Certificate Authority (CA) certificates.',
`Ssl_cert` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the SSL certificate file.',
`Ssl_cipher` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the cipher in use for the SSL connection.',
`Ssl_key` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the SSL key file.',
`Ssl_verify_server_cert` tinyint(1) NOT NULL COMMENT 'Whether to verify the server certificate.',
`Heartbeat` float NOT NULL,
`Bind` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'Displays which interface is employed when connecting to the MySQL server',
`Ignored_server_ids` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The number of server IDs to be ignored, followed by the actual server IDs',
`Uuid` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The master server uuid.',
`Retry_count` bigint(20) unsigned NOT NULL COMMENT 'Number of reconnect attempts, to the master, before giving up.',
`Ssl_crl` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file used for the Certificate Revocation List (CRL)',
`Ssl_crlpath` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The path used for Certificate Revocation List (CRL) files',
`Enabled_auto_position` tinyint(1) NOT NULL COMMENT 'Indicates whether GTIDs will be used to retrieve events from the master.',
PRIMARY KEY (`Host`,`Port`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Master Information';

CREATE TABLE `slave_relay_log_info` (
`Number_of_lines` int(10) unsigned NOT NULL COMMENT 'Number of lines in the file or rows in the table. Used to version table definitions.',
`Relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the current relay log file.',
`Relay_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The relay log position of the last executed event.',
`Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the master binary log file from which the events in the relay log file were read.',
`Master_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The master log position of the last executed event.',
`Sql_delay` int(11) NOT NULL COMMENT 'The number of seconds that the slave must lag behind the master.',
`Number_of_workers` int(10) unsigned NOT NULL,
`Id` int(10) unsigned NOT NULL COMMENT 'Internal Id that uniquely identifies this record.',
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Relay Log Information';

CREATE TABLE `slave_worker_info` (
`Id` int(10) unsigned NOT NULL,
`Relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`Relay_log_pos` bigint(20) unsigned NOT NULL,
`Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`Master_log_pos` bigint(20) unsigned NOT NULL,
`Checkpoint_relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`Checkpoint_relay_log_pos` bigint(20) unsigned NOT NULL,
`Checkpoint_master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`Checkpoint_master_log_pos` bigint(20) unsigned NOT NULL,
`Checkpoint_seqno` int(10) unsigned NOT NULL,
`Checkpoint_group_size` int(10) unsigned NOT NULL,
`Checkpoint_group_bitmap` blob NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Worker Information';

[Vn5socks.net] Auto Update 24/7 – Good socks 1h00 PM

LIFE ~ 220.79.34.109:2018 | 0.116 | Seoul | 11 | Unknown | Korea, Republic of | Checked around vn5socks.net
LIFE ~ 98.143.145.29:62354 | 0,189 | los Angeles | CA. | 90014 | United States | Checked around vn5socks.net
LIFE ~ 42.112.20.116:7200 | 0,002 | Hanoi | 44 | Unknown | Vietnam | Checked around vn5socks.net
LIFE ~ 96.44.183.149:55225 | 0.197 | los Angeles | CA. | 90014 | United States | Checked around vn5socks.net
LIFE ~ 139.162.76.176:9050 | 0,075 | Rotterdam | 11 | Unknown | Netherlands | Checked around vn5socks.net
LIFE ~ 216.144.228.130:15378 | 0.195 | Van Nuys | CA. | 91411 | United States | Checked around vn5socks.net
LIFE ~ 72.11.148.222:56533 | 0,181 | los Angeles | CA. | 90014 | United States | Checked around vn5socks.net
LIFE ~ 88.99.149.206:9050 | 0.308 | Unknown | Unknown | Unknown | United Kingdom | Checked around vn5socks.net
LIFE ~ 96.44.133.110:58690 | 0.18 | Agoura Hills | CA. | Unknown | United States | Checked around vn5socks.net
LIFE ~ 216.144.230.233:15993 | 0,186 | Van Nuys | CA. | 91411 | United States | Checked around vn5socks.net
LIFE ~ 98.143.145.30:62353 | 0.192 | los Angeles | CA. | 90014 | United States | Checked around vn5socks.net
LIFE ~ 159.89.49.106:1110 | 0.26 | Vancouver | BC | v7y1j7 | Canada | Checked around vn5socks.net
LIFE ~ 91.121.67.146:9050 | 0,279 | Unknown | Unknown | Unknown | France | Checked around vn5socks.net
LIFE ~ 13.229.103.107:40689 | 0.064 | Norwalk | CT | 06850 | United States | Checked around vn5socks.net
LIFE ~ 13.229.103.107:16974 | 0.053 | Norwalk | CT | 06850 | United States | Checked around vn5socks.net
LIFE ~ 148.251.43.252:1090 | 0.306 | neighbourhood | 12 | Unknown | Germany | Checked around vn5socks.net
LIFE ~ 80.248.225.58:2019 | 0.319 | Unknown | Unknown | Unknown | France | Checked around vn5socks.net
LIFE ~ 51.15.34.111:1091 | 0.264 | Unknown | Unknown | Unknown | United Kingdom | Checked around vn5socks.net

Feuerhimmel
Reviewed by Feuerhimmel on
,
[Vn5socks.net] Auto Update 24/7 – Good socks 1h00 PM
LIVE ~ 220.79.34.109:2018 | 0.116 | Seoul | 11 | Unknown | Korea, Republic of | Checked at vn5socks.net
LIVE ~ 98.143.145.29:62354 | 0.189 | Los Angeles | CA | 90014 | United States Checked at vn5socks.net
LIVE ~ 42.112.20.116:7200 | 0.002 | Hanoi | 44 | Unknown | Vietnam | Checked at vn5socks.net
LIVE ~ 96.44.183.149:55225 | 0.197 | Los Angeles | CA | 90014 | United States Checked at vn5socks.net
LIVE ~ 139.162.76.176:9050 | 0.075 | Rotterdam | 11 | Unknown

Rating: 5

[Vn5socks.net] Auto Update 24/7 – Good socks 10h00 PM

LIFE ~ 139.162.76.176:9050 | 0,065 | Rotterdam | 11 | Unknown | Netherlands | Checked around vn5socks.net
LIFE ~ 47.94.244.27:7302 | 0.073 | Ottawa | ON | k1y4h7 | Canada | Checked around vn5socks.net
LIFE ~ 96.44.183.149:55225 | 0.183 | los Angeles | CA. | 90014 | United States | Checked around vn5socks.net
LIFE ~ 220.79.34.109:2018 | 0.131 | Seoul | 11 | Unknown | Korea, Republic of | Checked around vn5socks.net
LIFE ~ 163.172.147.132:2323 | 0.244 | Southend | M5 | Unknown | United Kingdom | Checked around vn5socks.net
LIFE ~ 104.196.70.154:6777 | 0.236 | Unknown | Unknown | Unknown | Unknown | Checked around vn5socks.net
LIFE ~ 95.170.77.200:2010 | 0,269 | Unknown | Unknown | Unknown | Netherlands | Checked around vn5socks.net
LIFE ~ 80.248.225.58:2019 | 0.307 | Unknown | Unknown | Unknown | France | Checked around vn5socks.net
LIFE ~ 51.15.34.111:1091 | 0.268 | Unknown | Unknown | Unknown | United Kingdom | Checked around vn5socks.net
LIFE ~ 72.11.148.222:56533 | 0.212 | los Angeles | CA. | 90014 | United States | Checked around vn5socks.net
LIFE ~ 37.57.107.99:9999 | 0.379 | Unknown | Unknown | Unknown | Ukraine | Checked around vn5socks.net
LIFE ~ 42.112.20.116:7200 | 0,045 | Hanoi | 44 | Unknown | Vietnam | Checked around vn5socks.net
LIFE ~ 98.143.145.30:62353 | 0.317 | los Angeles | CA. | 90014 | United States | Checked around vn5socks.net
LIFE ~ 98.143.145.29:62354 | 0.266 | los Angeles | CA. | 90014 | United States | Checked around vn5socks.net
LIFE ~ 82.165.137.115:7061 | 0.286 | Unknown | Unknown | Unknown | Germany | Checked around vn5socks.net
LIFE ~ 96.44.133.110:58690 | 0.185 | Agoura Hills | CA. | Unknown | United States | Checked around vn5socks.net
LIFE ~ 103.86.49.154:10129 | 0,262 | Unknown | Unknown | Unknown | Unknown | Checked around vn5socks.net
LIFE ~ 91.98.60.127:9999 | 0,483 | Pars | 26 | Unknown | Iran, Islamic Republic | Checked around vn5socks.net

Feuerhimmel
Reviewed by Feuerhimmel on
,
[Vn5socks.net] Auto Update 24/7 – Good socks 10h00 PM
LIVE ~ 139.162.76.176:9050 | 0.065 | Rotterdam | 11 | Unknown | Netherlands | Checked at vn5socks.net
LIVE ~ 47.94.244.27:7302 | 0.073 | Ottawa | ON | k1y4h7 | Canada | Checked at vn5socks.net
LIVE ~ 96.44.183.149:55225 | 0.183 | Los Angeles | CA | 90014 | United States Checked at vn5socks.net
LIVE ~ 220.79.34.109:2018 | 0.131 | Seoul | 11 | Unknown | Korea, Republic of | Checked at vn5socks.net
LIVE ~ 163.172.147.132:2323 | 0.244 | Southend | M5 | Unknown |

Rating: 5