MySQL Forums
Forum List  »  Optimizer & Parser

A popular forum not able to take load.. my.cnf optimization needed
Posted by: Raman Singh
Date: August 12, 2007 12:48AM

hi there
i run a popular forum with at least 1000-1200 users online at any given time which reaches 2000-2500 at peak times...
i am using Invision Power Board.

Problem:
Server seems to lose connection with mysql server at peak loads with server load going upto 30.

The server is good enough for these type of loads...
Server Specs:
Dual AMD Opteron 248
4 GB RAM
CENTOS Enterprise 4.5 i686
Cpanel

The my.cnf file is as follows:
-----------------------------------
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
long_query_time=4
key_buffer_size = 64M
query_cache_limit=32M
query_cache_size=256M
query_cache_type=1
max_connections=1024
max_user_connections=1024
interactive_timeout=20
wait_timeout=20
connect_timeout=6
thread_cache_size=256
key_buffer_size=64M
log-queries-not-using-indexes
join_buffer=8M
low_priority_updates=1
max_allowed_packet=16M
table_cache=2048
record_buffer=8M
sort_buffer_size=16M
read_buffer_size=4M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=4
myisam_sort_buffer_size=64M

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
#pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=128M
sort_buffer=128M
read_buffer=32M
write_buffer=32M

[myisamchk]
key_buffer=128M
sort_buffer=128M
read_buffer=32M
write_buffer=32M

[mysqlhotcopy]
interactive-timeout
----------------------------------------------

can anyone please suggest any changes that would bring down the server load?

Also, some entries from httpd.conf are as follows:
Timeout 30
KeepAlive Off
MinSpareServers 15
MaxSpareServers 40
StartServers 15
MaxClients 300
MaxRequestsPerChild 1000


Can anyone please help?

Regards



Edited 1 time(s). Last edit at 08/12/2007 12:50AM by Raman Singh.

Options: ReplyQuote


Subject
Views
Written By
Posted
A popular forum not able to take load.. my.cnf optimization needed
7689
August 12, 2007 12:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.