[mythtv-users] optimized system configuration for DB

[sonofzev at iinet.net.au]

On Wed Mar 25 13:25 , Steven Adeff  sent:

>On Tue, Mar 24, 2009 at 6:34 PM, sonofzev at iinet.net.au
>sonofzev at iinet.net.au> wrote:
>> On Tue Mar 24 22:34 , Phill Edwards  sent:
>>>> Also, the documentation doesn't seem to have much regarding db optimisation, can
>>>> someone point me in the right direction for optimising the DB for MythTV. The
>>>> backend box is a Gentoo box, so any specific gentoo related docs would also be
>>>> great.
>>>
>>>At http://wilsonet.com/mythtv/fc6myth.php#mysql Jarod Wilson recommends:
>>>
>>>key_buffer = 16M
>>>table_cache = 128
>>>sort_buffer_size = 2M
>>>myisam_sort_buffer_size = 8M
>>>query_cache_size = 16M
>>>
>>>He also recommends this link which has lots of useful optimisation tips.
>>>
>>>Regards,
>>>Phill
>>
>> Thanks to both of you who responded.
>>
>> These links look really good.
>>
>> As for the database location, I think I will initially try it on my backup RAID
>> and see how it goes.. I only have 2 bays spare and want to use them to extend the
>> media RAID over time. I may go the other way and use the external drive for the
>> bt client...... funny that I've just triggered off a copy of ARCH right now...
>
>I've got my database on a standard 7200RPM drive and have had no
>issues with it. I've got 5 HD tuners and 4 HD capable frontends. I
>don't think there will be much need to worry about the speed of the
>database. I just put it on my system drive and do a daily backup of it
>to my RAID recordings array.
>
>If you really wanted speed you could create a RAM drive and use that
>for the database and do dumps to the raid array as often as you can
>afford to (via rsync perhaps?)

Thanks Sam 


I am concerned because after about 2 years of my first system I now get regular
messages to the effect of "The connection to the backend has been lost".... 
I've been working on the assumption this is a database that has got very
fragmented over time, or is bogged down.. but now I'm not so sure (I have tried
everything except deleting and re-creating the db from scratch).. .

cheers

Allan