Hi, When it is slow / has stopped working, does TOP show anything eating up CPU cycles or memory on either of these machines?
> > > If I log into nerodia and enter: > > mysql -urduser -pwhatever Rivendell > > ...there is no problem. > > There is another rdairplay running on nerodia (for a different station > than the one running on storeria). It has never had a problem. > > Oddly, the problem on storeria went away again shortly after I posted my > last email. But it will come back again. It comes and goes. Weird, huh? > > > Rob > > On Sat, 12 Apr 2014, Lorne Tyndale wrote: > > > Hi Rob, > > > > When it is doing this, have you tried opening up a shell on Nerodia and > > tried to connect to the database located on that machine directly, the > > same test you did connecting from Storeria? > > > > This might tell you if it is a MySQL issue or something with the > > network. > > > > When was the last time you restarted MySQL on Nerordia? And does the > > MySQL log show any errors? > > > > While this is not likely the issue, one machine that I has some serious > > MySQL latency on had 2 Nic's in it, and I didn't realize it but I'd > > managed to bind MySQL to only 1 of the Nics (not the one that had the > > traffic coming in on it). For some reason it still worked on the > > network (I still don't understand that part) but was very slow. > > > > I'm sure you've already checked this, but make sure you've got enough > > memory assigned to MySQL and such in its setup. > > Lorne > > > >> > >> > >> I spoke too soon; the problem is back with a vengeance. It seems to be > >> MySQL related. > >> > >> The database resides on "nerodia"; the machine named "storeria" is running > >> rdairplay. Rdairplay seems to freeze from time to time, but the current > >> event will play in its entirety. Then there will be a delay, sometimes up > >> to 2 minutes, before rdairplay starts the next event. > >> > >> I can flood-ping "nerodia" from "storeria" with zero packet loss. I can > >> ssh into "nerodia" from "storeria" while rdairplay is frozen with no > >> problem. I don't think this is a general networking issue. > >> > >> If I open a terminal window on "storeria" and enter: > >> > >> mysql -urduser -pwhatever -hnerodia Rivendell > >> > >> ...it takes forever to connect, and once connected, a command like "show > >> tables" also takes forever. The same command run directly on "nerodia" is > >> lightning-fast. > >> > >> Sometimes, however, the connection attempt from "storeria" to "nerodia" > >> times out, and I get: > >> > >> ERROR 2013 (HY000): Lost connection to MySQL server at 'reading > >> authorization packet', system error: 0 > >> > >> That has me baffled. Googling suggests it may be a bug in MySQL itself. > >> > >> This is MySQL 5.1.73-1 (Debian 6). RD is version 2.5.5. Both "nerodia" and > >> "storeria" are Dell Optiplex 755's. > >> > >> > >> Rob > >> > >> > >> On Fri, 11 Apr 2014, Rob Landry wrote: > >> > >> > > >> > I am using nfs. > >> > > >> > This afternoon I did a backup/restore on the database after deleting a > >> > bunch > >> > of old logs. That seems to have helped. > >> > > >> > Rob > >> > > >> > > >> > On Sat, 12 Apr 2014, Geoff Barkman wrote: > >> > > >> >> > >> >> How is the network file share mounted? > >> >> Are you using nfs or samba? Samba can be quite unstable if you are using > >> >> that. > >> >> Many thanks > >> >> Geoff Barkman > >> >> > >> >> On Apr 12, 2014 3:08 AM, "Rob Landry" <[email protected]> wrote: > >> >> > >> >> That doesn't seem to have helped. > >> >> > >> >> Alas, none of the logs I've checked offer any clues. > >> >> > >> >> > >> >> Rob > >> >> > >> >> > >> >> On Fri, 11 Apr 2014, Wayne Merricks wrote: > >> >> > >> >> Hi, > >> >> > >> >> Have you tried skip name resolve in the mysql conf > >> >> file? > >> >> > >> >> In the [mysqld] section just add: > >> >> > >> >> skip-name-resolve > >> >> > >> >> Then restart the server. > >> >> > >> >> Wayne Merricks > >> >> The Voice Asia > >> >> > >> >> On 11/04/14 13:11, Rob Landry wrote: > >> >> > >> >> I have a Rivendell machine (Debian 6/RD > >> >> version 2.5.5) running rdairplay on a > >> >> network where it is using /var/snd and a > >> >> MySQL database residing on a second > >> >> machine (also running rdairplay). > >> >> > >> >> What I am observing is that rdairplay on > >> >> the first machine (but not the second, > >> >> where /var/snd and the database reside) > >> >> will occasionally pause for several > >> >> seconds while the audio continues to > >> >> play. At the end of the cut, however, > >> >> there will be a pause before the next > >> >> cut starts. > >> >> > >> >> I've never seen this behavior before; if > >> >> there were droputs in playback, I'd > >> >> suspect a network problem, but in this > >> >> case ecah cut will play in its entirety, > >> >> even though rdairplay may pause in the > >> >> middle of the cut, and there will be a > >> >> delay of some seconds before the next > >> >> cut starts. > >> >> > >> >> I'm guessing this is a MySQL issue. Are > >> >> there parameters I should try tuning in > >> >> my.cnf? If so, on which machine? The > >> >> machine exhibiting the pauses is not the > >> >> one hosting the database. > >> >> > >> >> Thanks all. > >> >> > >> >> > >> >> Rob > >> >> > >> >> _______________________________________________ > >> >> Rivendell-dev mailing list > >> >> [email protected] > >> >> > >> >> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > >> >> > >> >> > >> >> _______________________________________________ > >> >> Rivendell-dev mailing list > >> >> [email protected] > >> >> > >> >> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > >> >> > >> >> _______________________________________________ > >> >> Rivendell-dev mailing list > >> >> [email protected] > >> >> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > >> >> > >> >> > >> >> > >> > _______________________________________________ > >> > Rivendell-dev mailing list > >> > [email protected] > >> > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > >> > > >> _______________________________________________ > >> Rivendell-dev mailing list > >> [email protected] > >> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > > _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
