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
HiThe 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
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