RE: io thread very slow copying binlogs

2017-01-20 Thread Michael Dykman
- From: Brad Barnett [mailto:mysql-general-l...@l8r.net] Sent: Friday, January 20, 2017 10:45 AM To: mysql@lists.mysql.com Subject: Re: io thread very slow copying binlogs Hey Morgan, Thanks for the tip. Might come in handy. But, I'm positive it's not a disconnect / reconnect thing

Re: io thread very slow copying binlogs

2017-01-20 Thread Brad Barnett
Hey Morgan, Thanks for the tip. Might come in handy. But, I'm positive it's not a disconnect / reconnect thing. Or, at least not one affected by that timeout. I can do a watch ls -lh in the binlog dir, and see the relay log increasing in size by a M every 4 or 5 seconds or so. About

Re: io thread very slow copying binlogs

2017-01-20 Thread Brad Barnett
I should add that I've turned the SQL thread off, it makes no difference from what I can see... On Fri, 20 Jan 2017 10:31:38 -0500 Brad Barnett wrote: > > > > On Fri, 20 Jan 2017 10:30:09 -0500 > Brad Barnett wrote: > > > > > > > Hey Morgan, > >

RE: io thread very slow copying binlogs

2017-01-20 Thread Morgan Tocker
Hi Brad, > 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. > >