[mythtv-users] optimized system configuration for DB

[sonofzev at iinet.net.au]

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
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

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...