I've done all I can, to validate that this isn't network or disk related.
Disk tests (using iostat and other methods) show lots of bandwidth left on the slave and master.
Network tests, such as:
- using scp to copy binlogs directly - using different NICs to copy binlogs - using mysqlbinlog to snag logs (the most 'real' way I can think to simulate the replication thread copying binlogs from the master)
All seem to show that network speed is blazingly fast.
Yet, MySQL is barely getting 4mbit/sec across the network, and onto the disk. And that's on a good day.
Any immediate suggestions here? This seems very weird, and SQL thread is constantly running out of stuff to process.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Jan 20
Morgan Tocker RE: io thread very slow copying binlogs
Jan 20, 2017; 10:19
Morgan Tocker
RE: io thread very slow copying binlogs
Jan 20
Brad Barnett Re: io thread very slow copying binlogs
Jan 20, 2017; 10:32
Brad Barnett
Re: io thread very slow copying binlogs
Jan 20
Brad Barnett Re: io thread very slow copying binlogs
Jan 20, 2017; 10:44
Brad Barnett
Re: io thread very slow copying binlogs
Jan 20
Michael Dykman RE: io thread very slow copying binlogs
Jan 20, 2017; 16:04
Michael Dykman
RE: io thread very slow copying binlogs
Jul 27
Lars Tangvald MySQL Cluster 7.2.34 has been released
Jul 27, 2018; 20:46
Lars Tangvald
MySQL Cluster 7.2.34 has been released
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!