Server Optimize Help. Heavy Load

[phkk]

Hello all experts out there. I came with very heavy load server.

My server is Dual Xeon 3.2 Ghz and 2Gb Dram server. It have 74 SCSI HardDrive.

It alway around 70% load. My board is only 150 concurrent people online.

Here is my config. Please help.

Ps. I run window 2003 standard server. with Plesk .


[MySQLD]
port=3306
basedir=C:\\Program Files\\SWsoft\\Plesk\\Databases\\MySQL
datadir=C:\\Program Files\\SWsoft\\Plesk\\Databases\\MySQL\\Data

default-character-set=latin1
default-storage-engine=MyISAM


max_connections=600
key_buffer = 128M
query_cache_size=64M
query_cache_limit = 6M
query_cache_type = 1

table_cache=1024
tmp_table_size=64M
thread_cache=64


myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
key_buffer_size=64M
read_buffer_size=64K
read_rnd_buffer_size=1M
sort_buffer_size=2M

wait_timeout = 180
connect_timeout = 10
max_allowed_packet = 64M
max_connect_errors = 10


skip-innodb
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 32M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M




PS. they ran up to database error because the USER table. ( user table are in used , this happen when i am in phpadmin cp ).

[Steve Machol]

Please see this thread for help with optimizing your server:

http://www.vbulletin.com/forum/showthread.php?threadid=70117

Then post the requested info.