|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
<div>1. Is this on dedicated or shared virual server. If shared, how many sites share this server (ask web host if needed) Dedicated 2. your server specs. Dual Xeon E5405 Quad Core (Harpertown) 8GB memory Dual 1TB SATA / Hardware Raid 1 Drives Centos 5 64 bit Apache 2.2 PHP 5.29 MySQL 5.067 3. what version of vB are you running ? 3.75 4. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ? N/A 5. if possible how mysql was compiled/installed cPanel. 6. your top stats. So log into your server via ssh telnet as root user and type the command in bold - top top - 2127 up 86 days, 18:54, 4 users, load average: 2.96, 3.70, 4.07 Tasks: 266 total, 4 running, 262 sleeping, 0 stopped, 0 zombie Cpu0 : 25.2%us, 0.7%sy, 0.0%ni, 74.1%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu1 : 25.5%us, 2.3%sy, 0.0%ni, 65.2%id, 6.6%wa, 0.0%hi, 0.3%si, 0.0%st Cpu2 : 31.6%us, 2.3%sy, 0.0%ni, 66.1%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu3 : 25.3%us, 2.3%sy, 0.0%ni, 72.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu4 : 25.2%us, 1.0%sy, 0.0%ni, 73.8%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu5 : 21.7%us, 1.7%sy, 0.0%ni, 76.0%id, 0.7%wa, 0.0%hi, 0.0%si, 0.0%st Cpu6 : 14.0%us, 2.3%sy, 0.0%ni, 83.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Cpu7 : 38.7%us, 11.3%sy, 0.0%ni, 47.0%id, 0.0%wa, 0.7%hi, 2.3%si, 0.0%st Mem: 8174408k total, 6340956k used, 1833452k free, 78940k buffers Swap: 8385920k total, 375540k used, 8010380k free, 3543824k cached 7. your mysql configuration variables located at /etc/my.cnf [mysqld] skip-name-resolve safe-show-database #old_passwords back_log = 50 skip-innodb max_connections = 500 key_buffer_size = 96M myisam_sort_buffer_size = 64M join_buffer_size = 1M read_buffer_size = 1M sort_buffer_size = 2M table_cache = 4000 thread_cache_size = 384 wait_timeout = 30 connect_timeout = 10 tmp_table_size = 64M max_heap_table_size = 64M max_allowed_packet = 64M net_buffer_length = 16384 max_connect_errors = 100000 thread_concurrency = 8 concurrent_insert = 2 table_lock_wait_timeout = 30 read_rnd_buffer_size = 786432 bulk_insert_buffer_size = 8M query_cache_limit = 3M query_cache_size = 64M 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 = 4 [mysqld_safe] nice = -10 open_files_limit = 8192 [mysqldump] quick max_allowed_packet = 16M [myisamchk] key_buffer = 128M sort_buffer = 64M read_buffer = 16M write_buffer = 16M 8. MySQL stats from ssh telnet +---------------------------------+-------------------------------------------+ | 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__ |
مواقع النشر (المفضلة) |
| |
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
New Server Optimization Request | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 07-04-2009 05:40 AM |
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 - Please help! Server loads way too high! | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 05-05-2009 02:00 AM |
Server Optimization Request | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 04-20-2009 03:30 PM |