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