Server Optimizing Request

محروم.كوم · #1 05-14-2009, 01:30 PM

<div>1. Is this on dedicated Yes, Dedicated.
2. your server specs. For example:

cpu speed/type single or dual cpus): Dual XEON 5410 @ 2.33 ghz
how much memory installed: 16GB ram
hard drive type/configuration: 500GB (SCSI device sda: 976773168 512-byte hdwr sectors (500108 MB)
linux distributor or windows version: CentOS release 5.3
apache/IIS version: Apache 2.2
PHP version: php 5.2.8
MySQL version: mysql 5.0.67-community

3. what version of vB are you running ? 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 via whm
6. your top stats. So log into your server via ssh telnet as root user and type the command in bold - top

Code:
top - 22:44:52 up 17:15, 1 user, load average: 5.97, 5.80, 4.87
Tasks: 438 total, 5 running, 432 sleeping, 0 stopped, 1 zombie
Cpu(s): 55.5%us, 2.9%sy, 0.0%ni, 41.1%id, 0.1%wa, 0.0%hi, 0.4%si, 0.0%st

Mem: 16636472k total, 16194456k used, 442016k free, 193764k buffers
Swap: 4096564k total, 8k used, 4096556k free, 13359324k cached
Code:
top - 22:46:16 up 17:16, 1 user, load average: 5.38, 5.71, 4.92
Tasks: 438 total, 3 running, 435 sleeping, 0 stopped, 0 zombie
Cpu0 : 55.8%us, 4.0%sy, 0.0%ni, 40.2%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 55.1%us, 2.0%sy, 0.0%ni, 42.9%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 46.0%us, 2.0%sy, 0.0%ni, 52.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 79.1%us, 3.7%sy, 0.0%ni, 15.3%id, 0.3%wa, 0.0%hi, 1.7%si, 0.0%st
Cpu4 : 58.1%us, 3.3%sy, 0.0%ni, 38.5%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu5 : 61.1%us, 3.0%sy, 0.0%ni, 35.9%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu6 : 52.0%us, 1.7%sy, 0.0%ni, 46.0%id, 0.0%wa, 0.0%hi, 0.3%si, 0.0%st
Cpu7 : 61.4%us, 3.3%sy, 0.0%ni, 35.0%id, 0.0%wa, 0.0%hi, 0.3%si, 0.0%st
Mem: 16636472k total, 16204440k used, 432032k free, 192728k buffers
Swap: 4096564k total, 8k used, 4096556k free, 13372904k cached
7. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf or my.ini so post the contents inside of my.cnf (minus any passwords of course).

Code:
#set-variable = max_connections=500
#safe-show-database

[client]
port = 3306
socket = /var/lib/mysql/mysql.sock

[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
safe-show-database
#old_passwords
back_log = 50
skip-innodb
max_connections = 500
key_buffer_size = 144M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 4000
thread_cache_size = 256
wait_timeout = 180
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
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 = 10M
query_cache_size = 96M
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]
nice = -10
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
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 | / |
| 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__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
Server Optimizing Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-18-2009 09:10 PM
Server Optimizing Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-11-2009 01:30 AM
Server Optimizing Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-02-2009 11:10 AM
Server Optimizing Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-01-2009 03:00 PM
Server Optimizing Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-01-2009 01:40 PM