[mythtv-users] Is it safe to restart mysql with mythbackend running?

[Chris Isip]

On Dec 9, 2007 11:03 AM, Chris Isip <cmisipster at gmail.com> wrote:

>
>
> On Dec 4, 2007 10:37 PM, Brad DerManouelian <myth at dermanouelian.com>
> wrote:
>
> > On Dec 4, 2007, at 6:55 PM, Chris Isip wrote:
> >
> > > I think my version of mysql has a memory leak.  I upgraded to 5.0.27
> > > which should hopefully fix the problem.  Just in case it doesn't, I
> > > will need to restart mysql every now and then.  I'd put it in a cron
> > > job but I am not sure how this will affect the running mythtv.
> > > There doesn't seem to be any immediate consequences.   I thought I'd
> > > ask the question in the subject of this post.
> > >
> > > Thanks
> > > Chris
> >
> > Check the state of your backend with mythshutdown so it only restarts
> > mysql when the backend is idle to avoid any mess you might create by
> > restarting while it's doing something.
> > Of course the real answer is to downgrade mysql to a known good one if
> > the newer version has a problem. :)
> >
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
> 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?
>
> Thanks
> Chris
>

   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.

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).

Thanks
Chris
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20071209/e13158aa/attachment.htm