<br><br><div class="gmail_quote">On Dec 9, 2007 11:03 AM, Chris Isip <<a href="mailto:cmisipster@gmail.com">cmisipster@gmail.com</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br><br><div class="gmail_quote"><div><div></div><div class="Wj3C7c">On Dec 4, 2007 10:37 PM, Brad DerManouelian <<a href="mailto:myth@dermanouelian.com" target="_blank">myth@dermanouelian.com</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div></div><div>On Dec 4, 2007, at 6:55 PM, Chris Isip wrote:<br><br>> I think my version of mysql has a memory leak. I upgraded to 5.0.27<br>> which should hopefully fix the problem. Just in case it doesn't, I
<br>> will need to restart mysql every now and then. I'd put it in a cron<br>> job but I am not sure how this will affect the running mythtv.<br>> There doesn't seem to be any immediate consequences. I thought I'd
<br>> ask the question in the subject of this post.<br>><br>> Thanks<br>> Chris<br><br></div></div>Check the state of your backend with mythshutdown so it only restarts<br>mysql when the backend is idle to avoid any mess you might create by
<br>restarting while it's doing something.<br>Of course the real answer is to downgrade mysql to a known good one if<br>the newer version has a problem. :)<br><br>_______________________________________________<br>mythtv-users mailing list
<br><a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
</a></blockquote>
</div></div><div><br>I am trying to put together a bash script for this. It seems that i need to check for the exit code. I am finding out that mythshutdown is reporting 0 or Idle when in fact mythbackend is recording live tv. Is this normal behavior?
<br><br>Thanks<br>Chris</div></div></blockquote><div><br> I found out about the inuseprograms table. It seems mythshutdown can tell me if there is an active Transcoding, Commercial Flagging, EPG download. inuseprograms table can tell me if there is an active Recording, Playback(from a frontend, but no check for connected frontends), Commercial Flagging, but does not detect any Transcoding process.
<br><br>I will write my mysql restart script based on information from both the inuseprograms table and mythshutdown. Hopefully this covers all the things I need to check for before doing a mysql restart. If anybody has further information such as whatever else I need to check or tips on writing the script, please let me know. In particular, I am still trying to figure out how I could guarantee that mysqld is restarted at least once a day (Since it will not restart mysql at the appointed cron time if certain conditions are not met).
<br><br>Thanks<br>Chris<br><br><br><br></div></div><br>