Re: [RDD] Slow mysql (rdlogmanager generate log) on debian9
Hello all, I’m trying to reproduce the MySQL issue but in my virtual environment look all working well. At the moment I cannot put in place a real physical environment. If someone who have an environment with the problem can let me take a look I would be really interested to figure out what is the problem Regards Gabriele Sent from my iPhone > On 30 Aug 2019, at 18:15, "li...@lokum.ro" wrote: > > Is there a fix? > > If i install a separated unit for sql will it fix it? > > Liviu > > Sent from my HTC > > - Reply message - > From: "Fred Gleason" > To: > Subject: [RDD] Slow mysql (rdlogmanager generate log) on debian9 > Date: Fri, Aug 30, 2019 19:10 > > On Fri, 2019-08-30 at 10:53 +, li...@lokum.ro wrote: > > This is RD 3.0.3 from master on debian9 > > After going to sleep early in the morning... today I faced an issue > > with the guys trying to generate logs. > > > > the system hangs and takes forever to finish... mysql service on > > server is 100% > > Known problem when using remote clients with a Debian-based MySQL > server. > > > > is there a fix ? > > Not that I'm aware of. It does not appear to be an issue with MySQL or > Rivendell itself (I've tested with MySQL v5.7 on both CentOS 7 and > Fedora 30; both setups work fine with client workstations). It appears > to be something to do with the way Debian-ish distros package MySQL. > > Cheers! > > > |-| > | Frederick F. Gleason, Jr. | Chief Developer | > | | Paravel Systems | > |-| > | A room without books is like a body without a soul. | > | | > | -- Cicero | > |-| > > ___ > Rivendell-dev mailing list > Rivendell-dev@lists.rivendellaudio.org > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > ___ > Rivendell-dev mailing list > Rivendell-dev@lists.rivendellaudio.org > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
Re: [RDD] Slow mysql (rdlogmanager generate log) on debian9
So on debian10 its working? But on that one i have issues with usb sound cards :)) I will try centos in the weekend. Liviu Sent from my HTC - Reply message - From: "Tim Camp" To: , "User discussion about the Rivendell Radio Automation System" Subject: [RDD] Slow mysql (rdlogmanager generate log) on debian9 Date: Fri, Aug 30, 2019 22:22 The issue is not MySQL server but MySQL client on Debian9/Ubuntu18 Something in those distros is causing huge problems. Tim Camp On Fri, Aug 30, 2019, 11:15 AM li...@lokum.ro wrote: Is there a fix? If i install a separated unit for sql will it fix it? Liviu Sent from my HTC - Reply message - From: "Fred Gleason" To: Subject: [RDD] Slow mysql (rdlogmanager generate log) on debian9 Date: Fri, Aug 30, 2019 19:10 On Fri, 2019-08-30 at 10:53 +, li...@lokum.ro wrote: > This is RD 3.0.3 from master on debian9 > After going to sleep early in the morning... today I faced an issue > with the guys trying to generate logs. > > the system hangs and takes forever to finish... mysql service on > server is 100% Known problem when using remote clients with a Debian-based MySQL server. > is there a fix ? Not that I'm aware of. It does not appear to be an issue with MySQL or Rivendell itself (I've tested with MySQL v5.7 on both CentOS 7 and Fedora 30; both setups work fine with client workstations). It appears to be something to do with the way Debian-ish distros package MySQL. Cheers! |-| | Frederick F. Gleason, Jr. | Chief Developer | | | Paravel Systems | |-| | A room without books is like a body without a soul. | | | | -- Cicero | |-| ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
Re: [RDD] Slow mysql (rdlogmanager generate log) on debian9
If your server has enough power you might create the log on the server to solve it on Debian Verzonden vanaf mijn Samsung-apparaat Oorspronkelijk bericht Van: Fred Gleason Datum: 30-08-2019 18:10 (GMT+01:00) Aan: rivendell-dev@lists.rivendellaudio.org Onderwerp: Re: [RDD] Slow mysql (rdlogmanager generate log) on debian9 On Fri, 2019-08-30 at 10:53 +, li...@lokum.ro wrote:> This is RD 3.0.3 from master on debian9> After going to sleep early in the morning... today I faced an issue> with the guys trying to generate logs.> > the system hangs and takes forever to finish... mysql service on> server is 100%Known problem when using remote clients with a Debian-based MySQLserver.> is there a fix ?Not that I'm aware of. It does not appear to be an issue with MySQL orRivendell itself (I've tested with MySQL v5.7 on both CentOS 7 andFedora 30; both setups work fine with client workstations). It appearsto be something to do with the way Debian-ish distros package MySQL.Cheers!|-|| Frederick F. Gleason, Jr. | Chief Developer || | Paravel Systems ||-|| A room without books is like a body without a soul. || || -- Cicero ||-|___Rivendell-dev mailing listRivendell-dev@lists.rivendellaudio.orghttp://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
Re: [RDD] Slow mysql (rdlogmanager generate log) on debian9
On Fri, 2019-08-30 at 19:15 +0300, li...@lokum.ro wrote: > If i install a separated unit for sql will it fix it? I doubt that merely isolating it will make any difference. You'd need it to be on a non-Debian platform. I know that several others here have been working on this issue, perhaps they can offer more specific advice. Cheers! |-| | Frederick F. Gleason, Jr. | Chief Developer | | | Paravel Systems | |-| | A room without books is like a body without a soul. | | | | -- Cicero | |-| ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
Re: [RDD] Slow mysql (rdlogmanager generate log) on debian9
Is there a fix? If i install a separated unit for sql will it fix it? Liviu Sent from my HTC - Reply message - From: "Fred Gleason" To: Subject: [RDD] Slow mysql (rdlogmanager generate log) on debian9 Date: Fri, Aug 30, 2019 19:10 On Fri, 2019-08-30 at 10:53 +, li...@lokum.ro wrote: > This is RD 3.0.3 from master on debian9 > After going to sleep early in the morning... today I faced an issue > with the guys trying to generate logs. > > the system hangs and takes forever to finish... mysql service on > server is 100% Known problem when using remote clients with a Debian-based MySQL server. > is there a fix ? Not that I'm aware of. It does not appear to be an issue with MySQL or Rivendell itself (I've tested with MySQL v5.7 on both CentOS 7 and Fedora 30; both setups work fine with client workstations). It appears to be something to do with the way Debian-ish distros package MySQL. Cheers! |-| | Frederick F. Gleason, Jr. | Chief Developer | | | Paravel Systems | |-| | A room without books is like a body without a soul. | | | | -- Cicero | |-| ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
Re: [RDD] Slow mysql (rdlogmanager generate log) on debian9
On Fri, 2019-08-30 at 10:53 +, li...@lokum.ro wrote: > This is RD 3.0.3 from master on debian9 > After going to sleep early in the morning... today I faced an issue > with the guys trying to generate logs. > > the system hangs and takes forever to finish... mysql service on > server is 100% Known problem when using remote clients with a Debian-based MySQL server. > is there a fix ? Not that I'm aware of. It does not appear to be an issue with MySQL or Rivendell itself (I've tested with MySQL v5.7 on both CentOS 7 and Fedora 30; both setups work fine with client workstations). It appears to be something to do with the way Debian-ish distros package MySQL. Cheers! |-| | Frederick F. Gleason, Jr. | Chief Developer | | | Paravel Systems | |-| | A room without books is like a body without a soul. | | | | -- Cicero | |-| ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
[RDD] Slow mysql (rdlogmanager generate log) on debian9
Hi, again :) This is RD 3.0.3 from master on debian9 After going to sleep early in the morning... today I faced an issue with the guys trying to generate logs. the system hangs and takes forever to finish... mysql service on server is 100% is there a fix ? ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev