[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