[mythtv-users] ensuring mythbackend will be idle for db optimize

[Jerome Yuzyk]

I've used optimize_mythdb.pl regularly for a long time without much regard for the database being busy, because it never did more than check the DB and fortunately never found anything to repair, so it was pretty much a read-only operation.

But the latest version in 0.27.5 will defragment seektables and that means writing the DB for sure.

How will this behave while recordings are being made, processed, or watched?

Will MySQL just handle the table-locking automagically? I suspect not.

So, I think I need to find or write something that asks if the front- and backend is or will be quiet for the next N minutes, before optimizing. 

Has anyone done this already? Creative uses of MythWelcome?

-- 
A little of Jerome's MythTV World: http://mythtv.bss.ab.ca