[mythtv-users] Question about mythfilldatabase?

[Michael T. Dean]

On 10/22/2009 07:51 PM, David Brodbeck wrote:
> Jim Stichnoth wrote:
>> I can't use the setting where SD decides when to run mythfilldatabase,
>> because invariably it would choose primetime when 2 or 3 simultaneous
>> shows were recording.  The resulting DB accesses thrash the disk, and
>> since one of my storage groups is on the same disk as the DB, I would
>> end up with several minutes of video dropouts and a vastly reduced
>> WAF.
>>
>> As a result, I use the setting that picks a random time within a
>> reasonably wide window.  Not a cron job though.  It would be really
>> nice if SD would take my constraints into account when it makes its
>> suggestion.  I would ask it to blackout the 7pm-11pm window.
> Yeah, I have basically the same issue.  Even with the database on a 
> different spindle, the CPU usage during a mythfilldatabase run is 
> quite significant and causes hiccups if I let it run during primetime 
> -- which it almost always seemed to pick, left to its own devices.  
> Renicing mythfilldatabase doesn't help because a lot of the CPU usage 
> comes from mysql. 

You still can use the suggested time.

http://www.gossamer-threads.com/lists/mythtv/users/403815#403815

Perhaps one of you who actually goes to the trouble of setting it up 
will post the script and specific instructions.

Mike