<br><br><div class="gmail_quote">On Mon, Mar 4, 2013 at 6:42 PM, Michael T. Dean <span dir="ltr"><<a href="mailto:mtdean@thirdcontact.com" target="_blank">mtdean@thirdcontact.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="im">On 02/27/2013 12:18 PM, Allen Edwards wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I have done some things and so far no problems with Myth having to double start or losing its place. I thank everyone who offered suggestions as this led to what I did. Hopefully this situation will hold but I wanted to document what I did.<br>
<br>
1) Removed years of recording rules for shows that are no longer on the air as well as duplicate rules that were entered to change record daily to record weekly and things like that. We have never done this. This removed probably 75% of the rules. I did this from MythWeb<br>
<br>
</blockquote>
<br>
<br></div>
You probably had a severely slow scheduler query run, which resulted in timeouts.<br>
<br>
To speed up the scheduler query you can:<br>
<br>
a) Remove no-longer-necessary recording rules (in mythfrontend Manage Recordings|Recording Rules--or in 0.21, you use Recording Priority)<br>
b) Remove recording history (in mythfrontend Manage Recordings|Previously Recorded)<br>
c) Remove channels (in mythtv-setup channel editor and, probably, in your listings grabber's configuration)<br>
d) Fix your mysql configuration<br>
<br>
You did a), and that likely fixed the issue. Note that I'm not saying your MySQL configuration is broken--though an Athlon X2 5400 should be able to handle MySQL pretty well--as I have no clue how many recording rules, recorded history, and channels (and, therefore, programs) you have (and note that the same channel on 2 different Video Sources is actually 2 channels), so it's possible you really did have too many for your processor to handle.<br>
<br>
Mike<div class="HOEnZb"><div class="h5"><br></div></div></blockquote><div><br></div><div>Thanks Mike, We have not had a problem since making the changes so it seems to be stable. I probably removed 80% of the recording rules. One show had about 12 rules to record it. I have no idea how that happened.</div>
<div><br></div><div>Allen </div></div>