[mythtv-users] optimized system configuration for DB

[Phill Edwards]

> 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