Hi,
Please provide details like what tables are you using, the entire my.cnf
and the information from the mysqld.err when the crashes occurred.
--Alex
On Wed, 04 Jan 2006 06:11:24 +0530, Jonathan Chong <[EMAIL PROTECTED]>
wrote:
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]
