io thread very slow copying binlogs
Brad Barnett <[email protected]>
| Newsgroups | gmane.comp.db.mysql.general |
|---|---|
| Message-ID | <[email protected]> |
Hey all, I have a weird issue. MySQL community edition 5.6.29, running Linux. Binlogs never seem to get caught up on slaves. 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