<div dir="ltr"><div><div>I'm running 0.27, and all of my storage is locally mounted SATA disks on the backend. No NFS or even external USB disks. <br><br></div>I do have a fair number of programs recorded, but in the hundreds rather than thousands. I wouldn't think that would be enough to stress MySQL at all, but I haven't looked at the database tuning parameters. I'm pretty experienced with MySQL, so I will check those tonight.<br><br></div>I also haven't seen anything definitive in the logs, though since it's an intermittent problem, it's kind of hard to correlate the timestamps with when the problem occurs. I'll take a laptop with me when I watch TV tonight so I can ssh into the backend and frontend and look at the logs in real time while starting playback.<br><br><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Oct 6, 2014 at 6:34 AM, Tremayne, Steve <span dir="ltr"><<a href="mailto:steven.tremayne@honeywell.com" target="_blank">steven.tremayne@honeywell.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div link="blue" vlink="purple" lang="EN-GB">
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:blue">Do you have a lot of recorded shows in your list – or just a few?<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:blue"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:blue">It could be an issue with your database – for example, if there are a lot of recorded programs then when you start a show, Myth & the database need to work out
which actual file your computer is actually going to start playing.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:blue"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:blue">I am in the process of setting up a new Myth box and saw this recently:<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:blue"><a href="http://www.mythtv.org/wiki/Tune_MySQL" target="_blank">http://www.mythtv.org/wiki/Tune_MySQL</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:blue"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:blue">Just a thought…<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:blue"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:blue">Cheers,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:blue"><br>
Steve<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:blue"><u></u> <u></u></span></p>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"" lang="EN-US">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"" lang="EN-US"> <a href="mailto:mythtv-users-bounces@mythtv.org" target="_blank">mythtv-users-bounces@mythtv.org</a> [mailto:<a href="mailto:mythtv-users-bounces@mythtv.org" target="_blank">mythtv-users-bounces@mythtv.org</a>]
<b>On Behalf Of </b>Tom Wheeler<br>
<b>Sent:</b> 03 October 2014 23:27<br>
<b>To:</b> Discussion about MythTV<br>
<b>Subject:</b> [mythtv-users] How to Prevent Freeze When Starting Playback<u></u><u></u></span></p>
</div><div><div class="h5">
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">I have a combined backend/frontend and now an additional (separate) frontend, both running 0.27 on Mythbuntu. I have noticed with increasing frequency on both systems over the past several weeks that MythTV
temporarily hangs when I start playing back a previously recorded show.<u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt">To be a bit more specific, when I select the show I want to watch and click OK on my remote, playback often does not begin for a few seconds, and sometimes for as much as 45 seconds. I'd estimate that the frequency
of the delay follows this pattern:<u></u><u></u></p>
</div>
<p class="MsoNormal"> 40% - No noticeable delay at all<u></u><u></u></p>
</div>
<p class="MsoNormal"> 30% - Delay of 3 seconds or less<u></u><u></u></p>
</div>
<p class="MsoNormal"> 15% - Delay of 3-5 seconds<br>
10% - Delay of 5-10 seconds<br>
5% - Delay of 10 seconds or more<u></u><u></u></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt">What I mean by "freeze" is that it continues showing the list of programs from which I selected (the video hasn't started playing yet) and the frontend no longer responds to input from the remote. In the extreme
cases where it freezes for 20+ seconds, I start to doubt whether I'd actually hit OK in the first place, so I hit it again. Nothing happens, of course, until the program eventually starts playing and the system processes both clicks.<br>
<br>
Any idea what causes this delay and how I can eliminate it?<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks,<br>
<br>
Tom<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
</div>
</div>
</div>
</div></div></div>
</div>
<br>_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" target="_blank">https://forum.mythtv.org</a><br>
<br></blockquote></div><br></div>