Hi

Please help me i have big problem my server very slow and also mysql very slow our all customers using Vbulletin here i am posting my server information.


Mysql 4.0.20.standard
this is my server informations

--------------------------------------------------------
Directive Local Value Master Value
allow_call_time_pass_reference On On
allow_url_fopen On On
always_populate_raw_post_data Off Off
arg_separator.input & &
arg_separator.output & &
asp_tags Off Off
auto_append_file no value no value
auto_prepend_file no value no value
browscap no value no value
default_charset no value no value
default_mimetype text/html text/html
define_syslog_variables Off Off
disable_classes no value no value
disable_functions no value no value
display_errors On On
display_startup_errors Off Off
doc_root no value no value
docref_ext no value no value
docref_root no value no value
enable_dl On On
error_append_string no value no value
error_log error_log error_log
error_prepend_string no value no value
error_reporting 2039 2039
expose_php On On
extension_dir ./ ./
file_uploads On On
gpc_order GPC GPC
highlight.bg #FFFFFF #FFFFFF
highlight.comment #FF8000 #FF8000
highlight.default #0000BB #0000BB
highlight.html #000000 #000000
highlight.keyword #007700 #007700
highlight.string #DD0000 #DD0000
html_errors On On
ignore_repeated_errors Off Off
ignore_repeated_source Off Off
ignore_user_abort Off Off
implicit_flush Off Off
include_path .:/usr/lib/php:/usr/local/lib/php .:/usr/lib/php:/usr/local/lib/php
log_errors On On
log_errors_max_len 1024 1024
magic_quotes_gpc On On
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
max_execution_time 30 30
max_input_time -1 -1
open_basedir /home/atesslsp:/usr/lib/php:/usr/local/lib/php:/tmp no value
output_buffering no value no value
output_handler no value no value
post_max_size 55M 55M
precision 14 14
register_argc_argv On On
register_globals On On
report_memleaks On On
safe_mode Off Off
safe_mode_exec_dir no value no value
safe_mode_gid Off Off
safe_mode_include_dir no value no value
sendmail_from no value no value
sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i
serialize_precision 100 100
short_open_tag On On
SMTP localhost localhost
smtp_port 25 25
sql.safe_mode Off Off
track_errors Off Off
unserialize_callback_func no value no value
upload_max_filesize 2M 2M
upload_tmp_dir no value no value
user_dir no value no value
variables_order EGPCS EGPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance Off Off
---------------------------------


This is /etc/my.cnf information

skip-innodb
max_connections = 650
key_buffer = 16M
myisam_sort_buffer_size = 32M
join_buffer_size = 512K
read_buffer_size = 512K
sort_buffer_size = 256K
table_cache = 1024
thread_cache_size = 64
wait_timeout = 10800
connect_timeout = 10
tmp_table_size = 16M
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 64M
query_cache_type = 1
thread_concurrency=8

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

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


Please help me it is big problem with me

What is your server specs ? What does your 'TOP' looks like ? How many simultaneous users are there on your servers ? How many VB are you running ?

In This server we hosted 35 website it is shared hosting server 12 users using VB Please help me this is big problem .


This is "top" command out put


01:27:41 up 2 min, 1 user, load average: 4.90, 1.77, 0.64
121 processes: 119 sleeping, 2 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 47.5% 0.0% 6.3% 0.5% 0.1% 17.3% 27.9%
Mem: 1019392k av, 318132k used, 701260k free, 0k shrd, 11828k buff
249480k active, 41112k inactive
Swap: 2097136k av, 0k used, 2097136k free 120104k cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
3397 mysql 15 0 10484 10M 1476 S 14.3 1.0 0:02 0 mysqld
3029 nobody 15 0 10884 10M 3232 S 7.7 1.0 0:01 0 httpd
3083 nobody 15 0 8380 8380 3220 S 4.5 0.8 0:00 0 httpd
3053 nobody 16 0 9116 9116 3260 S 3.5 0.8 0:00 0 httpd
3505 mysql 16 0 10484 10M 1476 S 3.5 1.0 0:00 0 mysqld
3025 nobody 16 0 8948 8948 3224 S 2.9 0.8 0:00 0 httpd
3339 nobody 15 0 9220 9220 3240 S 2.7 0.9 0:00 0 httpd
3028 nobody 15 0 9224 9224 3224 S 2.3 0.9 0:00 0 httpd
3513 nobody 15 0 8424 8424 3244 S 2.1 0.8 0:00 0 httpd
3905 moonae 20 0 8244 8244 4244 S 0.9 0.8 0:00 0 cpsrvd
3080 nobody 15 0 6552 6552 3232 S 0.5 0.6 0:00 0 httpd
3438 mysql 15 0 10484 10M 1476 S 0.3 1.0 0:00 0 mysqld
3591 nobody 15 0 6332 6332 3244 S 0.3 0.6 0:00 0 httpd
3603 mysql 15 0 10484 10M 1476 S 0.3 1.0 0:00 0 mysqld
3868 moonae 15 0 8248 8248 4244 S 0.3 0.8 0:00 0 cpsrvd