Server Optimization Request plz

محروم.كوم · #1 04-09-2009, 05:16 AM

<div>
Some time the site is not working

I see a normal consumption of the server

1. Dedicated server
2.
Code:
Intel Core2Quad Q9300 - 2.5GHz - Yorkfield

4 Gb Ram
CentOS 5.2 - 32 Bit
Apache version2.2.11 (Unix)
PHP version5.2.9
MySQL version5.0.67-community
3. vBulletin 3.6.8
4- not sure
5- I don't know

6.

Code:
top - 19:56:45 up 18 days, 5:24, 1 user, load average: 2.02, 2.40, 2.78
Tasks: 381 total, 7 running, 372 sleeping, 1 stopped, 1 zombie
Cpu(s): 31.1%us, 10.2%sy, 0.0%ni, 58.3%id, 0.0%wa, 0.1%hi, 0.3%si, 0.0%st
Mem: 4137812k total, 3814968k used, 322844k free, 180668k buffers
Swap: 2031608k total, 80k used, 2031528k free, 1374980k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
16094 mysql 5 -10 284m 187m 3428 S 88.6 4.6 626:49.14 mysqld
25976 nobody 16 0 35720 17m 4916 S 13.3 0.4 0:07.61 httpd

26089 nobody 15 0 35676 18m 4912 S 7.0 0.5 0:07.65 httpd
26498 nobody 15 0 37208 19m 4576 S 6.6 0.5 0:02.07 httpd
25693 nobody 16 0 36100 18m 4920 S 6.3 0.5 0:13.94 httpd
26226 nobody 15 0 36900 19m 4916 S 6.0 0.5 0:04.84 httpd
26439 nobody 15 0 33584 16m 5120 S 5.0 0.4 0:04.61 httpd
24823 nobody 15 0 34748 17m 5120 S 3.6 0.4 0:15.27 httpd
25937 nobody 16 0 35856 18m 5124 S 3.0 0.5 0:06.70 httpd
26678 nobody 15 0 34648 17m 4912 S 3.0 0.4 0:04.29 httpd
26868 nobody 16 0 35296 17m 4576 R 3.0 0.4 0:01.91 httpd
23212 nobody 16 0 36176 18m 4912 S 2.3 0.5 0:11.74 httpd
24760 nobody 16 0 35068 17m 4980 S 2.3 0.4 0:07.24 httpd
26219 nobody 15 0 35340 18m 4912 S 2.3 0.4 0:02.51 httpd
26303 nobody 15 0 34876 17m 5112 S 2.3 0.4 0:04.15 httpd
26355 nobody 16 0 36172 19m 5132 S 2.3 0.5 0:02.51 httpd
26356 nobody 15 0 36160 18m 4588 S 2.3 0.5 0:04.45 httpd
7.

Code:
[mysqld]
old_passwords
back_log = 75
skip-innodb
max_connections = 300
key_buffer = 100M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
table_cache = 2000
thread_cache_size = 64
wait_timeout = 1800
connect_timeout = 30
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 128M

thread_concurrency = 8
max_connect_errors = 10
query_cache_limit = 32M
query_cache_size = 64M
long_query_time=2
query_cache_type = 1
default-storage-engine = MyISAM
[mysqld_safe]
nice = -10
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 2000M

[mysqlhotcopy]
interactive-timeout
safe-show-database
set-variable=local-infile=0
8.

<div style="margin:20px; margin-top:5px"> Code:
+---------------------------------+-----------------------------------+
| Variable_name | Value |
+---------------------------------+-----------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| automatic_sp_privileges | ON |
| back_log | 75 |
| basedir | / |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| completion_type | 0 |
| concurrent_insert | 1 |
| connect_timeout | 30 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| div_precision_increment | 4 |
| keep_files_on_create | OFF |
| engine_condition_pushdown | OFF |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -> __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
Server optimization request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-20-2009 04:10 PM
Server Optimization Request. First time optimization	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-08-2009 04:40 AM
Server Optimization Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-07-2009 05:50 AM
Server Optimization Request - Please help! Server loads way too high!	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-05-2009 02:00 AM
Server Optimization Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	04-20-2009 03:30 PM