[mythtv-users] Any ideas how to make my hard drive shut up?
Michael T. Dean
mtdean at thirdcontact.com
Tue Jun 6 22:54:39 UTC 2006
On 06/06/2006 07:31 AM, Richard Bronosky wrote:
>Yeah, I saw that, and considered that. If it comes to that, I would
>really prefer to change the logging so that the SELECT statements
>don't get logged, but the data modifying statements do.
>
>It seems that the table recordedmarkup is getting INSERT statements in
>groups of 60 every 10-15 seconds along with SELECTs and UPDATEs
>from/to jobqueue. So, this probably during commercial flagging.
>
>
Actually, if you're recording MPEG-2 streams (i.e. from a PVR-x50/500),
you'll write around 2 records per second into the recordedmarkup table.
That table is used to store the "seektable" information, which includes
every keyframe in MPEG-2 videos, where PVR-x50's generally use one
keyframe per group of 15 pictures.
>I guess that I'd like to configure mythtv to suspend flagging jobs
>during playback. I have it set to flag during recording, but it is
>really annoying during playback.
>
>
Flagging doesn't generate that much MySQL activity (although it
generates quite a bit of hard drive activity reading the recording)
compared to recording the show.
>I didn't see any way to change this. Ideas?
>
>
If MySQL is the problem, move your database to another host on the
network. Otherwise, you can't fix the problem (Myth uses MySQL as
necessary). (Although, as previously mentioned, disabling the verbose
logging of database access would probably help considerably.)
Mike
More information about the mythtv-users
mailing list