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 <[email protected]> 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" <[email protected]> > Datum: 28-07-2019 12:30 (GMT+01:00) > Aan: [email protected] > 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 > >>> <[email protected] <mailto:[email protected]>> 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 > >>> <[email protected] <mailto:[email protected]>> > >>> 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 > >>> [email protected] > >>> <mailto:[email protected]> > >>> > >>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > >>> > >>> _______________________________________________ > >>> Rivendell-dev mailing list > >>> [email protected] > >>> <mailto:[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 > -- Tim Camp Director of Operations/Programming Dot Com Plus L.L.C. dba WZEW-FM WNSP-FM Mobile, Al.
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
