[mythtv-users] Wrong Time on Progress Bar

ray cielencki mythtv at rayslinky.com
Sat Oct 25 20:01:44 EDT 2003


>Yep, this fixed it, figured out yesterday.  A couple questions though . . .
>
>Why is it usually this database that goes bad?
>
>Is there any reason not to run mysqlcheck -r daily as part of a 
>self-maintainence routine ??
>
>Thanks,
>
>-Eric

this table is HUGE. mine has 450,000+ rows claiming 27MB (with 
relatively few recordings). probability says that it is the most 
likely to see corruption if mysqld isn't shutdown properly. the next 
biggest table is the program table, holding all the guide data for 
the week - mine has 40,000 rows (5MB).

while mysqlcheck shouldn't cause any problems if run as a part of a 
self-maintenance routine, i take the attitude of "if it ain't broke, 
don't fix it". having said this, i do regularly back up to another 
machine with mysqldump and keep around a weeks worth of dumps and 
update logs to recreate tables should anything go drastically wrong.

/rayc


More information about the mythtv-users mailing list