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 >> <[email protected] <mailto:[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] <mailto:[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] >> <mailto:[email protected]> >> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >> >> _______________________________________________ >> Rivendell-dev mailing list >> [email protected] >> <mailto:[email protected]> >> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev >> > > _______________________________________________ > Rivendell-dev mailing list > [email protected] > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
