Hi everyone I run a relatively popular forum that gets overloaded on match days. On normal days, the site is coping fine, but when there are plenty of users on the forum (about 50-70 odd) the load goes up and the site crawls, before crashing, and the server rebooted
The forum software is phpBB. The URL is: http://www.arsenal-mania.com/ On normal days though with about the same amount of users, the site is fine. The site is running on: AMD Athlon 64 3000+ 1GB 400MHz DDR RAM CentOS 3.62 mySQL 5.0.17 I am assuming that the reason the site is slowing down is because when a match ends, people are logging on to the site to check full-time scores, and this creates a number of database connections simultaneously. This is what I have in my my.cnf file: [mysqld] set-variable = max_connections=500 set-variable = max_user_connections=350 set-variable = long_query_time=5 set-variable = thread_cache_size=40 set-variable = wait_timeout=20 query_cache_size = 20M safe-show-database log_error = /var/log/mysql_error.log log-slow-queries = /var/log/mysql_slow_queries.log Short of increasing the amount of physical RAM, I am hoping to explore configuration options beforehand. If anyone has any ideas I can try out, I'd appreciate it if you could please let me know. I can provide more stats if necessary! Thanks in advance. -- Jonathan Chong http://www.arsenal-now.com/ http://www.arsenal-mania.com/ http://www.ashburrn.com/ http://www.jonathan-chong.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
