Re: [RDD] Painful log generating times
Hello If it possible I would like to have a look just to try to find out what is going on. Let me know contacting me directly please. Best regards Gabriele Sent from my iPhone > On 12 May 2020, at 18:23, Scott Powell wrote: > > > I have experienced the same problem log generation problems. we have 3 > stations all on different servers. All run Riv 2.10.3 on Centos 6. eventually > wanting to move to Riv 3.x Centos 7. but so far log generation has been a > hanging point. Have tried both the standalone and server install methods on > several different machines. we might get get two logs generated taking > anywhere from 20 minutes to an hour to generate. the third may never finish. > have come back the next day and it still has not completed. > > have tried mysqltuner suggestions, with and without rddbcheck before > importing into new machine. so far have not stumbled across a fix. > > I have been exporting the database through rdadmin backup, so may try > mysqldump next time. then the only thing i know to do is to run the db > through 2.19x (i have one as a standby) then try it on a 3.x install > > So Chuck and everyone I will continue to follow along and see what ideas > everyone has > > > Scott > > > > > > >> On Mon, May 11, 2020 at 9:16 AM Gabriele Fergola wrote: >> Chuck >> please try to check what is wrong with mysql and why is hanging to 97% >> login to mysql how root and do: show processlist; >> this command will show you which process is hanging. >> >> if u need more help we can arrange something to check what's wrong >> >> Regards >> >>> Il giorno lun 11 mag 2020 alle ore 15:35 Chuck >>> ha scritto: >>> Well, my understanding is that rddbcheck does not exist in v3, replaced by >>> a new GUI configuration tool, which does not include the "check"--only >>> Create, Backup, Restore, and Close. >>> >>> I've got over 50,000 carts and my database has been around 400mb for years. >>> Using rddbcheck in v2 did not reduce the size substantially. >>> >>> Tried to step back to v2 over the weekend, but the v2 appliance install did >>> not work, with the "rivendell-install" yum file missing and causing an >>> error. >>> >>> Reinstalled v3.3 appliance and now output levels to the same sound card are >>> about half what they should be (and were on the previous install), and >>> mysqld is back up at 97% CPU. Version 3 is just plain troublesome. >>> >>> --Chuck >>> >>>> On Mo, 2020-05-11 at 21:02 +1200, Geoff Barkman wrote: >>>> Hi there. >>>> I'm not familiar with rivendell 3x versions. But on rivendell 2x versions >>>> if the MySQL database got too big log creations took ages to create. Over >>>> 40 mb in a database slowed it down and a quick fix was to back up the DB >>>> and run rdbcheck to speed it up. >>>> Does that work with rivendell 3x? >>>> Just a thought. >>>> Many thanks >>>> Geoff barkman >>>> >>>> Just a thought? >>>> >>>>> On Mon, May 11, 2020, 7:17 AM Jay Schell wrote: >>>>> Where is the config file located? >>>>> >>>>> Sent from my Verizon, Samsung Galaxy smartphone >>>>> >>>>> From: rivendell-dev-boun...@lists.rivendellaudio.org >>>>> on behalf of Workino >>>>> >>>>> Sent: Sunday, May 10, 2020 2:45:15 PM >>>>> To: Chuck >>>>> Cc: rivendell-dev@lists.rivendellaudio.org >>>>> >>>>> Subject: Re: [RDD] Painful log generating times >>>>> >>>>> Hello Chuck, >>>>> The database is on the same computer? If yes the problem can be the >>>>> memory. >>>>> >>>>> If this is the case check the configuration of MySQL and the cache. If >>>>> MySQL starting to swap the answer can become slow. >>>>> >>>>> Regards >>>>> Gabriele >>>>> >>>>> Sent from my iPhone >>>>> >>>>> > On 10 May 2020, at 18:31, Chuck wrote: >>>>> > >>>>> > I am experiencing lots of problems with v3.3, and one of them is what >>>>> > you mention. However, if I generate logs immediately after rebooting, >>>>> > log creation is amazingly fast--less than 3 minutes. But if the >>>
Re: [RDD] Painful log generating times
I have experienced the same problem log generation problems. we have 3 stations all on different servers. All run Riv 2.10.3 on Centos 6. eventually wanting to move to Riv 3.x Centos 7. but so far log generation has been a hanging point. Have tried both the standalone and server install methods on several different machines. we might get get two logs generated taking anywhere from 20 minutes to an hour to generate. the third may never finish. have come back the next day and it still has not completed. have tried mysqltuner suggestions, with and without rddbcheck before importing into new machine. so far have not stumbled across a fix. I have been exporting the database through rdadmin backup, so may try mysqldump next time. then the only thing i know to do is to run the db through 2.19x (i have one as a standby) then try it on a 3.x install So Chuck and everyone I will continue to follow along and see what ideas everyone has Scott <https://twitter.com/scooterpow> On Mon, May 11, 2020 at 9:16 AM Gabriele Fergola wrote: > Chuck > please try to check what is wrong with mysql and why is hanging to 97% > login to mysql how root and do: *show processlist;* > this command will show you which process is hanging. > > if u need more help we can arrange something to check what's wrong > > Regards > > Il giorno lun 11 mag 2020 alle ore 15:35 Chuck > ha scritto: > >> Well, my understanding is that rddbcheck does not exist in v3, replaced >> by a new GUI configuration tool, which does not include the "check"--only >> Create, Backup, Restore, and Close. >> >> I've got over 50,000 carts and my database has been around 400mb for >> years. Using rddbcheck in v2 did not reduce the size substantially. >> >> Tried to step back to v2 over the weekend, but the v2 appliance install >> did not work, with the "rivendell-install" yum file missing and causing an >> error. >> >> Reinstalled v3.3 appliance and now output levels to the same sound card >> are about half what they should be (and were on the previous install), and >> mysqld is back up at 97% CPU. Version 3 is just plain troublesome. >> >> --Chuck >> >> On Mo, 2020-05-11 at 21:02 +1200, Geoff Barkman wrote: >> >> Hi there. >> I'm not familiar with rivendell 3x versions. But on rivendell 2x versions >> if the MySQL database got too big log creations took ages to create. Over >> 40 mb in a database slowed it down and a quick fix was to back up the DB >> and run rdbcheck to speed it up. >> Does that work with rivendell 3x? >> Just a thought. >> Many thanks >> Geoff barkman >> >> Just a thought? >> >> On Mon, May 11, 2020, 7:17 AM Jay Schell wrote: >> >> Where is the config file located? >> >> Sent from my Verizon, Samsung Galaxy smartphone >> >> -- >> *From:* rivendell-dev-boun...@lists.rivendellaudio.org < >> rivendell-dev-boun...@lists.rivendellaudio.org> on behalf of Workino < >> work...@gmail.com> >> *Sent:* Sunday, May 10, 2020 2:45:15 PM >> *To:* Chuck >> *Cc:* rivendell-dev@lists.rivendellaudio.org < >> rivendell-dev@lists.rivendellaudio.org> >> *Subject:* Re: [RDD] Painful log generating times >> >> Hello Chuck, >> The database is on the same computer? If yes the problem can be the >> memory. >> >> If this is the case check the configuration of MySQL and the cache. If >> MySQL starting to swap the answer can become slow. >> >> Regards >> Gabriele >> >> Sent from my iPhone >> >> > On 10 May 2020, at 18:31, Chuck wrote: >> > >> > I am experiencing lots of problems with v3.3, and one of them is what >> > you mention. However, if I generate logs immediately after rebooting, >> > log creation is amazingly fast--less than 3 minutes. But if the >> > computer has been running for an hour or so, just generating one log >> > can take up to 3 hours. Something is happening during normal operation >> > that messes things up. After the problem surfaces, database backup >> > won't work, and even the Library finally locks up. Oddly, Airplay >> > continues running through it all. Tried totally different hardware, >> > and the problem is there on both, so I doubt it is on the user end. >> > >> > --Chuck >> > >> >> On Sa, 9 May 2020 17:09:47 + >> >> Jay Schell wrote: >> >> >> >> I built a new virtualization server for hosting two Rivendell servers >> >> running compl
Re: [RDD] Painful log generating times
I found the fix. I ran via the command line rddbcheck on the V2 database. It found some orphaned rule sets and allowed me to remove them. This made the database export go from 251 MB down to 165 MB. I then imported the database on the V3 machine BUT NOT do the upgrade to 314 via the GUI. I ran via the command line rddbmg -modify to upgrade the database. I then ran rddbmgr -check and it said I needed to convert my tables from InnoDB to MYISAM format so I did that. Then I opened RDAdmin and made the some changes to accommodate the new environment. I then generated a log and it took 90 secondsyes 90 seconds! I made a second a log and it again took about 90 seconds. So far, so good. Jay Schell WLFC-FM Chief Engineer From: rivendell-dev-boun...@lists.rivendellaudio.org On Behalf Of Robert Jeffares Sent: Monday, May 11, 2020 4:19 PM To: rivendell-dev@lists.rivendellaudio.org Subject: Re: [RDD] Painful log generating times Hi Jay, Rivendell has always been slow to construct logs on any platform despite ram and fast drives for the OS and with space for the scratch files which are not stored in virtual ram. Big library, lots of scheduler codes, lots of events, scheduler rules, many clocks. I have a small system [3000 audio tracks] which can make a log in 5 minutes, and a big system [80,000 audio tracks] which takes an hour to create a log. Since the hour is at 1am and I am doing drum and bass in my bed it does not bother me. The processing time is taken up by MySQL. Looking at system demand when I create a log RDLOGMANAGER is hogging CPU at 80% or so which can be tweaked. I have just looked at this and can see some rewarding long winter nights. Yes it is a pain when you need to unschedule/reschedule after a Clock/Event change. Fortunately we work ahead enough to be able to keep this to a minimum and I have some clever setups that enable me to drop new stuff in once an hour. Yes it's long compared to 'on the fly' scheduling systems, and one Windows based system which markets itself on the speed of log creation. I have clients who have, or have had these other systems, and they just don't do all the stuff Rivendell does. I can live with the overhead. You can use a dedicated external music scheduler. My winter project will be to explore MySQL and MariaDB and see what can be done. regards Robert On 10/05/20 5:09 am, Jay Schell wrote: I built a new virtualization server for hosting two Rivendell servers running completely different stations and audio libraries. The new servers are version 3 but generating logs is taking FOREVER, I am talking almost an hour to make one log. This is on an imported v2 database. Any thoughts on what might be wrong? The new server has lots of RAM and processing speed so I wonder if it is a database issue or hard drive performance issue. Jay Schell WLFC-FM Engineer ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org<mailto:Rivendell-dev@lists.rivendellaudio.org> http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev -- Communication Consultants 2020 Limited 64 Warner Park Avenue Laingholm Auckland 0604 New Zealand ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
Re: [RDD] Painful log generating times
Hi Jay, Rivendell has always been slow to construct logs on any platform despite ram and fast drives for the OS and with space for the scratch files which are not stored in virtual ram. Big library, lots of scheduler codes, lots of events, scheduler rules, many clocks. I have a small system [3000 audio tracks] which can make a log in 5 minutes, and a big system [80,000 audio tracks] which takes an hour to create a log. Since the hour is at 1am and I am doing drum and bass in my bed it does not bother me. The processing time is taken up by MySQL. Looking at system demand when I create a log RDLOGMANAGER is hogging CPU at 80% or so which can be tweaked. I have just looked at this and can see some rewarding long winter nights. Yes it is a pain when you need to unschedule/reschedule after a Clock/Event change. Fortunately we work ahead enough to be able to keep this to a minimum and I have some clever setups that enable me to drop new stuff in once an hour. Yes it's long compared to 'on the fly' scheduling systems, and one Windows based system which markets itself on the speed of log creation. I have clients who have, or have had these other systems, and they just don't do all the stuff Rivendell does. I can live with the overhead. You can use a dedicated external music scheduler. My winter project will be to explore MySQL and MariaDB and see what can be done. regards Robert On 10/05/20 5:09 am, Jay Schell wrote: I built a new virtualization server for hosting two Rivendell servers running completely different stations and audio libraries. The new servers are version 3 but generating logs is taking FOREVER, I am talking almost an hour to make one log. This is on an imported v2 database. Any thoughts on what might be wrong? The new server has lots of RAM and processing speed so I wonder if it is a database issue or hard drive performance issue. Jay Schell WLFC-FM Engineer ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev -- Communication Consultants 2020 Limited 64 Warner Park Avenue Laingholm Auckland 0604 New Zealand ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
Re: [RDD] Painful log generating times
Thanks Gabriele and David. I'm away from the computers for the rest of today, but will take it back up tomorrow. I'm in creative and not IT, and really want to go back to v2. I need things to just work, and v2 did. There are many operational features of v3 that make it a click-fest--for one thing, by picking "No" to confirmation dialogs when 99% of the time the real answer is "Yes"; v2 had the right choice as default. Stepping through fields with tab is no longer in sequential order in various places; Edit Markers blows through Cut End without stopping, so trimming the end marker is impossible; and that's just a few problems that make v3 just too operationally difficult. I'll take v2, please. --Chuck On Mo, 2020-05-11 at 16:15 +0200, Gabriele Fergola wrote: > Chuckplease try to check what is wrong with mysql and why is hanging > to 97% > login to mysql how root and do: show processlist; > this command will show you which process is hanging. > > if u need more help we can arrange something to check what's wrong > > Regards > > Il giorno lun 11 mag 2020 alle ore 15:35 Chuck < > dj.chuc...@googlemail.com> ha scritto: > > Well, my understanding is that rddbcheck does not exist in v3, > > replaced by a new GUI configuration tool, which does not include > > the "check"--only Create, Backup, Restore, and Close. > > I've got over 50,000 carts and my database has been around 400mb > > for years. Using rddbcheck in v2 did not reduce the size > > substantially. > > Tried to step back to v2 over the weekend, but the v2 appliance > > install did not work, with the "rivendell-install" yum file missing > > and causing an error. > > Reinstalled v3.3 appliance and now output levels to the same > > sound card are about half what they should be (and were on the > > previous install), and mysqld is back up at 97% CPU. Version 3 is > > just plain troublesome. > > --Chuck > > On Mo, 2020-05-11 at 21:02 +1200, Geoff Barkman wrote: > > > Hi there. I'm not familiar with rivendell 3x versions. But on > > > rivendell 2x versions if the MySQL database got too big log > > > creations took ages to create. Over 40 mb in a database slowed it > > > down and a quick fix was to back up the DB and run rdbcheck to > > > speed it up. Does that work with rivendell 3x? > > > Just a thought. > > > Many thanks > > > Geoff barkman > > > > > > Just a thought? > > > On Mon, May 11, 2020, 7:17 AM Jay Schell > > > wrote: > > > > > > > > > > > > > > > > > > > > Where is the config file located? > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Sent from my Verizon, Samsung Galaxy smartphone > > > > > > > > > > > > > > > > > > > > From: rivendell-dev-boun...@lists.rivendellaudio.org < > > > > rivendell-dev-boun...@lists.rivendellaudio.org> on behalf of > > > > Workino > > > > > > > > Sent: Sunday, May 10, 2020 2:45:15 PM > > > > > > > > To: Chuck > > > > > > > > Cc: rivendell-dev@lists.rivendellaudio.org < > > > > rivendell-dev@lists.rivendellaudio.org> > > > > > > > > Subject: Re: [RDD] Painful log generating times > > > > > > > > > > > > > > > > Hello Chuck, > > > > > > > > The database is on the same computer? If yes the problem can be > > > > the memory. > > > > > > > > > > > > > > > > If this is the case check the configuration of MySQL and the > > > > cache. If MySQL starting to swap the answer can become slow. > > > > > > > > > > > > > > > > > > > > Regards > > > > > > > > Gabriele > > > > > > > > > > > > > > > > Sent from my iPhone > > > > > > > > > > > > > > > > > On 10 May 2020, at 18:31, Chuck > > > > wrote: > > > > > > > > > > > > > > > > > > I am experiencing lots of problems with v3.3, and one of > > > > them is what > > > > > > > > > you mention. However, if I generate logs immediately after > > > > rebooting, > > > > > > > > >
Re: [RDD] Painful log generating times
Chuck please try to check what is wrong with mysql and why is hanging to 97% login to mysql how root and do: *show processlist;* this command will show you which process is hanging. if u need more help we can arrange something to check what's wrong Regards Il giorno lun 11 mag 2020 alle ore 15:35 Chuck ha scritto: > Well, my understanding is that rddbcheck does not exist in v3, replaced by > a new GUI configuration tool, which does not include the "check"--only > Create, Backup, Restore, and Close. > > I've got over 50,000 carts and my database has been around 400mb for > years. Using rddbcheck in v2 did not reduce the size substantially. > > Tried to step back to v2 over the weekend, but the v2 appliance install > did not work, with the "rivendell-install" yum file missing and causing an > error. > > Reinstalled v3.3 appliance and now output levels to the same sound card > are about half what they should be (and were on the previous install), and > mysqld is back up at 97% CPU. Version 3 is just plain troublesome. > > --Chuck > > On Mo, 2020-05-11 at 21:02 +1200, Geoff Barkman wrote: > > Hi there. > I'm not familiar with rivendell 3x versions. But on rivendell 2x versions > if the MySQL database got too big log creations took ages to create. Over > 40 mb in a database slowed it down and a quick fix was to back up the DB > and run rdbcheck to speed it up. > Does that work with rivendell 3x? > Just a thought. > Many thanks > Geoff barkman > > Just a thought? > > On Mon, May 11, 2020, 7:17 AM Jay Schell wrote: > > Where is the config file located? > > Sent from my Verizon, Samsung Galaxy smartphone > > -- > *From:* rivendell-dev-boun...@lists.rivendellaudio.org < > rivendell-dev-boun...@lists.rivendellaudio.org> on behalf of Workino < > work...@gmail.com> > *Sent:* Sunday, May 10, 2020 2:45:15 PM > *To:* Chuck > *Cc:* rivendell-dev@lists.rivendellaudio.org < > rivendell-dev@lists.rivendellaudio.org> > *Subject:* Re: [RDD] Painful log generating times > > Hello Chuck, > The database is on the same computer? If yes the problem can be the > memory. > > If this is the case check the configuration of MySQL and the cache. If > MySQL starting to swap the answer can become slow. > > Regards > Gabriele > > Sent from my iPhone > > > On 10 May 2020, at 18:31, Chuck wrote: > > > > I am experiencing lots of problems with v3.3, and one of them is what > > you mention. However, if I generate logs immediately after rebooting, > > log creation is amazingly fast--less than 3 minutes. But if the > > computer has been running for an hour or so, just generating one log > > can take up to 3 hours. Something is happening during normal operation > > that messes things up. After the problem surfaces, database backup > > won't work, and even the Library finally locks up. Oddly, Airplay > > continues running through it all. Tried totally different hardware, > > and the problem is there on both, so I doubt it is on the user end. > > > > --Chuck > > > >> On Sa, 9 May 2020 17:09:47 + > >> Jay Schell wrote: > >> > >> I built a new virtualization server for hosting two Rivendell servers > >> running completely different stations and audio libraries. The new > >> servers are version 3 but generating logs is taking FOREVER, I am > >> talking almost an hour to make one log. This is on an imported v2 > >> database. Any thoughts on what might be wrong? The new server has > >> lots of RAM and processing speed so I wonder if it is a database > >> issue or hard drive performance issue. > >> > >> Jay Schell > >> WLFC-FM Engineer > > > > > > ___ > > 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 > > ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
Re: [RDD] Painful log generating times
Hey Chuck, On 5/11/20 8:35 AM, you wrote: Well, my understanding is that rddbcheck does not exist in v3, replaced by a new GUI configuration tool, which does not include the "check"--only Create, Backup, Restore, and Close. I"m not sure this will help, but there *is* an equivalent in 3.X: rddbmgr. It's even got a manual page: "man rddbmgr" for more details. I've got over 50,000 carts and my database has been around 400mb for years. Using rddbcheck in v2 did not reduce the size substantially. Concur. Cleaning up the database with rddbmgr probably won't help much to decrease the time spent creating logs. Tried to step back to v2 over the weekend, but the v2 appliance install did not work, with the "rivendell-install" yum file missing and causing an error. Reinstalled v3.3 appliance and now output levels to the same sound card are about half what they should be (and were on the previous install), and mysqld is back up at 97% CPU. Version 3 is just plain troublesome. MySQL (and MariaDB) is a complex beast. I suspect this may be your problem, not Rivendell proper. Take a look at some of the documentation on the MySQL website or the knowledge base articles at https://mariadb.com/kb/en/optimization-and-tuning/ For example, you can see what MySQL/MariaDB is up to with the "show full processlist" command in the command line app "mysql". It's difficult to troubleshoot database problems via email: feel free to contact me off list if you want more specific help. ~David Klann ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
Re: [RDD] Painful log generating times
Well, my understanding is that rddbcheck does not exist in v3, replaced by a new GUI configuration tool, which does not include the "check"--only Create, Backup, Restore, and Close. I've got over 50,000 carts and my database has been around 400mb for years. Using rddbcheck in v2 did not reduce the size substantially. Tried to step back to v2 over the weekend, but the v2 appliance install did not work, with the "rivendell-install" yum file missing and causing an error. Reinstalled v3.3 appliance and now output levels to the same sound card are about half what they should be (and were on the previous install), and mysqld is back up at 97% CPU. Version 3 is just plain troublesome. --Chuck On Mo, 2020-05-11 at 21:02 +1200, Geoff Barkman wrote: > Hi there. I'm not familiar with rivendell 3x versions. But on > rivendell 2x versions if the MySQL database got too big log creations > took ages to create. Over 40 mb in a database slowed it down and a > quick fix was to back up the DB and run rdbcheck to speed it up. Does > that work with rivendell 3x? > Just a thought. > Many thanks > Geoff barkman > > Just a thought? > On Mon, May 11, 2020, 7:17 AM Jay Schell wrote: > > > > > > > > > > Where is the config file located? > > > > > > > > > > > > > > > > Sent from my Verizon, Samsung Galaxy smartphone > > > > > > > > > > From: rivendell-dev-boun...@lists.rivendellaudio.org < > > rivendell-dev-boun...@lists.rivendellaudio.org> on behalf of > > Workino > > > > Sent: Sunday, May 10, 2020 2:45:15 PM > > > > To: Chuck > > > > Cc: rivendell-dev@lists.rivendellaudio.org < > > rivendell-dev@lists.rivendellaudio.org> > > > > Subject: Re: [RDD] Painful log generating times > > > > > > > > Hello Chuck, > > > > The database is on the same computer? If yes the problem can be the > > memory. > > > > > > > > If this is the case check the configuration of MySQL and the cache. > > If MySQL starting to swap the answer can become slow. > > > > > > > > > > Regards > > > > Gabriele > > > > > > > > Sent from my iPhone > > > > > > > > > On 10 May 2020, at 18:31, Chuck > > wrote: > > > > > > > > > > I am experiencing lots of problems with v3.3, and one of them > > is what > > > > > you mention. However, if I generate logs immediately after > > rebooting, > > > > > log creation is amazingly fast--less than 3 minutes. But if the > > > > > computer has been running for an hour or so, just generating one > > log > > > > > can take up to 3 hours. Something is happening during normal > > operation > > > > > that messes things up. After the problem surfaces, database > > backup > > > > > won't work, and even the Library finally locks up. Oddly, > > Airplay > > > > > continues running through it all. Tried totally different > > hardware, > > > > > and the problem is there on both, so I doubt it is on the user > > end. > > > > > > > > > > --Chuck > > > > > > > > > >> On Sa, 9 May 2020 17:09:47 + > > > > >> Jay Schell wrote: > > > > >> > > > > >> I built a new virtualization server for hosting two Rivendell > > servers > > > > >> running completely different stations and audio libraries. The > > new > > > > >> servers are version 3 but generating logs is taking FOREVER, I > > am > > > > >> talking almost an hour to make one log. This is on an imported > > v2 > > > > >> database. Any thoughts on what might be wrong? The new server > > has > > > > >> lots of RAM and processing speed so I wonder if it is a database > > > > >> issue or hard drive performance issue. > > > > >> > > > > >> Jay Schell > > > > >> WLFC-FM Engineer > > > > > > > > > > > > > > > ___ > > > > > 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 > > ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
Re: [RDD] Painful log generating times
Hi there. I'm not familiar with rivendell 3x versions. But on rivendell 2x versions if the MySQL database got too big log creations took ages to create. Over 40 mb in a database slowed it down and a quick fix was to back up the DB and run rdbcheck to speed it up. Does that work with rivendell 3x? Just a thought. Many thanks Geoff barkman Just a thought? On Mon, May 11, 2020, 7:17 AM Jay Schell wrote: > Where is the config file located? > > Sent from my Verizon, Samsung Galaxy smartphone > > -- > *From:* rivendell-dev-boun...@lists.rivendellaudio.org < > rivendell-dev-boun...@lists.rivendellaudio.org> on behalf of Workino < > work...@gmail.com> > *Sent:* Sunday, May 10, 2020 2:45:15 PM > *To:* Chuck > *Cc:* rivendell-dev@lists.rivendellaudio.org < > rivendell-dev@lists.rivendellaudio.org> > *Subject:* Re: [RDD] Painful log generating times > > Hello Chuck, > The database is on the same computer? If yes the problem can be the > memory. > > If this is the case check the configuration of MySQL and the cache. If > MySQL starting to swap the answer can become slow. > > Regards > Gabriele > > Sent from my iPhone > > > On 10 May 2020, at 18:31, Chuck wrote: > > > > I am experiencing lots of problems with v3.3, and one of them is what > > you mention. However, if I generate logs immediately after rebooting, > > log creation is amazingly fast--less than 3 minutes. But if the > > computer has been running for an hour or so, just generating one log > > can take up to 3 hours. Something is happening during normal operation > > that messes things up. After the problem surfaces, database backup > > won't work, and even the Library finally locks up. Oddly, Airplay > > continues running through it all. Tried totally different hardware, > > and the problem is there on both, so I doubt it is on the user end. > > > > --Chuck > > > >> On Sa, 9 May 2020 17:09:47 + > >> Jay Schell wrote: > >> > >> I built a new virtualization server for hosting two Rivendell servers > >> running completely different stations and audio libraries. The new > >> servers are version 3 but generating logs is taking FOREVER, I am > >> talking almost an hour to make one log. This is on an imported v2 > >> database. Any thoughts on what might be wrong? The new server has > >> lots of RAM and processing speed so I wonder if it is a database > >> issue or hard drive performance issue. > >> > >> Jay Schell > >> WLFC-FM Engineer > > > > > > ___ > > 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 > ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
Re: [RDD] Painful log generating times
I am a creative and definitely not very IT savy, but must maintain my own installation. Hardware is Lenovo S340 laptop. Just checked top and it showed mysqld at 97% CPU. Rebooted and it went to 0.1%. 30 minutes later it is back to 97%, and doing the wonky long log generation. Nearly 6gb of RAM free out of 8gb. No swap use at all. --Chuck On Su, 2020-05-10 at 19:17 +, Jay Schell wrote: > Where is the config file located? > > > > > > > > Sent from my Verizon, Samsung Galaxy smartphone > > > > > From: rivendell-dev-boun...@lists.rivendellaudio.org < > rivendell-dev-boun...@lists.rivendellaudio.org> on behalf of Workino > > > Sent: Sunday, May 10, 2020 2:45:15 PM > > To: Chuck > > Cc: rivendell-dev@lists.rivendellaudio.org < > rivendell-dev@lists.rivendellaudio.org> > > Subject: Re: [RDD] Painful log generating times > > > > Hello Chuck, > > The database is on the same computer? If yes the problem can be the > memory. > > > > If this is the case check the configuration of MySQL and the cache. > If MySQL starting to swap the answer can become slow. > > > > > Regards > > Gabriele > > > > Sent from my iPhone > > > > > On 10 May 2020, at 18:31, Chuck wrote: > > > > > > I am experiencing lots of problems with v3.3, and one of them is > what > > > you mention. However, if I generate logs immediately after > rebooting, > > > log creation is amazingly fast--less than 3 minutes. But if the > > > computer has been running for an hour or so, just generating one > log > > > can take up to 3 hours. Something is happening during normal > operation > > > that messes things up. After the problem surfaces, database backup > > > won't work, and even the Library finally locks up. Oddly, Airplay > > > continues running through it all. Tried totally different > hardware, > > > and the problem is there on both, so I doubt it is on the user end. > > > > > > --Chuck > > > > > >> On Sa, 9 May 2020 17:09:47 + > > >> Jay Schell wrote: > > >> > > >> I built a new virtualization server for hosting two Rivendell > servers > > >> running completely different stations and audio libraries. The new > > >> servers are version 3 but generating logs is taking FOREVER, I am > > >> talking almost an hour to make one log. This is on an imported v2 > > >> database. Any thoughts on what might be wrong? The new server has > > >> lots of RAM and processing speed so I wonder if it is a database > > >> issue or hard drive performance issue. > > >> > > >> Jay Schell > > >> WLFC-FM Engineer > > > > > > > > > ___ > > > 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] Painful log generating times
Where is the config file located? Sent from my Verizon, Samsung Galaxy smartphone From: rivendell-dev-boun...@lists.rivendellaudio.org on behalf of Workino Sent: Sunday, May 10, 2020 2:45:15 PM To: Chuck Cc: rivendell-dev@lists.rivendellaudio.org Subject: Re: [RDD] Painful log generating times Hello Chuck, The database is on the same computer? If yes the problem can be the memory. If this is the case check the configuration of MySQL and the cache. If MySQL starting to swap the answer can become slow. Regards Gabriele Sent from my iPhone > On 10 May 2020, at 18:31, Chuck wrote: > > I am experiencing lots of problems with v3.3, and one of them is what > you mention. However, if I generate logs immediately after rebooting, > log creation is amazingly fast--less than 3 minutes. But if the > computer has been running for an hour or so, just generating one log > can take up to 3 hours. Something is happening during normal operation > that messes things up. After the problem surfaces, database backup > won't work, and even the Library finally locks up. Oddly, Airplay > continues running through it all. Tried totally different hardware, > and the problem is there on both, so I doubt it is on the user end. > > --Chuck > >> On Sa, 9 May 2020 17:09:47 + >> Jay Schell wrote: >> >> I built a new virtualization server for hosting two Rivendell servers >> running completely different stations and audio libraries. The new >> servers are version 3 but generating logs is taking FOREVER, I am >> talking almost an hour to make one log. This is on an imported v2 >> database. Any thoughts on what might be wrong? The new server has >> lots of RAM and processing speed so I wonder if it is a database >> issue or hard drive performance issue. >> >> Jay Schell >> WLFC-FM Engineer > > > ___ > 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] Painful log generating times
Hello Chuck, The database is on the same computer? If yes the problem can be the memory. If this is the case check the configuration of MySQL and the cache. If MySQL starting to swap the answer can become slow. Regards Gabriele Sent from my iPhone > On 10 May 2020, at 18:31, Chuck wrote: > > I am experiencing lots of problems with v3.3, and one of them is what > you mention. However, if I generate logs immediately after rebooting, > log creation is amazingly fast--less than 3 minutes. But if the > computer has been running for an hour or so, just generating one log > can take up to 3 hours. Something is happening during normal operation > that messes things up. After the problem surfaces, database backup > won't work, and even the Library finally locks up. Oddly, Airplay > continues running through it all. Tried totally different hardware, > and the problem is there on both, so I doubt it is on the user end. > > --Chuck > >> On Sa, 9 May 2020 17:09:47 + >> Jay Schell wrote: >> >> I built a new virtualization server for hosting two Rivendell servers >> running completely different stations and audio libraries. The new >> servers are version 3 but generating logs is taking FOREVER, I am >> talking almost an hour to make one log. This is on an imported v2 >> database. Any thoughts on what might be wrong? The new server has >> lots of RAM and processing speed so I wonder if it is a database >> issue or hard drive performance issue. >> >> Jay Schell >> WLFC-FM Engineer > > > ___ > 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] Painful log generating times
I am experiencing lots of problems with v3.3, and one of them is what you mention. However, if I generate logs immediately after rebooting, log creation is amazingly fast--less than 3 minutes. But if the computer has been running for an hour or so, just generating one log can take up to 3 hours. Something is happening during normal operation that messes things up. After the problem surfaces, database backup won't work, and even the Library finally locks up. Oddly, Airplay continues running through it all. Tried totally different hardware, and the problem is there on both, so I doubt it is on the user end. --Chuck > On Sa, 9 May 2020 17:09:47 + > Jay Schell wrote: > > I built a new virtualization server for hosting two Rivendell servers > running completely different stations and audio libraries. The new > servers are version 3 but generating logs is taking FOREVER, I am > talking almost an hour to make one log. This is on an imported v2 > database. Any thoughts on what might be wrong? The new server has > lots of RAM and processing speed so I wonder if it is a database > issue or hard drive performance issue. > > Jay Schell > WLFC-FM Engineer ___ Rivendell-dev mailing list Rivendell-dev@lists.rivendellaudio.org http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
