Yes, it would be nice to find a resolution. I'm in the progress of
changing all my clients and the server to centos7.
But on one client i stuck with the touchscreen from this company.
http://www.eeti.com/drivers_Linux.html
On Debian the driver is running. But i find no way to use it on centos.
And that's the showstopper for now...
It would be realy nice, if there were the same Centos
Rivendell-installer available for debian stable or ubuntu lts.
Centos is a very stable plattform, but sometimes it is not the best
choice for special or newer hardware...
Am 29.08.2019 17:42, schrieb Tim Camp:
> Greetings,
>
> I was wondering if anyone has made any progress on this old thread. It ended
> with no resolution so wanted to see if anyone was still banging on this.
> As for our stations we are staying on version 2 for now because this issue is
> a major problem in the production environment.
>
> btw way I have run mysqltuner and done everything suggested (which is all
> server side stuff) with no change.
> This is surely a client issue on debian/ubuntu which began with Debian 9 and
> Ubuntu 18.04
>
> Cheers
>
> Tim Camp
> WZEW-FM
> Mobile, Al.
>
> On Sun, Jul 28, 2019 at 8:37 AM Schwoon, newsletter <newslet...@schwoon.info>
> wrote:
>
> Hi, thanks for that.
>
> that tool is for server and client??
>
> That tool said that i should ship-innodb and skip-name-resolve and i tried
> it. (etc/mysql/conf.d/mysql.cnf)
>
> But after restart the tool says the same again.
>
> Is that for server or client??
>
> Am 28.07.2019 14:20, schrieb Rick:
> Install mysqltuner and follow the tips.
>
> Verzonden vanaf mijn Samsung-apparaat
>
> -------- Oorspronkelijk bericht --------
> Van: "Schwoon, newsletter" <newslet...@schwoon.info>
> Datum: 28-07-2019 12:30 (GMT+01:00)
> Aan: rivendell-dev@lists.rivendellaudio.org
> Onderwerp: Re: [RDD] Slow SQL performance
>
> Hi
>
> The last days i've made some tests with the rivendell server.
>
> No matter what rd server ist running. The V3 from centos repo or a
> compiled V3 version on debian 9... Only the rd client, based on the
> centos repo has the sql speed like the older 2.x version. So, it is only
> the client, that causes the problem with sql speed / latency.
>
> Any hints to solve.? Is there a way to tweek the sql client??
>
> Am 21.07.2019 21:46, schrieb Hoggins!:
>> Hello,
>>
>> I suspect I'm experiencing something very similar with my
>> Fedora-flavored setup, because some symptoms I describe in
>> https://github.com/ElvishArtisan/rivendell/issues/462 seem somehow
>> related ("Edit markers" that takes a long time to show up or freezes
>> indefinitely, playback that seems to hang the system as well).
>> Besides, I discovered that generating a log with RDLogmanager *now
>> takes
>> three hours* when it only took 30 minutes with 2.19.3. Could be a DB
>> problem?
>>
>> I'm currently migrating back to 2.19.3 because I'm facing a lot of
>> issues my station can't handle, and right now, rddbmgr (which is a
>> great
>> tool, BTW) used to migrate the database back to the old schema is
>> taking
>> ages. Now it's been running for more than 45 minutes, and I'm not sure
>> this is expected.
>>
>> Hoggins!
>>
>> Le 21/07/2019 à 13:58, Schwoon, newsletter a écrit :
>>>
>>> OK, test with centos client finished
>>>
>>> The centos client is as fast as the server. No problem... Whats wrong
>>> with the mysql setup in Debian/Ubuntu...?
>>>
>>> Am 20.07.2019 21:20, schrieb Tim Camp:
>>>
>>>> Localhost is slow as well, it depends on the size of the query of
>>>> course, loading a group of 2000 songs in rdlibrary can take a minute
>>>> or more.
>>>>
>>>>
>>>> On Sat, Jul 20, 2019, 2:14 PM Schwoon, newsletter
>>>> <newslet...@schwoon.info <mailto:newslet...@schwoon.info>> wrote:
>>>>
>>>> Hi Tim
>>>>
>>>> Do you have the problem, wenn Mysql is running on local host..?
>>>>
>>>> On my systems it's only on the client in the network...
>>>>
>>>> Am 20.07.2019 20:34, schrieb Tim Camp:
>>>>
>>>> Greetings,
>>>> I have found slow sql performance with Rivendell 3 on both
>>>> Debian 9 and Ubuntu 18.04. As of yet I have not figured out
>>>> the culprit for this. Installing 2.19.3 on either distro does
>>>> not exhibit this behavior.
>>>> This is the same with MySQL or Maria db.
>>>>
>>>> I would be happy to have someone find a solution as this will
>>>> keep me from moving version 3 into production.
>>>>
>>>> Initially I thought it was a problem with the distro, maybe
>>>> it still is, but then I discovered that 2.19.3 does work fine
>>>> although it did seem a little bit slower than on Ubuntu
>>>> 14.04.
>>>>
>>>> After experiencing this on Ubuntu I then tried Debian 9 with
>>>> same issue.
>>>> Perhaps Debian and by extension Ubuntu have changed something
>>>> that is causing this however there is the big performance
>>>> difference between rivendell 2 and 3.
>>>>
>>>> All the testing I did was with a networked stand alone MySQL
>>>> server. Then just to see I installed the server locally with
>>>> same results.
>>>>
>>>> Really shows a slow down when loading a new days log chain,
>>>> can take anywhere from 8 to 20 seconds for the log to load
>>>> and begin play.
>>>>
>>>> I have exhausted my knowledge trying to figure this out. Need
>>>> a sql expert to tackle this.
>>>>
>>>> Cheers
>>>>
>>>> Tim Camp
>>>> WZEW-FM
>>>> Mobile, Al.
>>>>
>>>>
>>>> On Sat, Jul 20, 2019, 1:03 PM Schwoon, newsletter
>>>> <newslet...@schwoon.info <mailto:newslet...@schwoon.info>>
>>>> wrote:
>>>>
>>>> Hi
>>>>
>>>> I've installed the latest 3.x release on Debian 9.
>>>> The server is running inside a KVM virtual machine
>>>> without any problem.
>>>> Just like the server for the 2.x system. I've opened the
>>>> mariaDB Server
>>>> to the local network with changing the bind address line
>>>> to 0.0.0.0. The
>>>> audio ist shared with NFS.
>>>>
>>>> Then i installed on a physical machine the first rd3
>>>> client. It looks
>>>> very good. But it seems that the SQL connection is very
>>>> small. Changing
>>>> the "show only the 1st.100 Carts" to show all in
>>>> rdlibrary takes one
>>>> minute. Open the "edit marker" dialog, too.
>>>>
>>>> The network is a switched 1GB/s lan, all clients are
>>>> connected to the
>>>> same switch.
>>>>
>>>> Does anybody know how to improve the SQL speed.? Do i
>>>> have made an error
>>>> in the sql config.?
>>>>
>>>> While writing these lines, i let play a cart in the
>>>> "marker edit"
>>>> dialog. And every ~30 seconds the VU and the curser
>>>> inside the waveform
>>>> stops moving. Thats curious... The music plays fine...
>>>>
>>>>
>>>> --
>>>> Rüdiger
>>>> _______________________________________________
>>>> Rivendell-dev mailing list
>>>> Rivendell-dev@lists.rivendellaudio.org
>>>> <mailto:Rivendell-dev@lists.rivendellaudio.org>
>>>>
>>>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
>>>>
>>>> _______________________________________________
>>>> Rivendell-dev mailing list
>>>> Rivendell-dev@lists.rivendellaudio.org
>>>> <mailto: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
> _______________________________________________
> 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
--
Tim Camp
Director of Operations/Programming
Dot Com Plus L.L.C.
dba WZEW-FM WNSP-FM
Mobile, Al._______________________________________________
Rivendell-dev mailing list
Rivendell-dev@lists.rivendellaudio.org
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
