[mythtv-users] Problem with latest run of optimize_mythdb.pl

[Hika van den Hoven]

Hoi Jerome,

Monday, December 28, 2015, 9:05:02 PM, you wrote:

> On Monday, December 28, 2015 01:51:19 PM Stephen Worthington wrote:
>> 
>> Check the free space on your drives.  One reason for
>> optimize_mythdb.pl crashing like that with the *.tmm files open is if
>> it runs out of space writing the *.tmm file, or another temporary file
>> while the *.tmm file is big.  Since recordedseek is normally larger
>> than the rest of the database put together, that is the table it will
>> crash on if the space is too low.

> Just how robust is MySQL at handling a major table rewrite like
> this on a live database? I see it's available in 0.27.5 and I wonder
> if I have to alter the twice-weekly cron-and-forget way I use it now
> (without the defraggng) or I can just drop it in and it will play
> nice with an active backend that might be recording at any time of the day.

I don't have the answer to your question, but those scripts I run at
night. 4:10 the backup 5:30 optimize and 5:50 my grabber starts, being
ready around 7. Maybe once a year or less I'm recording at those
times!
Like on every IT system, the night is for maintenance!

Tot mails,
  Hika                            mailto:hikavdh at gmail.com

"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"

De lerende Mens