Need help with optimize server [Archive] - vBulletin Community Forum

View Full Version : Need help with optimize server

vietkool

Mon 11th Jul '05, 1:34am

Hi everyone

I just got a new server Dual opteron 242 + 2gb ram, 250gb hdd, Cpanel + Centos 3.5. And i'd like to optimize my server for vbb forum. My forum has at least 3000 members visit each day. The traffic is really high at night. I have search and look around for those guide, but dont see any optimize for dual opteron 242 like mine. Would anyone in here please help me what do i need for my my.cnf and httpd.conf ? thanks for reading.

p/s: my connection is 20mbps and can burst to 100mbps. My forum allows upload picture, movie, flash...etc which max 120kb each.

Zachery

Mon 11th Jul '05, 3:05am

http://www.vbulletin.com/forum/showthread.php?t=70117 If you could get that together for us that would be awsome :)

vietkool

Tue 19th Jul '05, 1:47am

Hi Zachery and everyone

Sorry about late reply, it took me awhile for reading and understand these questions

1. This is dedicate server, there are 10 sites on this server

2. Dual Operon 242 +
2GB ram
hdd1 = 250gb and backup hdd2= 300gb (They both EIDE ,no raid)
Centos 3.5
Cpanel lastest version
Apache 1.3.33
PHP version: php 4.3.11
MySQL version: mysql 4.0.24

3. Not really sure, but my answer is no.

4. When i got the server, the mysql was install already

5. my top stats

00:40:56 up 1 day, 2:01, 1 user, load average: 13.37, 7.60, 5.74
621 processes: 619 sleeping, 1 running, 0 zombie, 1 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 6.3% 0.0% 5.2% 0.4% 0.2% 82.6% 4.9%
cpu00 6.5% 0.0% 4.4% 0.0% 0.5% 81.5% 6.8%
cpu01 6.1% 0.0% 6.0% 0.9% 0.0% 83.8% 3.0%
Mem: 2057184k av, 2046092k used, 11092k free, 0k shrd, 9764k buff
1589512k actv, 301960k in_d, 27924k in_c
Swap: 2040244k av, 295884k used, 1744360k free 434456k cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
8 root 15 0 0 0 0 SW 1.3 0.0 8:49 1 kscand
7 root 15 0 0 0 0 SW 0.5 0.0 6:25 1 kswapd
3000 root 15 0 5676 4244 2364 S 0.3 0.2 0:00 0 /usr/local/apache/bin/httpd -DSSL
3731 nobody 15 0 24096 22M 2664 S 0.3 1.1 0:00 1 /usr/local/apache/bin/httpd -DSSL
3938 mysql 15 0 123M 71M 1128 D 0.3 3.5 0:00 1 /usr/sbin/mysqld --basedir=/ --da
3429 nobody 16 0 31720 29M 2672 S 0.2 1.4 0:00 0 /usr/local/apache/bin/httpd -DSSL
3712 nobody 15 0 42940 40M 2660 S 0.2 2.0 0:00 0 /usr/local/apache/bin/httpd -DSSL
3919 mysql 15 0 123M 71M 1128 S 0.2 3.5 0:00 1 /usr/sbin/mysqld --basedir=/ --da
3922 mysql 15 0 123M 71M 1128 S 0.2 3.5 0:00 1 /usr/sbin/mysqld --basedir=/ --da
3961 mysql 15 0 123M 71M 1128 S 0.2 3.5 0:00 0 /usr/sbin/mysqld --basedir=/ --da
4047 root 15 0 1560 1560 896 R 0.2 0.0 0:00 0 top -c
4108 nobody 18 0 6564 5324 2664 S 0.2 0.2 0:00 0 /usr/local/apache/bin/httpd -DSSL
3049 nobody 15 0 10148 8848 2756 S 0.1 0.4 0:01 0 /usr/local/apache/bin/httpd -DSSL
3349 nobody 15 0 9844 8588 2752 S 0.1 0.4 0:00 0 /usr/local/apache/bin/httpd -DSSL
3430 nobody 16 0 9796 8544 2720 S 0.1 0.4 0:00 0 /usr/local/apache/bin/httpd -DSSL
3495 nobody 15 0 7912 6676 2684 S 0.1 0.3 0:00 1 /usr/local/apache/bin/httpd -DSSL
3598 nobody 15 0 42828 40M 2664 S 0.1 2.0 0:00 1 /usr/local/apache/bin/httpd -DSSL
3688 mysql 15 0 123M 71M 1128 D 0.1 3.5 0:00 1 /usr/sbin/mysqld --basedir=/ --da
3727 nobody 15 0 7828 6588 2684 S 0.1 0.3 0:00 1 /usr/local/apache/bin/httpd -DSSL
3737 nobody 15 0 42828 40M 2668 S 0.1 2.0 0:00 1 /usr/local/apache/bin/httpd -DSSL
root@server [~]#

6. /etc/my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-innodb
max_connections = 650
key_buffer = 32M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 64
wait_timeout = 3600
connect_timeout = 10
tmp_table_size = 32M
bulk_insert_buffer_size = 8M
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
#log_slow_queries=/home/fpalmer/web/html/logs/mysql_slow_query.txt
#long_query_time = 30
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

7.
root@server [~]# mysqladmin -u root -p extended-status
Enter password:

+--------------------------+----------+
Variable_name Value
+--------------------------+----------+
Aborted_clients 0
Aborted_connects 10
Bytes_received 13042713
Bytes_sent 98377227
Com_admin_commands 0
Com_alter_table 0
Com_analyze 0
Com_backup_table 0
Com_begin 0
Com_change_db 9554
Com_change_master 0
Com_check 0
Com_commit 0
Com_create_db 0
Com_create_function 0
Com_create_index 0
Com_create_table 0
Com_delete 913
Com_delete_multi 0
Com_drop_db 0
Com_drop_function 0
Com_drop_index 0
Com_drop_table 0
Com_flush 0
Com_grant 0
Com_ha_close 0
Com_ha_open 0
Com_ha_read 0
Com_insert 861
Com_insert_select 0
Com_kill 0
Com_load 0
Com_load_master_data 0
Com_load_master_table 0
Com_lock_tables 452
Com_optimize 0
Com_purge 0
Com_rename_table 0
Com_repair 0
Com_replace 0
Com_replace_select 0
Com_reset 0
Com_restore_table 0
Com_revoke 0
Com_rollback 0
Com_savepoint 0
Com_select 8948
Com_set_option 1590
Com_show_binlog_events 0
Com_show_binlogs 0
Com_show_create 0
Com_show_databases 15
Com_show_fields 0
Com_show_grants 0
Com_show_keys 0
Com_show_logs 0
Com_show_master_status 0
Com_show_new_master 0
Com_show_open_tables 0
Com_show_processlist 837
Com_show_slave_hosts 0
Com_show_slave_status 0
Com_show_status 2
Com_show_innodb_status 0
Com_show_tables 0
Com_show_variables 15
Com_slave_start 0
Com_slave_stop 0
Com_truncate 0
Com_unlock_tables 452
Com_update 2695
Com_update_multi 33
Connections 12009
Created_tmp_disk_tables 0
Created_tmp_tables 0
Created_tmp_files 3
Delayed_insert_threads 0
Delayed_writes 0
Delayed_errors 0
Flush_commands 1
Handler_commit 0
Handler_delete 110
Handler_read_first 911
Handler_read_key 1405
Handler_read_next 118
Handler_read_prev 258788
Handler_read_rnd 54
Handler_read_rnd_next 8511067
Handler_rollback 0
Handler_update 469
Handler_write 861
Key_blocks_used 33
Key_read_requests 18026
Key_reads 27
Key_write_requests 1239
Key_writes 941
Max_used_connections 5
Not_flushed_key_blocks 0
Not_flushed_delayed_rows 0
Open_tables 9
Open_files 17
Open_streams 0
Opened_tables 15
Questions 258942
Qcache_queries_in_cache 601
Qcache_inserts 8915
Qcache_hits 220578
Qcache_lowmem_prunes 0
Qcache_not_cached 0
Qcache_free_memory 32691536
Qcache_free_blocks 51
Qcache_total_blocks 1262
Rpl_status NULL
Select_full_join 0
Select_full_range_join 0
Select_range 0
Select_range_check 0
Select_scan 7414
Slave_open_temp_tables 0
Slave_running OFF
Slow_launch_threads 0
Slow_queries 0
Sort_merge_passes 0
Sort_range 0
Sort_rows 54
Sort_scan 5
Table_locks_immediate 12938
Table_locks_waited 0
Threads_cached 5
Threads_created 6
Threads_connected 1
Threads_running 1
Uptime 251718

8

There are few sites ( about 9 site) are using php and mysql , but they don’t take a lot of ram and memory. Only my site take most memory and cpu load

9.
how many average and max concurrent users on your vB forum ? and what your cookie timeout is?

My forums has average about 200 members online, max about 500 members at peak time, and it’s growing more.

Other sites have around 100-200 concurrent members online at peak time

So , I would say total around 600-700 concurrent members at peak time.

10

Here is my phpinfo.php
http://vnquehuong.com/info.php (http://vnquehuong.com/info.php)

11. httpd.conf

Timeout 10
KeepAlive on
MaxKeepAliveRequests 100
KeepAliveTimeout 15
MinSpareServers 5
MaxSpareServers 10
StartServers 7
MaxClients 300
MaxRequestsPerChild 1000

12. what version of vB are you running ?

3.0.7

13.
check to see if any files i.e. apache log files are hitting 2GB or 4GB max file size limits i.e. see if you have max file size exceeded messages in apache error log?

There is no log file over 2gb

Thanks for looking

vietkool

Tue 19th Jul '05, 4:17am

Any help please ?

00:16:39 up 2 days, 1:37, 1 user, load average: 9.27, 11.05, 6.78
349 processes: 339 sleeping, 9 running, 1 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 24.2% 0.0% 9.2% 0.0% 0.1% 9.0% 57.2%
cpu00 24.4% 0.0% 9.1% 0.0% 0.3% 12.3% 53.7%
cpu01 24.1% 0.0% 9.3% 0.0% 0.0% 5.7% 60.7%
Mem: 2057184k av, 776468k used, 1280716k free, 0k shrd, 10244k buff
563340k actv, 106436k in_d, 13904k in_c
Swap: 2040244k av, 255168k used, 1785076k free 282696k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
9450 mysql 16 0 138M 64M 1220 S 2.6 3.1 0:00 1 /usr/sbin/mysqld --basedir=/ --dat
3738 mysql 16 0 138M 64M 1220 S 1.8 3.1 0:08 1 /usr/sbin/mysqld --basedir=/ --dat
10634 nobody 15 0 10520 10M 3808 S 1.8 0.5 0:00 0 /usr/local/apache/bin/httpd -DSSL
10531 nobody 16 0 11512 11M 3812 S 1.7 0.5 0:00 0 /usr/local/apache/bin/httpd -DSSL
3727 mysql 16 0 138M 64M 1220 S 1.4 3.1 0:07 0 /usr/sbin/mysqld --basedir=/ --dat
10539 nobody 16 0 10532 10M 3844 S 1.3 0.5 0:00 1 /usr/local/apache/bin/httpd -DSSL
10652 nobody 15 0 10528 10M 3820 S 1.3 0.5 0:00 0 /usr/local/apache/bin/httpd -DSSL
10483 nobody 15 0 7360 7360 3772 S 1.2 0.3 0:00 1 /usr/local/apache/bin/httpd -DSSL
10545 nobody 16 0 10056 9.8M 3820 R 1.2 0.4 0:00 1 /usr/local/apache/bin/httpd -DSSL
10547 nobody 15 0 9692 9692 3844 S 1.2 0.4 0:00 0 /usr/local/apache/bin/httpd -DSSL
10573 nobody 15 0 10488 10M 3820 S 1.2 0.5 0:00 0 /usr/local/apache/bin/httpd -DSSL
7627 mysql 16 0 138M 64M 1220 S 1.0 3.1 0:00 0 /usr/sbin/mysqld --basedir=/ --dat
10565 nobody 15 0 9844 9844 3836 S 0.9 0.4 0:00 1 /usr/local/apache/bin/httpd -DSSL
8010 mysql 16 0 138M 64M 1220 S 0.7 3.1 0:00 0 /usr/sbin/mysqld --basedir=/ --dat
10490 nobody 16 0 29872 29M 3852 R 0.7 1.4 0:00 0 /usr/local/apache/bin/httpd -DSSL
10569 nobody 15 0 10464 10M 3840 S 0.6 0.5 0:00 1 /usr/local/apache/bin/httpd -DSSL
10459 nobody 15 0 7948 7948 3808 S 0.5 0.3 0:00 0 /usr/local/apache/bin/httpd -DSSL
10494 nobody 15 0 10616 10M 3852 S 0.5 0.5 0:00 0 /usr/local/apache/bin/httpd -DSSL
10617 nobody 15 0 9700 9700 3836 S 0.5 0.4 0:00 0 /usr/local/apache/bin/httpd -DSSL

eva2000

Tue 19th Jul '05, 7:52am

vietkool

Tue 19th Jul '05, 2:45pm

i can't seem to access http://vnquehuong.com/info.php ?

mysql seems to be lightly used can you repost an up to date output for

mysqladmin -u root -p extended-status

definitely the problem is you're swapping to disk ALOT and with slow IDE hard drives that consumes even more cpu resources

what kernel version you using on the server ?
YEs, My server load was so high early this morning

HEre is out put of extended-status

root@server [~]# mysqladmin -u root -p extended-status
Enter password:
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
| Bytes_received | 11134686 |
| Bytes_sent | 2635879153 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 3377 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_delete | 868 |
| Com_delete_multi | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 1279 |
| Com_insert_select | 11 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 50 |
| Com_optimize | 0 |
| Com_purge | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 87 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 13750 |
| Com_set_option | 99 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 1 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 0 |
| Com_show_variables | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 50 |
| Com_update | 4285 |
| Com_update_multi | 49 |
| Connections | 3434 |
| Created_tmp_disk_tables | 25 |
| Created_tmp_tables | 743 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 385 |
| Handler_read_first | 1922 |
| Handler_read_key | 302766 |
| Handler_read_next | 648519 |
| Handler_read_prev | 25445 |
| Handler_read_rnd | 108670 |
| Handler_read_rnd_next | 28904688 |
| Handler_rollback | 0 |
| Handler_update | 115082 |
| Handler_write | 44172 |
| Key_blocks_used | 3672 |
| Key_read_requests | 483706 |
| Key_reads | 3654 |
| Key_write_requests | 2395 |
| Key_writes | 1907 |
| Max_used_connections | 14 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 206 |
| Open_files | 339 |
| Open_streams | 0 |
| Opened_tables | 212 |
| Questions | 51822 |
| Qcache_queries_in_cache | 1736 |
| Qcache_inserts | 13354 |
| Qcache_hits | 24486 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 396 |
| Qcache_free_memory | 21142856 |
| Qcache_free_blocks | 486 |
| Qcache_total_blocks | 4305 |
| Rpl_status | NULL |
| Select_full_join | 3 |
| Select_full_range_join | 0 |
| Select_range | 2485 |
| Select_range_check | 0 |
| Select_scan | 3626 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 1858 |
| Sort_rows | 1504185 |
| Sort_scan | 1720 |
| Table_locks_immediate | 36574 |
| Table_locks_waited | 127 |
| Threads_cached | 11 |
| Threads_created | 15 |
| Threads_connected | 4 |
| Threads_running | 1 |
| Uptime | 1304 |
+--------------------------+------------+

mysqladmin -u root -p variables

Variable_name Value
back_log 50
basedir /
binlog_cache_size 32768
bulk_insert_buffer_size 8388608
character_set latin1
character_sets latin1 big5 czech euc_kr gb2312 gbk latin1_d e sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish h ebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5
concurrent_insert ON
connect_timeout 10

convert_character_set
datadir /var/lib/mysql/
default_week_format 0
delay_key_write ON
delayed_insert_limit 100
delayed_insert_timeout 300
delayed_queue_size 1000
flush OFF
flush_time 0

ft_boolean_syntax + -><()~*:""&|
ft_min_word_len 4
ft_max_word_len 254
ft_max_word_len_for_sort 20
ft_stopword_file (built-in)
have_bdb NO
have_crypt YES
have_innodb DISABLED
have_isam YES
have_raid NO
have_symlink YES
have_openssl NO
have_query_cache YES
init_file
innodb_additional_mem_pool_size 1048576
innodb_autoextend_increment 8
innodb_buffer_pool_size 8388608
innodb_data_file_path
innodb_data_home_dir |
innodb_file_io_threads 4
innodb_force_recovery 0
innodb_thread_concurrency 8

innodb_flush_log_at_trx_commit 1
innodb_fast_shutdown ON
innodb_flush_method
innodb_lock_wait_timeout 50
innodb_log_arch_dir ./
innodb_log_archive OFF
innodb_log_buffer_size 1048576
innodb_log_file_size 5242880
innodb_log_files_in_group 2
innodb_log_group_home_dir ./
innodb_mirrored_log_groups 1
innodb_max_dirty_pages_pct 90
innodb_max_purge_lag 0
innodb_table_locks ON
interactive_timeout 28800
join_buffer_size 1044480
key_buffer_size 33554432
language /usr/share/mysql/english/
large_files_support ON
license GPL
local_infile ON
locked_in_memory OFF
log OFF
log_update OFF
log_bin OFF
log_slave_updates OFF
log_slow_queries OFF
log_warnings 1
long_query_time 10
low_priority_updates OFF
lower_case_file_system OFF
lower_case_table_names 0
max_allowed_packet 16776192
max_binlog_cache_size 4294967295
max_binlog_size 1073741824
max_connections 650
max_connect_errors 10
max_delayed_threads 20
max_insert_delayed_threads 20
max_heap_table_size 16777216
max_join_size 4294967295
max_relay_log_size 0
max_seeks_for_key 4294967295
max_sort_length 1024
max_user_connections 0
max_tmp_tables 32
max_write_lock_count 4294967295
myisam_max_extra_sort_file_size 268435456
myisam_max_sort_file_size 2147483647
myisam_repair_threads 1
myisam_recover_options OFF
myisam_sort_buffer_size 67108864
net_buffer_length 16384
net_read_timeout 30
net_retry_count 10
net_write_timeout 60
new OFF
open_files_limit 3260
pid_file /var/lib/mysql/server.vnmanaged.net.pid
log_error
port 3306
protocol_version 10
query_alloc_block_size 8192
query_cache_limit 1048576
query_cache_size 33554432
query_cache_type ON
query_cache_wlock_invalidate OFF
query_prealloc_size 8192
range_alloc_block_size 2048
read_buffer_size 1044480
read_only OFF
read_rnd_buffer_size 262144
rpl_recovery_rank 0
server_id 0
slave_net_timeout 3600
skip_external_locking ON
skip_networking OFF
skip_show_database OFF
slow_launch_time 2
socket /var/lib/mysql/mysql.sock
sort_buffer_size 2097144
sql_mode 0
table_cache 1024
table_type MYISAM
thread_cache_size 64
thread_stack 126976
tx_isolation REPEATABLE-READ
timezone PDT
tmp_table_size 33554432
tmpdir /tmp/
transaction_alloc_block_size 8192
transaction_prealloc_size 4096
version 4.0.24-standard
version_comment Official MySQL RPM
version_compile_os pc-linux-gnu
wait_timeout 3600

definitely the problem is you're swapping to disk ALOT and with slow IDE hard drives that consumes even more cpu resources

What should i do to decrease the swapping ?
There are 2 hdd IDE, one is 250gb, and one is 300gb for backup

My kernel:
kernel-source-2.4.21-32.0.1.EL

And OS is Centos 3.5

One more thing, something weird in my server, there are few website running at /home dir which is in main hdd and some are running at /home2 which is in backup hdd !!!. Should i go ahead move them all to /home dir ?. Or any idea? Thanks alot

vietkool

Wed 20th Jul '05, 3:26am

Sorry, if this is annoying you guys, but my server load is crazy

23:16:58 up 13:01, 1 user, load average: 9.82, 7.26, 5.70
438 processes: 437 sleeping, 1 running, 0 zombie, 0 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 35.3% 0.0% 5.7% 0.2% 1.0% 5.7% 51.7%
cpu00 33.3% 0.0% 5.9% 0.3% 1.9% 6.1% 52.0%
cpu01 37.3% 0.0% 5.5% 0.1% 0.1% 5.3% 51.3%
Mem: 2057184k av, 1169652k used, 887532k free, 0k shrd, 19248k buff
854916k actv, 188088k in_d, 20752k in_c
Swap: 2040244k av, 172396k used, 1867848k free 436980k cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
20454 mysql 16 0 75200 57M 1208 S 2.9 2.8 0:04 0 /usr/sbin/mysqld --basedir=/ --datadir=/
22178 mysql 16 0 75200 57M 1208 S 2.6 2.8 0:00 1 /usr/sbin/mysqld --basedir=/ --datadir=/
22511 nobody 15 0 10632 10M 3844 S 2.4 0.5 0:00 1 /usr/local/apache/bin/httpd -DSSL
22472 nobody 15 0 10588 10M 3832 S 1.9 0.5 0:00 1 /usr/local/apache/bin/httpd -DSSL
22378 nobody 15 0 10612 10M 3840 S 1.8 0.5 0:00 0 /usr/local/apache/bin/httpd -DSSL
22256 nobody 15 0 11744 11M 3828 S 1.6 0.5 0:00 1 /usr/local/apache/bin/httpd -DSSL
22350 nobody 15 0 8932 8932 3852 S 1.6 0.4 0:00 0 /usr/local/apache/bin/httpd -DSSL
22309 nobody 16 0 10592 10M 3816 S 1.5 0.5 0:00 1 /usr/local/apache/bin/httpd -DSSL
22422 nobody 15 0 9732 9732 3832 S 1.5 0.4 0:00 0 /usr/local/apache/bin/httpd -DSSL
22251 nobody 15 0 9744 9744 3844 S 1.3 0.4 0:00 0 /usr/local/apache/bin/httpd -DSSL
22335 nobody 15 0 10508 10M 3832 S 1.3 0.5 0:00 0 /usr/local/apache/bin/httpd -DSSL
22491 nobody 15 0 10472 10M 3840 S 1.3 0.5 0:00 1 /usr/local/apache/bin/httpd -DSSL
22371 nobody 16 0 11576 11M 3816 S 1.2 0.5 0:00 1 /usr/local/apache/bin/httpd -DSSL
22442 nobody 15 0 10696 10M 3840 S 1.1 0.5 0:00 0 /usr/local/apache/bin/httpd -DSSL
22401 nobody 15 0 7560 7560 3768 S 0.9 0.3 0:00 1 /usr/local/apache/bin/httpd -DSSL
22797 mysql 15 0 75200 57M 1208 S 0.7 2.8 1:37 1 /usr/sbin/mysqld --basedir=/ --datadir=/
22271 nobody 16 0 6932 6932 3552 S 0.7 0.3 0:00 0 /usr/local/apache/bin/httpd -DSSL
22451 nobody 15 0 8352 8352 3836 S 0.7 0.4 0:00 1 /usr/local/apache/bin/httpd -DSSL
22320 nobody 15 0 9740 9740 3840 S 0.6 0.4 0:00 0 /usr/local/apache/bin/httpd -DSSL
22455 nobody 15 0 8824 8824 3844 S 0.5 0.4 0:00 1 /usr/local/apache/bin/httpd -DSSL
22379 nobody 15 0 6904 6904 3552 S 0.4 0.3 0:00 0 /usr/local/apache/bin/httpd -DSSL
22392 nobody 15 0 13568 13M 3852 S 0.4 0.6 0:00 0 /usr/local/apache/bin/httpd -DSSL
22404 nobody 16 0 10712 10M 3848 S 0.4 0.5 0:00 0 /usr/local/apache/bin/httpd -DSSL
22458 nobody 15 0 7384 7384 3780 S 0.4 0.3 0:00 1 /usr/local/apache/bin/httpd -DSSL
22503 nobody 15 0 6904 6904 3552 S 0.4 0.3 0:00 0 /usr/local/apache/bin/httpd -DSSL

I have to stop apache for about 30 seconds to 1 minute then restart . then The server load decrease to 3.xx something.
After awhile ( about 15 -20 minutes) the server load jump back to 11.xx or higher, i have to stop apache and restart it again to make it decrease, again.

I just cannt stay whole night to watching this drive me crazy. and it has been 4 nights already, and i know it will happen again and again.

I beg anyone in here expert about server configuration please help. Thanks alot guys.

p/s: my YIM : andyjh55416 or my email ncc999@gmail.com

eva2000

Wed 20th Jul '05, 10:30am

it doesn't seem to be a mysql issue from what i can see as mysql is very lightly loaded

tried contacting web host to diagnose this ? tried upgrading to latest stable smp 2.6.x linux kernel ?