[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