|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
<div>hi, I have been running my forums fine for a couple of years, but recently my loads have been going through the roof and I can't figure out why. 1- on a vps with 1gb ram 2- xcache 1.2 apache 2.2.11 php 5.2.9 mysql 5.0.67-community cpanel 11.24 CENTOS 5.3 x86_64 virtuozzo on server 3- vb 3.7.3 pl1 4- no innodb 5- mysql came with cpanel 6- top - 1522 up 22:31, 1 user, load average: 6.63, 4.17, 3.15 Tasks: 81 total, 1 running, 79 sleeping, 0 stopped, 1 zombie Cpu0 : 0.3%us, 0.3%sy, 0.0%ni, 52.6%id, 46.7%wa, 0.0%hi, 0.0%si, 0.0%st Cpu1 : 2.7%us, 0.3%sy, 0.0%ni, 54.7%id, 42.2%wa, 0.0%hi, 0.0%si, 0.0%st Cpu2 : 0.3%us, 0.0%sy, 0.0%ni, 53.0%id, 46.7%wa, 0.0%hi, 0.0%si, 0.0%st Cpu3 : 0.0%us, 0.7%sy, 0.0%ni, 99.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu4 : 4.3%us, 0.3%sy, 0.0%ni, 95.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu5 : 0.3%us, 0.0%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu6 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu7 : 4.0%us, 0.7%sy, 0.0%ni, 37.6%id, 57.7%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 1048576k total, 290208k used, 758368k free, 0k buffers Swap: 0k total, 0k used, 0k free, 0k cached Unknown command - try 'h' for help PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 26288 nobody 15 0 120m 10m 3860 S 4.3 1.0 0:00.15 httpd 4035 nobody 16 0 122m 12m 4156 D 3.7 1.2 0:00.58 httpd 20128 nobody 15 0 125m 15m 4508 S 2.7 1.5 0:01.12 httpd 8094 root 15 0 12604 1260 928 R 0.7 0.1 0:00.70 top 27688 mysql 5 -10 266m 97m 4472 S 0.7 9.5 4:32.21 mysqld 5176 nobody 15 0 123m 13m 3956 D 0.3 1.3 0:00.36 httpd 26584 nobody 15 0 127m 16m 4064 D 0.3 1.6 0:01.04 httpd 27823 nobody 15 0 120m 8856 3476 D 0.3 0.8 0:00.02 httpd 27877 nobody 16 0 121m 10m 3912 D 0.3 1.1 0:00.20 httpd 1 root 15 0 10344 724 608 S 0.0 0.1 0:01.65 init 1497 nobody 15 0 120m 9940 3988 S 0.0 0.9 0:00.19 httpd 1513 nobody 16 0 121m 10m 3856 D 0.0 1.0 0:00.13 httpd 3459 root 16 -4 12600 644 356 S 0.0 0.1 0:00.00 udevd 4077 nobody 15 0 120m 10m 3768 S 0.0 1.0 0:00.12 httpd 5151 root 18 0 0 0 0 Z 0.0 0.0 0:00.02 cpsrvd-ssl 5175 nobody 18 0 121m 10m 3704 D 0.0 1.0 0:00.09 httpd 7212 named 18 0 6544 684 440 S 0.0 0.1 0:00.00 nsd 7213 named 24 0 13408 708 244 S 0.0 0.1 0:00.00 nsd 7214 named 18 0 6848 764 408 S 0.0 0.1 0:02.31 nsd 7273 named 18 0 284m 4528 1904 S 0.0 0.4 0:00.38 named 7979 root 19 0 46896 1480 804 S 0.0 0.1 0:00.00 crond 7986 root 18 0 46896 1480 804 S 0.0 0.1 0:00.00 crond 7998 root 18 0 8664 1160 940 S 0.0 0.1 0:00.00 bfd 8025 root 18 0 3840 648 552 D 0.0 0.1 0:00.01 sadc 8050 root 18 0 8672 1200 952 S 0.0 0.1 0:00.00 bfd 11269 root 15 0 60672 1192 640 S 0.0 0.1 0:00.40 sshd 11603 root 18 0 21644 888 684 S 0.0 0.1 0:00.00 xinetd 14298 root 15 0 10892 1556 1132 S 0.0 0.1 0:00.05 bash 14310 root 15 0 6064 628 472 S 0.0 0.1 0:00.90 dovecot 14311 root 15 0 14744 1008 796 S 0.0 0.1 0:00.52 dovecot-auth 7- [mysqld] #skip-name-resolve safe-show-database old_passwords back_log = 50 skip-innodb max_connections = 500 key_buffer_size = 24M myisam_sort_buffer_size = 64M join_buffer_size = 1M read_buffer_size = 1M sort_buffer_size = 2M table_cache = 4000 thread_cache_size = 128 wait_timeout = 20 connect_timeout = 10 tmp_table_size = 32M max_heap_table_size = 32M max_allowed_packet = 32M net_buffer_length = 16384 max_connect_errors = 10 thread_concurrency = 8 concurrent_insert = 2 table_lock_wait_timeout = 30 read_rnd_buffer_size = 786432 bulk_insert_buffer_size = 8M query_cache_limit = 1M query_cache_size = 16M query_cache_type = 1 query_prealloc_size = 262144 query_alloc_block_size = 65536 transaction_alloc_block_size = 8192 transaction_prealloc_size = 4096 default-storage-engine = MyISAM max_write_lock_count = 16 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid nice = -10 open_files_limit = 8192 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer = 64M sort_buffer = 16M read_buffer = 16M write_buffer = 16M 8- +---------------------------------+----------------------------------------------+ | Variable_name | Value | +---------------------------------+----------------------------------------------+ | auto_increment_increment | 1 | | auto_increment_offset | 1 | | automatic_sp_privileges | ON | | back_log | 50 | | 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 | 2 | | connect_timeout | 10 | | 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__ |
مواقع النشر (المفضلة) |
| |
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
High load vBulletin | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 06-02-2009 08:50 PM |
Server Optimization Request !!!! (I have a high load problem) | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 06-02-2009 05:50 PM |
vps optimization for high load | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 05-19-2009 05:50 PM |
Very High Server Load || Optimization Request! | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 05-10-2009 02:40 PM |
I have a high load problem | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 04-25-2009 12:30 AM |