high traffic website & litespeed

[kamuranyesilot]

hello,

i have a dedicated server. here you can find the configuration below;

total online users: 2000 +
mysql command: 1000 + insert per sec. & 1000 + select per sec. from: (below)
mysql table count: apprx. 2.000.000 +

hardware
amd 2800 cpu
1536 mb ddr ram
2x120 gb hdd

software
centos 5.2
litespeed server
mysql 4.1.21

my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-name-resolve
#old_passwords
back_log = 50
skip-innodb
max_connections = 650
key_buffer = 256M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 3M
table_cache = 1800
thread_cache_size = 512
wait_timeout = 15
connect_timeout = 10
tmp_table_size = 128M
max_heap_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 4M
query_cache_size = 96M
query_cache_type = 1
query_prealloc_size = 65536
query_alloc_block_size = 131072
default-storage-engine = MyISAM

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

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

so; i can't find another solution to make this settings well. i changed my entire system to litespeed and im really happy about that. its really best performance tuning solution.

my problem is: the server is going down everytime. avearage cpu usage is %80. maybe something wrong with my mysql my.cnf settings, i don't know. i am not good at this management stuffs.

i need your tips about optimize my php.ini, httpd.conf and my.cnf with full performance.

many thanks for your advices.

 

[closet geek]

What's your iowait and free memory situation like?

 

[kamuranyesilot]

how can i check this?

 

[closet geek]

mpstat and free -m

 

[kamuranyesilot]

[root@dns /]# free -m
total used free shared buffers cached
Mem: 1455 557 898 0 49 367
-/+ buffers/cache: 140 1315
Swap: 2910 0 2910
[root@dns /]#

this is free -m.

[root@dns /]# mpstat
-bash: mpstat: command not found
[root@dns /]#

this is mpstat. command nof found.

by the way, i probably did the litespeed settings well. its fastest now. i just need to modify my my.cnf file for this configuration.

could you help me with that please?