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