Server Configuration Request!!!
March 15th, 2010About 12 domains but there is only 2 site are buzy, all others none operating site.
2. your server specs.
Dual Opteron 242
2 GIG RAM
2 X 250G HHD SATA
CentOS 3.5
Cpanel 10
Apache 1.3.34
PHP Version 4.4.1
Mysql version 4.0.25-standard
3. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?
Not sure, I have some databases IBF, some using Vb and copermine (photo gallery)
4. if possible how mysql was compiled/installed
Installed from server owner where I am leasing the server
5. your top stats
22:27:17 up 13 days, 3:23, 1 user, load average: 5.58, 14.09, 35.45
487 processes: 472 sleeping, 9 running, 4 zombie, 2 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 31.3% 0.0% 7.5% 0.0% 0.7% 0.3% 59.9%
cpu00 27.9% 0.0% 10.8% 0.0% 1.5% 0.5% 59.0%
cpu01 34.8% 0.0% 4.1% 0.0% 0.0% 0.1% 60.7%
Mem: 2057184k av, 900936k used, 1156248k free, 0k shrd, 20756k buff
663996k actv, 127264k in_d, 2832k in_c
Swap: 2040244k av, 66148k used, 1974096k free 516772k cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
31267 mysql 16 0 194M 182M 1264 S 8.3 9.0 1:57 0 mysqld
30995 mysql 16 0 194M 182M 1264 R 6.4 9.0 1:55 1 mysqld
30994 mysql 16 0 194M 182M 1264 S 3.9 9.0 2:14 1 mysqld
9330 nobody 24 0 10256 10M 3384 R 3.7 0.4 0:00 0 httpd
9331 nobody 24 0 9780 9780 3384 R 2.4 0.4 0:00 1 httpd
26252 mysql 15 0 194M 182M 1264 S 1.8 9.0 5:58 0 mysqld
9327 nobody 24 0 10664 10M 3452 R 1.4 0.5 0:00 0 httpd
9348 nobody 24 0 6676 6676 3392 S 1.1 0.3 0:00 0 httpd
9329 nobody 24 0 9492 9492 3384 R 1.0 0.4 0:00 1 httpd
8476 root 24 0 6104 6104 3108 R 0.7 0.2 0:00 0 httpd
8499 root 16 0 1552 1552 896 R 0.5 0.0 0:00 0 top
1 root 15 0 116 84 56 S 0.0 0.0 0:12 1 init
2 root RT 0 0 0 0 SW 0.0 0.0 0:00 0 migration/0
3 root RT 0 0 0 0 SW 0.0 0.0 0:00 1 migration/1
4 root 15 0 0 0 0 SW 0.0 0.0 0:05 1 keventd
5 root 34 19 0 0 0 SWN 0.0 0.0 0:00 0 ksoftirqd/0
6 root 34 19 0 0 0 SWN 0.0 0.0 0:00 1 ksoftirqd/1
9 root 15 0 0 0 0 SW 0.0 0.0 0:03 1 bdflush
7 root 15 0 0 0 0 SW 0.0 0.0 13:40 1 kswapd
8 root 15 0 0 0 0 SW 0.0 0.0 34:01 1 kscand
10 root 15 0 0 0 0 SW 0.0 0.0 0:34 0 kupdated
11 root 25 0 0 0 0 SW 0.0 0.0 0:00 0 mdrecoveryd
15 root 15 0 0 0 0 SW 0.0 0.0 3:53 0 kjournald
93 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 khubd
1537 root 15 0 0 0 0 SW 0.0 0.0 0:00 0 kjournald
1618 root 15 0 0 0 0 SW 0.0 0.0 0:12 0 loop0
1619 root 15 0 0 0 0 SW 0.0 0.0 1:27 0 kjournald
2109 root 15 0 328 308 244 S 0.0 0.0 0:22 0 syslogd
2113 root 15 0 168 156 108 S 0.0 0.0 0:06 1 klogd
2123 root 15 0 236 228 172 S 0.0 0.0 0:29 1 irqbalance
2152 root 15 0 164 144 104 S 0.0 0.0 0:02 1 mdadm
2169 root RT 0 332 224 188 S 0.0 0.0 1:00 1 auditd
4038 named 25 0 3896 2492 956 S 0.0 0.1 0:00 0 named
4039 named 15 0 3896 2492 956 S 0.0 0.1 0:51 1 named
4042 named 15 0 3896 2492 956 S 0.0 0.1 0:55 1 named
4043 named 15 0 3896 2492 956 S 0.0 0.1 0:02 1 named
4044 named 15 0 3896 2492 956 S 0.0 0.1 0:22 1 named
4052 root 15 0 328 184 88 S 0.0 0.0 0:01 1 sshd
4084 root 19 0 7056 1924 680 S 0.0 0.0 0:22 1 chkservd
4223 root 15 0 376 352 284 S 0.0 0.0 0:02 1 crond
4264 xfs 15 0 1904 60 32 S 0.0 0.0 0:00 1 xfs
4460 root 39 19 14444 11M 960 S N 0.0 0.5 9:27 1 cpanellogd
4505 nobody 24 0 1040 4 0 S 0.0 0.0 0:00 1 entropychat
4515 nobody 24 0 236 4 0 S 0.0 0.0 0:00 1 melange
4564 root 23 0 72 4 0 S 0.0 0.0 0:00 0 portsentry
6. your mysql configuration variables located at /etc/my.cnf or c:my.cnf so post the contents inside of my.cnf (minus any passwords of course). If on Windows server if you don't have that file you need to log into telnet and as root user type
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-innodb
back_log = 50
max_connections = 700
key_buffer = 32M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 180
connect_timeout = 10
tmp_table_size = 64M
bulk_insert_buffer_size = 8M
max_allowed_packet = 64M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 96M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384
#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
7. your mysql extended-status output which shows entire server's mysql activity status (preferably with a day or 2 worth of mysql uptime for better indication of real activity) either:
don't know how to get mysql extended-status
8. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?
vBulletin, copermine photogalery, some IBF database
9. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?
150-400 avg, max 500, 3600secs.
10. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site
http://204.11.96.18/~monghoa/info.php
11. if you run Apache and you have your own dedicated server or access to your httpd.conf (apache configuration file) can you post the values you have set for the following :
Timeout 300
KeepAlive off
MaxKeepAliveRequests 250
KeepAliveTimeout 20
MinSpareServers 25
MaxSpareServers 100
StartServers 10
MaxClients 500
MaxRequestsPerchild 1000
12. what version of vB are you running ?
vBulletin 3.5.3
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
Log file delete every 5 days. So it nver go up to 2GB
Thank you in Advance for your help in optimizing this server.
Regards,
for now try
1. Upgrade MySQL server to 4.0.26
2. Upgrade PHP to 4.4.2 if you use phpadsnew make sure to update to phpadsnew 2.0.7 to work with PHP 4.4.1/4.4.2
3. If you just upgraded to vB 3.5.x try to disable these 4 options:
Admin CP -> vBulletin Options -> Forums Home Page Options -> Display Logged in Users?
Admin CP -> vBulletin Options -> Forum Display Options (forumdisplay) -> Show Users Browsing Forums
Admin CP -> vBulletin Options -> Thread Display Options -> Show Users Browsing Thread
Admin CP -> vBulletin Options -> Message Searching Options -> Automatic Similar Thread search
4. edit httpd.conf values from
Timeout 300
KeepAlive off
MaxKeepAliveRequests 250
KeepAliveTimeout 20
MinSpareServers 25
MaxSpareServers 100
StartServers 10
MaxClients 500
MaxRequestsPerchild 1000
to
Timeout 300
KeepAlive off
MaxKeepAliveRequests 120
KeepAliveTimeout 8
MinSpareServers 10
MaxSpareServers 15
StartServers 10
MaxClients 180
MaxRequestsPerchild 10000
restart apache
5. Remove zend optimizer and install APC Cache lastest version from http://pecl.php.net/package/APC. Read install guide at http://www.vbulletin.com/forum/showthread.php?t=165367
here is an additonal info for question 6,7
sort_buffer_size 2097144
sql_mode 0
table_cache 1800
table_type MYISAM
thread_cache_size 384
thread_stack 126976
tx_isolation REPEATABLE-READ
timezone PST
tmp_table_size 67108864
tmpdir /tmp/
transaction_alloc_block_size 8192
transaction_prealloc_size 4096
version 4.0.25-standard
version_comment Official MySQL RPM
version_compile_os pc-linux-gnu
wait_timeout 180
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+--------------------------+------------+
Variable_name Value
+--------------------------+------------+
Aborted_clients 1149
Aborted_connects 3
Bytes_received 1404184140
Bytes_sent 3921338571
Com_admin_commands 73
Com_alter_table 27
Com_analyze 0
Com_backup_table 0
Com_begin 3
Com_change_db 426409
Com_change_master 0
Com_check 0
Com_commit 3
Com_create_db 2
Com_create_function 0
Com_create_index 37
Com_create_table 21
Com_delete 151806
Com_delete_multi 0
Com_drop_db 0
Com_drop_function 0
Com_drop_index 0
Com_drop_table 0
Com_flush 4
Com_grant 20
Com_ha_close 0
Com_ha_open 0
Com_ha_read 0
Com_insert 208574
Com_insert_select 103
Com_kill 0
Com_load 0
Com_load_master_data 0
Com_load_master_table 0
Com_lock_tables 14098
Com_optimize 0
Com_purge 0
Com_rename_table 0
Com_repair 0
Com_replace 4598
Com_replace_select 0
Com_reset 0
Com_restore_table 0
Com_revoke 0
Com_rollback 0
Com_savepoint 0
Com_select 1767552
Com_set_option 1224
Com_show_binlog_events 0
Com_show_binlogs 0
Com_show_create 0
Com_show_databases 5
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 827
Com_show_slave_hosts 0
Com_show_slave_status 0
Com_show_status 494
Com_show_innodb_status 0
Com_show_tables 5
Com_show_variables 19
Com_slave_start 0
Com_slave_stop 0
Com_truncate 0
Com_unlock_tables 14149
Com_update 484316
Com_update_multi 333
Connections 385154
Created_tmp_disk_tables 750
Created_tmp_tables 195366
Created_tmp_files 0
Delayed_insert_threads 0
Delayed_writes 0
Delayed_errors 0
Flush_commands 1
Handler_commit 0
Handler_delete 95149
Handler_read_first 248214
Handler_read_key 110844831
Handler_read_next 233174875
Handler_read_prev 3633590
Handler_read_rnd 100356482
Handler_read_rnd_next 1773677332
Handler_rollback 0
Handler_update 16180530
Handler_write 22878374
Key_blocks_used 19747
Key_read_requests 234831707
Key_reads 17420
Key_write_requests 443185
Key_writes 263993
Max_used_connections 32
Not_flushed_key_blocks 0
Not_flushed_delayed_rows 0
Open_tables 474
Open_files 784
Open_streams 0
Opened_tables 533
Questions 7254971
Qcache_queries_in_cache 22705
Qcache_inserts 1711048
Qcache_hits 3796254
Qcache_lowmem_prunes 5789
Qcache_not_cached 56032
Qcache_free_memory 46074552
Qcache_free_blocks 13144
Qcache_total_blocks 59608
Rpl_status NULL
Select_full_join 13
Select_full_range_join 0
Select_range 286305
Select_range_check 0
Select_scan 578496
Slave_open_temp_tables 0
Slave_running OFF
Slow_launch_threads 0
Slow_queries 7
Sort_merge_passes 0
Sort_range 293741
Sort_rows 100502502
Sort_scan 368418
Table_locks_immediate 4922183
Table_locks_waited 41774
Threads_cached 30
Threads_created 33
Threads_connected 3
Threads_running 1
Uptime 248140
+--------------------------+------------+
Uptime: 248140 Threads: 3 Questions: 7254972 Slow queries: 7 Opens: 533 Flush tables: 1 Open tables: 474 Queries per second avg: 29.237
mysqladmin Ver 8.40 Distrib 4.0.25, for pc-linux-gnu on i686
(C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.0.25-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 2 days 20 hours 55 min 40 sec
here is an additonal info for question 6,7 you editing php.ini using pico / nano text editor ?
search for word 'ZendOptimizer.so' in php.ini and should be a line similar to
zend_extension=/usr/local/lib/Zend/ZendOptimizer.so
#If you have any other info about this subject , Please add it free.# |
