<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">2013/1/6 Michael T. Dean <span dir="ltr"><<a href="mailto:mtdean@thirdcontact.com" target="_blank">mtdean@thirdcontact.com</a>></span><br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div class="im">On 01/06/2013 02:01 PM, Jarle Thorsen wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
I have now gone through all my channels manually and removed any channel that I was not able to tune in to. I now have about 400 channels, all with EIT enabled.<br>
<br>
Every time I see the following in my backend log:<br>
<br>
2013-01-06 19:44:36.559637 I [19447/19514] Scheduler scheduler.cpp:2129 (HandleReschedule) - Reschedule requested for MATCH 0 0 0 - EITScanner<br>
<snip><br>
2013-01-06 19:46:19.206036 I [19447/19514] Scheduler scheduler.cpp:2242 (HandleReschedule) - Scheduled 304 items in 102.0 = 100.30 match + 0.35 check + 1.39 place<br>
</blockquote>
<br></div>
That's terribly bad performance. Your scheduler query should run in a few seconds. Yours is taking > 100s.<br>
<br>
Scheduler performance depends on (in addition to hardware resources--CPU and RAM--and file system--not blocking when MySQL is trying to write (due to I/O wait or things like barriers blocking until data is on the platter, versus the disk cache)) number of programs in the listings (which, itself, is generally affected by the number of channels), number of recording rules (which may match some of those programs in the listings), and number of shows in recording history.<br>
<br>
That said, this performance (unless you're running MySQL on an Atom or a PogoPlug or similar--which just isn't enough for a large, cable-sized system, especially if you're using EIT) is bad enough it's almost definitely not your rules/history. I have 17831 shows in my recorded history, 119 recording rules, but only 35 channels, and my system gives:<br>
<br>
Scheduled 517 items in 1.3 = 0.00 match + 1.25 place<br>
<br>
(2 orders of magnitude faster than your system). Therefore, I'd suggest you should look at other things. What CPU and how much RAM do you have? What file system are you using? What mount options? Do you have MySQL on the same file system (really bad) or disk (not ideal) as your recordings?</blockquote>
</div><br></div><div class="gmail_extra">My machine is an Intel(R) Core(TM)2 Duo CPU E6750 @ 2.66GHz with 3GB RAM (only 2GB used at the moment). My root filesystem and MySQL db is running on a separate disk with ext3 filesystem. Storage is all running on separate disks with xfs filesystem.<br>
<br></div><div class="gmail_extra">The oldrecorded table contains 12531 entries, and the record table contains 189 entries.<br><br></div><div class="gmail_extra">I noticed that my root ext3 filesystem was mounted with relatime, remounted it with noatime, but this did not seem to help.<br>
<br></div><div class="gmail_extra">Suggestions for further settings to check are appreciated.<br clear="all"></div><div class="gmail_extra"><br>-- <br>Jarle Thorsen
</div></div>