|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#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 - nonshared 2. your server specs. cpu speed/type single or dual cpus): dual p4 3ghz how much memory installed: 2Gig ram hard drive type/configuration: 200GB EIDE non raid linux distributor or windows version: Centos 5 apache/IIS version: apache 2 PHP version: php 5.2.5 3. what version of vB are you running ? Version 3.8.2 4. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ? no 5. if possible how mysql was compiled/installed no idea was isntalled via yum 6. your top stats. So log into your server via ssh telnet as root user and type the command in bold - top Code: top - 21:33:43 up 1 day, 11:10, 1 user, load average: 0.54, 0.50, 0.59 Tasks: 101 total, 2 running, 99 sleeping, 0 stopped, 0 zombie Cpu(s): 31.0% us, 3.6% sy, 0.0% ni, 64.8% id, 0.1% wa, 0.0% hi, 0.4% si Mem: 1260696k total, 314856k used, 945840k free, 55064k buffers Swap: 0k total, 0k used, 0k free, 119220k cached Now while top is running hit the number 1 on keyboard to show break down of cpu load over all cpu cores Code: top - 21:35:25 up 1 day, 11:11, 1 user, load average: 0.30, 0.44, 0.55 Tasks: 101 total, 1 running, 100 sleeping, 0 stopped, 0 zombie Cpu0 : 7.7% us, 0.5% sy, 0.0% ni, 91.9% id, 0.0% wa, 0.0% hi, 0.0% si Mem: 1260696k total, 300488k used, 960208k free, 55160k buffers Swap: 0k total, 0k used, 0k free, 119396k cached 7. your mysql configuration variables located at /etc/my.cnf Code: # The following options will be passed to all MySQL clients [client] socket=/tmp/mysql.sock # The MySQL server [mysqld] tmpdir=/tmp socket=/tmp/mysql.sock skip-locking # skip-networking skip-name-resolve server-id=1 max_connections=500 key_buffer_size=512M max_allowed_packet=16M table_cache=256 sort_buffer_size=16M read_buffer_size=16M join_buffer_size=5M # if you are performing GROUP BY or ORDER BY queries on tables that # are much larger than your available memory, you should increase # the value of read_rnd_buffer_size to speed up the reading of rows # following sorting operations. # but: change the session variable only from within those clients # that need to run large queries read_rnd_buffer_size=4M max_heap_table_size=256M tmp_table_size=256M myisam_sort_buffer_size=64M # increase until threads_created doesnt grow anymore thread_cache=256 query_cache_type=1 query_cache_limit=1M query_cache_size=32M # Try number of CPU's*2 for thread_concurrency thread_concurrency=4 [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] key_buffer=128M sort_buffer_size=128M read_buffer=2M write_buffer=2M [myisamchk] key_buffer=128M sort_buffer_size=128M read_buffer=2M write_buffer=2M [mysqlhotcopy] interactive-timeout 8. MySQL stats from ssh telnet as root user type: <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 | 50 | | basedir | /usr/ | | bdb_cache_size | 8388600 | | bdb_home | /var/lib/mysql/ | | bdb_log_buffer_size | 131072 | | bdb_logdir | | | bdb_max_lock | 10000 | | bdb_shared_data | OFF | | bdb_tmpdir | /tmp/ | | 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 | 5 | | 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 | | engine_condition_pushdown | OFF | | expire_logs_days | 0 | | flush | OFF | | flush_time | 0 | | ft_boolean_syntax | + -> __DEFINE_LIKE_SHARE__ |
مواقع النشر (المفضلة) |
| |
المواضيع المتشابهه | ||||
الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
Web Server + DB Server Optimization Request | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 07-29-2009 08:30 PM |
Web Server + DB Server Optimization Request | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 07-29-2009 08: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 |