[mythtv-users] Laggy time-seeks?

[Michael T. Dean]

On 02/08/2007 12:31 PM, Brian Wood wrote:
> On Feb 8, 2007, at 10:15 AM, Michael T. Dean wrote:
>   
>> On 02/06/2007 03:23 AM, William Pettersson wrote:
>>     
>>> Steven Adeff wrote:
>>>       
>>>> have you run optimize_mythdb.pl lately? (you should really be  
>>>> running
>>>> it once a day if your not already.)
>>>>         
>>> I hadn't, no.  On a side-note, does anyone know where Gentoo  
>>> installs this?
>>>
>>> Anyway, I found in in the tarball, and ran it.  It apparently  
>>> optimized
>>> some tables.  However, while improving performance slightly (maybe?
>>> partially?  a little bit?), it fixed all my problems.
>>>       
>> I highly recommend you set it up as a daily cron job as suggested  
>> in the
>> comments at the top of the script.
>>     
>
> Probably a stupid question:
>
> Is there a possibility of trouble if the optimize job were to run at  
> the same time as mythfilldatabase?
>
> I'm assuming the two operations could "get along" but it might cause  
> a timeout on MFDB because some of the optimize steps can take many  
> seconds.
>
> I'm following the "suggested next" so I can't predict the precise  
> time MFDB will run, so I've just been running the optimize manually  
> every few days after checking.
>
> I guess I could create a script called from a cron job that checked  
> if MFDB was running before starting to optimize but even then it  
> could start immediately after the optimize started.
>
> I suspect I'm just being too paranoid, but...

Don't know if it could cause a problem, but I've been running with 
grabber suggests time and with the daily optimize_mythdb.pl job for a 
couple of years, now, and haven't experienced any issues.  I guess the 
DB is doing it's job of managing table access appropriately.

Mike