Server Optimization Request

محروم.كوم · #1 04-20-2009, 03:30 PM

<div>>1. Is this on dedicated or shared virual server.

Dedicated

>2. your server specs.

cpu speed/type single or dual cpus): dual p4 xeon 3.2 GHz 800 FSB
how much memory installed: 4GB ram
hard drive type/configuration: 2 73 GB SCSI:Ultra 320 10krpm non raid
linux distributor or windows version: redhat enterprise 5 update 3
apache/IIS version: apache 2.2.3
PHP version: php 5.1.6
MySQL version: mysql 5.0.45

>3. what version of vB are you running
3.8.1 pl1

>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
stock RedHat distribution

>6. your top stats.

bad day:
Code:
top - 0350 up 49 days, 23:24, 1 user, load average: 84.32, 58.55, 34.25
Tasks: 554 total, 22 running, 532 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.5%us, 30.8%sy, 0.0%ni, 0.0%id, 68.4%wa, 0.1%hi, 0.2%si, 0.0%st
Mem: 4147876k total, 3995044k used, 152832k free, 1120k buffers
Swap: 2040244k total, 1425148k used, 615096k free, 37708k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
194 root 17 -5 0 0 0 R 95.5 0.0 37:00.01 kswapd0
19261 apache 16 0 80212 22m 5092 D 6.3 0.5 0:01.23 httpd
18584 apache 16 0 78460 18m 5088 D 6.1 0.5 0:01.06 httpd

18941 apache 16 0 78652 19m 4948 D 5.3 0.5 0:00.91 httpd
18887 apache 17 0 78488 17m 4988 D 5.1 0.4 0:00.60 httpd
18389 apache 16 0 81056 19m 5216 D 4.8 0.5 0:01.34 httpd
20052 22006 16 0 6788 2988 2480 D 4.6 0.1 0:00.29 ipop3d
18811 apache 16 0 80232 21m 5044 D 4.3 0.5 0:00.43 httpd
18888 apache 16 0 80088 18m 5084 D 4.1 0.5 0:00.55 httpd
17995 mysql 16 0 962m 505m 3708 D 3.8 12.5 2322:50 mysqld
18571 apache 18 0 80916 18m 5092 R 3.8 0.5 0:00.47 httpd
18896 apache 16 0 80200 17m 5044 D 3.5 0.4 0:00.46 httpd
20042 admin22 16 0 14028 5824 4064 D 3.3 0.1 0:00.19 php-cgi
20155 admin10 18 0 1784 392 320 D 3.3 0.0 0:00.14 Survivor.cgi
16972 apache 16 0 83352 18m 5368 D 3.0 0.5 0:07.26 httpd
20000 admin3 16 0 27644 12m 5496 S 3.0 0.3 0:00.52 php-cgi
19101 apache 16 0 80336 22m 5124 D 2.5 0.5 0:11.01 httpd
18826 apache 16 0 78624 18m 5072 D 1.8 0.4 0:03.60 httpd

top - 03:18:00 up 49 days, 23:24, 1 user, load average: 86.49, 59.86, 34.93
Tasks: 545 total, 1 running, 544 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.6%us, 2.6%sy, 0.0%ni, 0.0%id, 95.7%wa, 0.0%hi, 0.2%si, 0.0%st
Mem: 4147876k total, 3996300k used, 151576k free, 1552k buffers
Swap: 2040244k total, 1428944k used, 611300k free, 42360k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
17995 mysql 15 0 962m 495m 3704 S 1.0 12.2 2322:50 mysqld
19300 apache 16 0 80196 22m 5136 S 1.0 0.5 0:00.94 httpd
16349 apache 16 0 84824 18m 5640 D 0.7 0.5 0:08.58 httpd
17091 apache 18 0 83456 19m 5328 D 0.7 0.5 0:08.38 httpd
18427 apache 18 0 80776 22m 5160 S 0.7 0.6 0:00.29 httpd
18811 apache 16 0 80232 21m 5044 D 0.7 0.5 0:00.45 httpd
19000 apache 18 0 80348 20m 5152 D 0.7 0.5 0:00.49 httpd
19040 apache 16 0 80196 22m 5140 S 0.7 0.5 0:00.69 httpd
19083 apache 18 0 80196 21m 5124 S 0.7 0.5 0:03.68 httpd

19301 apache 16 0 80200 22m 5148 S 0.7 0.6 0:00.75 httpd
19864 admin 15 0 2484 1316 808 R 0.7 0.0 0:02.31 top
16627 apache 18 0 82536 21m 5832 D 0.3 0.5 0:08.27 httpd
17501 apache 18 0 81932 19m 5336 D 0.3 0.5 0:04.99 httpd
17792 apache 18 0 82576 16m 5340 D 0.3 0.4 0:02.56 httpd
18326 apache 16 0 79772 17m 5056 D 0.3 0.4 0:01.06 httpd
18356 apache 17 0 80916 18m 5128 D 0.3 0.5 0:00.57 httpd
18547 apache 16 0 80916 21m 5128 D 0.3 0.5 0:00.46 httpd
18584 apache 16 0 78460 18m 5088 D 0.3 0.5 0:01.09 httpd
18589 apache 16 0 80748 22m 5132 D 0.3 0.5 0:00.68 httpd
18746 apache 16 0 79736 18m 5064 D 0.3 0.5 0:00.53 httpd

top - 03:18:15 up 49 days, 23:24, 1 user, load average: 89.21, 61.76, 35.96
Tasks: 553 total, 1 running, 552 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.5%us, 9.4%sy, 0.0%ni, 0.0%id, 88.8%wa, 0.1%hi, 0.2%si, 0.0%st
Mem: 4147876k total, 3993976k used, 153900k free, 1656k buffers
Swap: 2040244k total, 1457380k used, 582864k free, 42848k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
17995 mysql 18 0 962m 491m 3704 D 2.3 12.1 2322:50 mysqld
19302 apache 18 0 80504 22m 5156 S 2.3 0.6 0:00.67 httpd
194 root 10 -5 0 0 0 D 1.3 0.0 37:00.08 kswapd0
17393 apache 16 0 81700 18m 5512 D 1.3 0.5 0:02.49 httpd
16349 apache 16 0 84824 18m 5636 D 1.0 0.5 0:08.62 httpd
16972 apache 16 0 83352 18m 5368 D 1.0 0.5 0:07.30 httpd
18327 apache 16 0 77684 17m 4636 D 1.0 0.4 0:01.10 httpd
18543 apache 16 0 80196 18m 5044 D 1.0 0.5 0:00.57 httpd
18657 apache 16 0 80492 18m 5136 D 1.0 0.5 0:03.98 httpd
18811 apache 16 0 80232 21m 5044 D 1.0 0.5 0:00.50 httpd
18888 apache 16 0 80088 18m 5084 D 1.0 0.5 0:00.65 httpd
18941 apache 16 0 78652 19m 4948 D 1.0 0.5 0:00.99 httpd
19041 apache 16 0 77864 19m 5060 D 1.0 0.5 0:00.49 httpd
19252 apache 16 0 78008 18m 4688 D 1.0 0.4 0:00.29 httpd
19279 apache 16 0 78572 18m 5088 D 1.0 0.5 0:01.08 httpd
19285 apache 18 0 80084 21m 5080 S 1.0 0.5 0:00.74 httpd
19864 admin 15 0 2484 1316 808 R 1.0 0.0 0:02.44 top
not so good day
Code:
top - 23:01:31 up 42 days, 19:07, 1 user, load average: 17.33, 17.68, 20.86
Tasks: 283 total, 7 running, 275 sleeping, 0 stopped, 1 zombie
Cpu0 : 91.7%us, 7.6%sy, 0.0%ni, 0.3%id, 0.3%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 89.9%us, 7.3%sy, 0.0%ni, 0.0%id, 0.9%wa, 0.3%hi, 1.5%si, 0.0%st
Cpu2 : 91.4%us, 7.4%sy, 0.0%ni, 1.2%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 90.2%us, 9.5%sy, 0.0%ni, 0.0%id, 0.3%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 4147876k total, 3093688k used, 1054188k free, 65488k buffers
Swap: 2040244k total, 178940k used, 1861304k free, 839708k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
17995 mysql 15 0 861m 400m 4288 S 54.8 9.9 169:09.47 mysqld
19941 apache 16 0 83564 30m 8220 R 26.8 0.8 0:40.79 httpd
28059 apache 15 0 81044 26m 5896 S 26.5 0.6 0:01.02 httpd
26583 apache 16 0 83048 30m 8648 R 25.5 0.8 0:07.76 httpd
28110 apache 15 0 80252 24m 5468 S 25.2 0.6 0:01.00 httpd
26597 apache 15 0 81064 27m 7120 S 24.9 0.7 0:10.76 httpd
28171 apache 15 0 80672 26m 6140 S 24.0 0.6 0:00.90 httpd
28170 apache 15 0 83228 30m 8164 S 19.9 0.8 0:02.20 httpd
25437 apache 16 0 84360 32m 8916 R 19.5 0.8 0:09.24 httpd
28124 apache 15 0 80068 24m 5424 S 18.3 0.6 0:00.96 httpd
28442 admin19 19 0 25320 9.8m 5520 R 17.7 0.2 0:01.30 php-cgi
28256 admin19 19 0 26532 10m 5492 R 12.9 0.3 0:07.33 php-cgi
28164 apache 15 0 83920 30m 7260 S 5.7 0.7 0:01.56 httpd
25874 apache 15 0 83188 30m 7988 S 4.1 0.7 0:14.26 httpd
27086 apache 15 0 81480 27m 7364 S 4.1 0.7 0:03.30 httpd
26873 apache 15 0 81032 26m 6668 S 3.2 0.7 0:03.53 httpd
22564 root 15 0 195m 44m 3156 S 2.8 1.1 0:54.42 python
24692 apache 15 0 82752 29m 7632 S 2.8 0.7 0:11.65 httpd
28045 apache 15 0 81224 26m 5892 S 2.8 0.7 0:01.42 httpd

top - 23:01:53 up 42 days, 19:08, 1 user, load average: 24.09, 19.17, 21.28
Tasks: 290 total, 18 running, 271 sleeping, 0 stopped, 1 zombie
Cpu0 : 94.4%us, 5.3%sy, 0.0%ni, 0.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 90.8%us, 7.3%sy, 0.0%ni, 0.0%id, 1.3%wa, 0.0%hi, 0.7%si, 0.0%st
Cpu2 : 93.4%us, 5.9%sy, 0.0%ni, 0.3%id, 0.0%wa, 0.0%hi, 0.3%si, 0.0%st
Cpu3 : 92.7%us, 7.0%sy, 0.0%ni, 0.3%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 4147876k total, 3168692k used, 979184k free, 66100k buffers
Swap: 2040244k total, 178940k used, 1861304k free, 841268k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
28256 admin19 15 0 27196 11m 5492 R 56.3 0.3 0:12.19 php-cgi
28442 admin19 16 0 25656 10m 5520 R 55.9 0.3 0:06.62 php-cgi
28564 admin19 15 0 25640 10m 5496 R 55.6 0.2 0:01.88 php-cgi
17995 mysql 16 0 887m 407m 4288 S 48.6 10.1 169:23.73 mysqld
28496 admin19 16 0 25976 10m 5520 R 48.6 0.3 0:05.37 php-cgi
26149 apache 16 0 84456 30m 6660 S 11.9 0.7 0:10.04 httpd
28122 apache 15 0 80820 26m 6012 S 8.3 0.6 0:01.15 httpd
28180 apache 16 0 82132 27m 6060 S 7.9 0.7 0:01.48 httpd
28099 apache 16 0 81220 28m 8080 S 6.6 0.7 0:01.85 httpd
28150 apache 16 0 81864 27m 5944 S 6.3 0.7 0:01.72 httpd
25891 apache 15 0 82732 29m 7460 S 4.0 0.7 0:09.87 httpd
28042 apache 18 0 82516 27m 5672 S 3.6 0.7 0:00.69 httpd
23306 apache 15 0 83592 31m 8400 S 3.3 0.8 0:22.15 httpd
27961 apache 15 0 79284 23m 4916 S 3.3 0.6 0:00.60 httpd
28059 apache 15 0 81544 26m 6012 S 3.3 0.7 0:02.44 httpd
25199 apache 15 0 82716 28m 6840 S 3.0 0.7 0:13.80 httpd
27987 apache 15 0 82484 28m 7008 S 2.6 0.7 0:01.56 httpd
28002 apache 16 0 81500 26m 6008 S 2.6 0.7 0:01.55 httpd
27884 apache 16 0 82296 27m 6144 S 2.3 0.7 0:02.61 httpd
28170 apache 15 0 0 0 0 Z 2.3 0.0 0:02.28 httpd
24785 apache 15 0 82456 28m 7224 S 2.0 0.7 0:18.74 httpd
26176 apache 16 0 82496 28m 6776 S 2.0 0.7 0:10.05 httpd
>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

Code:
[mysqld]
socket=/home/virtual/FILESYSTEMTEMPLATE/.mysqlsock/mysql.sock
datadir=/var/lib/mysql
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
max_connections = 500
log-slow-queries = /var/log/mysqld-slow.log
skip-innodb
key_buffer = 256M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 200
read_rnd_buffer_size=1M
connect_timeout = 10
tmp_table_size = 256M
max_allowed_packet = 64M
max_connect_errors = 10
thread_concurrency = 4
query_cache_limit = 2M
query_cache_size = 512M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[client]
socket=/home/virtual/FILESYSTEMTEMPLATE/.mysqlsock/mysql.sock
>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 | |
| bdb_log_buffer_size | 0 |
| bdb_logdir | |
| bdb_max_lock | 10000 |
| bdb_shared_data | OFF |
| bdb_tmpdir | |
| 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 | 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 |
| 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	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-07-2009 05:50 AM
Server Optimization Request - Please help! Server loads way too high!	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-05-2009 02:00 AM