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
