Although my database is primarily running my UBB system (we are converted to a MySQL backend) I do have a UBBThreads site, I thought some might benefit from seeing how I have MySQL configured in /etc/my.cnf<br /><br />MySQL 3.23.41 under RH v7.2<br /><br />[mysqld]<br />datadir=/usr/local/mysql<br />socket=/var/lib/mysql/mysql.sock<br />set-variable = max_connections=450<br />set-variable = key_buffer=16M<br />set-variable = myisam_sort_buffer_size=64M<br />set-variable = join_buffer=1M<br />set-variable = record_buffer=1M<br />set-variable = sort_buffer=2M<br />set-variable = table_cache=1024<br />set-variable = thread_cache_size=256<br />set-variable = wait_timeout=9600<br />set-variable = connect_timeout=10<br />set-variable = max_allowed_packet=16M<br />set-variable = max_connect_errors=10<br /><br />[mysql.server]<br />user=mysql<br />basedir=/usr/local/mysql<br /><br />[safe_mysqld]<br />err-log=/var/log/mysqld.log<br />pid-file=/var/run/mysqld/mysqld.pid<br />open_files_limit=8192<br /><br />[mysqldump]<br />quick<br />set-variable = max_allowed_packet=16M<br /><br />[myisamchk]<br />set-variable = key_buffer=64M<br />set-variable = sort_buffer=64M<br />set-variable = read_buffer=16M<br />set-variable = write_buffer=16M

Thanks <img src="/forum/images/graemlins/smile.gif" alt="" /><br />