Server Optimization Request

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

<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. For example:

cpu speed/type single or dual cpus): quad 9550 2.83ghz
how much memory installed: 8gb ram
hard drive type/configuration: 2x320GB SATA non raid
linux distributor or windows version: centos 5.3
apache/IIS version: apache 2.2.11
PHP version: php 5.2.9
MySQL version: mysql 5.0.67

3. what version of vB are you running ?

*3.7.3

4. if you use mysql 4.x instead of mysql 3.23.x, do you have any innodb type databases/tables on your server ?

*i dont have innodb type tables.

5. if possible how mysql was compiled/installed

*installed by hosting provider.

6. your top stats. So log into your server via ssh telnet as root user and type the command in bold - top

Code:
top - 17:59:34 up 25 min, 3 users, load average: 2.68, 4.09, 10.26
Tasks: 252 total, 3 running, 248 sleeping, 0 stopped, 1 zombie
Cpu(s): 28.2%us, 2.3%sy, 0.0%ni, 66.6%id, 2.6%wa, 0.1%hi, 0.2%si, 0.0%st
Mem: 8168768k total, 3740084k used, 4428684k free, 77016k buffers
Swap: 4200988k total, 0k used, 4200988k free, 1527824k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
14851 nobody 16 0 273m 25m 4476 S 11.6 0.3 0:04.56 httpd
9640 mysql 15 0 216m 36m 4004 S 10.3 0.5 1:32.50 mysqld
16614 nobody 15 0 272m 24m 4472 S 9.3 0.3 0:02.83 httpd
16369 nobody 16 0 270m 23m 4448 S 9.0 0.3 0:02.67 httpd
15929 nobody 16 0 273m 25m 4476 R 8.6 0.3 0:02.60 httpd
15031 nobody 16 0 270m 23m 4680 S 7.3 0.3 0:04.35 httpd
17208 nobody 15 0 269m 21m 4444 S 7.3 0.3 0:00.33 httpd
12839 nobody 15 0 270m 22m 4656 S 6.6 0.3 0:05.50 httpd
16684 nobody 15 0 268m 21m 4472 S 6.3 0.3 0:01.60 httpd
16173 nobody 16 0 272m 24m 4472 S 6.0 0.3 0:01.93 httpd
16662 nobody 16 0 268m 21m 4460 S 6.0 0.3 0:01.38 httpd
16679 nobody 15 0 276m 27m 4468 S 5.3 0.4 0:03.11 httpd
16329 nobody 15 0 272m 24m 4432 R 3.7 0.3 0:02.11 httpd
17207 nobody 16 0 264m 16m 4296 S 3.7 0.2 0:00.23 httpd
15021 nobody 15 0 273m 26m 4528 S 2.3 0.3 0:08.43 httpd
12693 nobody 16 0 274m 26m 4820 S 2.0 0.3 0:03.98 httpd
12763 nobody 16 0 265m 18m 4660 S 2.0 0.2 0:04.60 httpd
17188 nobody 16 0 267m 19m 4440 S 2.0 0.2 0:00.25 httpd
13343 nobody 16 0 273m 26m 4660 S 1.3 0.3 0:04.93 httpd
15603 nobody 15 0 271m 23m 4464 S 1.3 0.3 0:03.26 httpd
16586 nobody 16 0 268m 21m 4464 S 1.3 0.3 0:01.48 httpd
16606 nobody 15 0 268m 21m 4368 S 1.3 0.3 0:00.87 httpd
16672 nobody 15 0 273m 25m 4492 S 1.3 0.3 0:01.37 httpd
17203 nobody 15 0 264m 16m 4304 S 1.3 0.2 0:00.15 httpd
12790 nobody 16 0 269m 21m 4680 S 1.0 0.3 0:06.08 httpd
15564 nobody 16 0 275m 26m 5096 S 1.0 0.3 0:02.79 httpd
16685 nobody 15 0 268m 21m 4464 S 1.0 0.3 0:01.20 httpd
3588 nobody 15 0 42240 25m 384 S 0.7 0.3 0:10.53 memcached
10087 nobody 15 0 273m 26m 4684 S 0.7 0.3 0:09.46 httpd
17186 nobody 15 0 272m 25m 4472 S 0.7 0.3 0:00.47 httpd
2053 root 11 -5 0 0 0 S 0.3 0.0 0:00.08 kjournald
4623 root 16 0 12872 1324 812 S 0.3 0.0 0:02.98 top
1 root 15 0 10348 692 576 S 0.0 0.0 0:01.63 init
2 root RT -5 0 0 0 S 0.0 0.0 0:00.00 migration/0
3 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0
4 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/0
5 root RT -5 0 0 0 S 0.0 0.0 0:00.01 migration/1
6 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
7 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/1
8 root RT -5 0 0 0 S 0.0 0.0 0:00.00 migration/2
9 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/2
10 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/2
11 root RT -5 0 0 0 S 0.0 0.0 0:00.00 migration/3
12 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/3

13 root RT -5 0 0 0 S 0.0 0.0 0:00.00 watchdog/3
14 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/0
15 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/1
16 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/2
17 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/3
18 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 khelper
89 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kthread
96 root 10 -5 0 0 0 S 0.0 0.0 0:00.01 kblockd/0
97 root 10 -5 0 0 0 S 0.0 0.0 0:00.15 kblockd/1
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).

<div style="margin:20px; margin-top:5px"> Code:
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 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
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 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
Server Optimization Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	04-20-2009 03:30 PM