Tonight my frontend/backend had a hard lockup and I had to do a Hard Reset. I was watch the commercials from the Super Bowl and was skipping ahead a lot while commercial flagging was running.
Of Course the database broke!!!!! it was still recording The Voice but that's all it had in the upcoming recordings. So I pulled up mythweb went to the tools section/ database and there they were: "Optimize Tables" "Repair Tables" and "Extended Check". I waited for a commercial stopped the recording and ran the scripts.
My Database is repaired and everything is right with the world again.
Just a question can you run those scripts while something is recording?

Thank you again to whichever MythWeb guys put that in there.

_________________
My System

I would think so since a recording really only alters the database when it starts and ends. REPAIR is really just a mysql command. The only caveat is if the server or mysql crashes during an actual repair. If it does you need to run repair again before any other app accesses the database or corruption could result.

Those links activate the command line level of those commands. There should be a cron job that runs the optimize/repair every night. I think it calls something like "optimize_mythdb".

From the MythTv wiki: .
I just set this up in my cron (crontab -e) the other day (runs every day at 4am).

Thinking about working on something fancier, log wise, but have not got around to it yet.

_________________
-Roseville, Michigan USA
LinHES R8: FE/BE, FE (x2)

Don't you already have "myth_mtc.sh" in /etc/cron.daily?
I'm quite sure I didn't set that up myself.

does myth_mtc.sh run optimize_mythdb.sh daily? Just wondering because I was thinking about setting up optimization as a daily job, but dont want to do so if it is already covered in a daily script. I looked through the code of myth_mtc.sh, but it was not clear to me if it is checking, repairing, and optimizing tables daily.

myth_mtc.py does not run optimize_mythdb.sh daily, instead it uses it's own builtin procedure that does pretty much the same thing on a daily basis.