Re: [RDD] Slow SQL performance
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
> 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"
> 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
>>>> 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 soluti
Re: [RDD] Slow SQL performance
Yes I use it on bothVerzonden vanaf mijn Samsung-apparaat
Oorspronkelijk bericht
Van: "Schwoon, newsletter"
Datum: 28-07-2019 15:38 (GMT+01:00)
Aan: Rick
Cc: rivendell-dev@lists.rivendellaudio.org
Onderwerp: Re: [RDD] Slow SQL performance
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"
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>>> 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>>>
Re: [RDD] Slow SQL performance
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"
> 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
>>>> 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.
Re: [RDD] Slow SQL performance
Install mysqltuner and follow the tips.Verzonden vanaf mijn Samsung-apparaat
Oorspronkelijk bericht
Van: "Schwoon, newsletter"
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>>> 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>>> 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.>>> J
Re: [RDD] Slow SQL performance
Hi, i think i have the same problem. Friday i just installed the 3.0.1 release on a standalone machine running Debian 10. After importing a dump of our production db (~250Mo) into MariaDB and upgrading the db to the current schema with rddbconfig, i just launched rdairplay and wanted to add a cart on a panel button. In the dialog box, unchecking "show only first 100…" did trigger a pop-up window with a progress bar and it took a good moment to display all carts. I thought maybe it was doing some sort of cache for the first time, but each subsequent search (eg. typing a letter in the search field) triggered the same behavior. The work week was over so i left it at that. My guess is that it's about a setting in the default MySQL config on Debian. If someone has a hint towards a solution, please help us :) . leo On 2019-07-20 20:04, Schwoon, newsletter 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 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 SQL performance
Fedora...? OK
If i had no trouble with my touchscreens on Centos7, i would use it.
So i have to use Debian/Ubuntu. Thats most of the time easier to get
driver
and software..
BTW. What about Centos8..? ;)
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
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
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
http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
___
Rivendell-dev mailing list
Re: [RDD] Slow SQL performance
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
>> 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
>> 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
>>
>> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
>>
>> ___
>>
Re: [RDD] Slow SQL performance
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 > 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 > 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 > 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 SQL performance
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 > 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 >> 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
