Re: [RDD] Slow SQL performance

2019-09-01 Thread Schwoon, newsletter
kelijk 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. > >

Re: [RDD] Slow SQL performance

2019-07-28 Thread Rick
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

Re: [RDD] Slow SQL performance

2019-07-28 Thread Schwoon, newsletter
: > 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

Re: [RDD] Slow SQL performance

2019-07-28 Thread 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

Re: [RDD] Slow SQL performance

2019-07-21 Thread ermina
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

Re: [RDD] Slow SQL performance

2019-07-21 Thread Schwoon, newsletter
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

Re: [RDD] Slow SQL performance

2019-07-21 Thread 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

Re: [RDD] Slow SQL performance

2019-07-21 Thread Schwoon, newsletter
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

Re: [RDD] Slow SQL performance

2019-07-20 Thread Schwoon, newsletter
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