Reply to thread

Message

<blockquote data-quote="jerrbe" data-source="post: 346731" data-attributes="member: 85973">I did not find anything useful in the TV Server log that appeared to correlate to the spikes in CPU burden.&nbsp; I have attached a copy of the log and a jpeg of what the CPU burden is doing.&nbsp; After watching this a little closer, the TV service never gets above 5% CPU burden.&nbsp; It is the MYSQL service that is burdening the CPU.&nbsp; MYSQL is very periodic in its CPU burden it jumps to approx 25% every 20 to 30 seconds and then jumps to 100% burden every couple minutes.&nbsp; All of that CPU burden goes away when I disable the TVserver because that is the only thing I am using Mysql for at the moment.I started playing with the TV server, disabling plugins, etc to see if anything made the periodic burden go away.&nbsp; The change that made a difference was scheduled recordings.&nbsp; As soon as I deleted all scheduled recordings this issue went away.&nbsp; When I add them back the periodic burden comes back.After a little more digging on the internet I found a way to make the MYSQL service run at a lower priority.&nbsp; This was not as easy as it should have been.&nbsp; I had to download a freeware utility for changing the priority of mysql from <a href="http://www.beyondlogic.org/solutions/processutil/processutil.htm" target="_blank">Command Line Process Viewer/Killer/Suspender for Windows NT/2000/XP</a> and then create a batch script that runs at log-on to adjust the priority every time my computer boots.&nbsp; The batch script looked like this:net start mysqlprocess -p mysqld lowThe net start command was required to ensure the service started before the scheduled task ran.&nbsp; Changing the priority seems to have solved the jumpy video playback at least for the moment.&nbsp; I wonder what would happen if I switched back to the microsoft SQL server instead of using Mysql??If anyone has an explanation for exactly why this was happening I would love to hear it...</blockquote>

[QUOTE="jerrbe, post: 346731, member: 85973"] I did not find anything useful in the TV Server log that appeared to correlate to the spikes in CPU burden. I have attached a copy of the log and a jpeg of what the CPU burden is doing. After watching this a little closer, the TV service never gets above 5% CPU burden. It is the MYSQL service that is burdening the CPU. MYSQL is very periodic in its CPU burden it jumps to approx 25% every 20 to 30 seconds and then jumps to 100% burden every couple minutes. All of that CPU burden goes away when I disable the TVserver because that is the only thing I am using Mysql for at the moment. I started playing with the TV server, disabling plugins, etc to see if anything made the periodic burden go away. The change that made a difference was scheduled recordings. As soon as I deleted all scheduled recordings this issue went away. When I add them back the periodic burden comes back. After a little more digging on the internet I found a way to make the MYSQL service run at a lower priority. This was not as easy as it should have been. I had to download a freeware utility for changing the priority of mysql from [url=http://www.beyondlogic.org/solutions/processutil/processutil.htm]Command Line Process Viewer/Killer/Suspender for Windows NT/2000/XP[/url] and then create a batch script that runs at log-on to adjust the priority every time my computer boots. The batch script looked like this: net start mysql process -p mysqld low The net start command was required to ensure the service started before the scheduled task ran. Changing the priority seems to have solved the jumpy video playback at least for the moment. I wonder what would happen if I switched back to the microsoft SQL server instead of using Mysql?? If anyone has an explanation for exactly why this was happening I would love to hear it... [/QUOTE]

Verification