[mythtv-users] Performance MySQL on RAM

[Phill Edwards]

>> Could you upload those files? (mythtv.cnf & mythtv-tweaks.cnf)
>
> mythtv.cnf:
>
> [mysqld]
> bind-address=0.0.0.0
> max_connections=100
>
>
> mythtv-tweaks.cnf (the commented lines are as it comes in the distro, not mine)
>
> [mysqld]
> # The following values were partly taken from:
> # http://www.gossamer-threads.com/lists/mythtv/users/90942#90942
> # key_buffer = 48M
> # max_allowed_packet = 8M
> table_cache = 128
> sort_buffer_size = 48M
> net_buffer_length = 8M
> # thread_cache_size = 4
> query_cache_type = 1
> query_cache_size = 32M
> # don't do binary logs for mythconverg
> binlog_ignore_db = mythconverg

Did this help at all in answering the question about whether to go
with the MythBuntu settings instead of the wiki recommedations?