[Server Optimization Request] -- Club Bleach

محروم.كوم · #1 06-12-2009, 10:40 PM

<div>Well, I've been trying to tune our new server myself, but the Head Honcho wants me to get you guys' opinion on the optimal settings. Which I guess is a good idea, since many of you have more experience than I do, but I was still hoping to get the best settings myself. XD

With that in mind, here's the information about our server:

1. Type: VPS

2. Sys Info:
grep "model name" /proc/cpuinfo returns this:
model name : Intel(R) Xeon(R) CPU L5320 @ 1.86GHz
model name : Intel(R) Xeon(R) CPU L5320 @ 1.86GHz
model name : Intel(R) Xeon(R) CPU L5320 @ 1.86GHz
model name : Intel(R) Xeon(R) CPU L5320 @ 1.86GHz
model name : Intel(R) Xeon(R) CPU L5320 @ 1.86GHz
model name : Intel(R) Xeon(R) CPU L5320 @ 1.86GHz
model name : Intel(R) Xeon(R) CPU L5320 @ 1.86GHz
model name : Intel(R) Xeon(R) CPU L5320 @ 1.86GHz

grep MemTotal /proc/meminfo returns this:
MemTotal: 524288 kB

fdisk -l tells me I'm not allowed to open /proc/partitions. XP So I can't really tell ye what type of disk, I suppose. But df -h returns this:
Filesystem Size Used Avail Use% Mounted on
/dev/vzfs 40G 8.6G 32G 22% /
simfs 40G 8.6G 32G 22% /tmp
simfs 40G 8.6G 32G 22% /var/tmp

uname -a returns this:
Linux chrisnguyen.fbyneserv.com 2.6.9-023stab048.6-smp #1 SMP Mon Nov 17 18:41:14 MSK 2008 i686 i686 i386 GNU/Linux

Apache: Apache/2.2.8 (Unix)
MySQL: Ver 14.12 Distrib 5.0.58, for redhat-linux-gnu (i686) using readline 5.1

3. vBulletin version 3.8.3 (we generally update as soon as there is an update)

4. (no longer applicable, really?)

5. We used Jason's Yum Repository as we're running CentOS 5.3

6. top stats:
Code:
top - 13:52:35 up 6 days, 15:17, 1 user, load average: 0.65, 0.51, 0.46
Tasks: 29 total, 2 running, 27 sleeping, 0 stopped, 0 zombie
Cpu0 : 0.0% us, 0.0% sy, 0.0% ni, 100.0% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu1 : 5.6% us, 0.0% sy, 0.0% ni, 94.4% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu2 : 4.0% us, 0.0% sy, 0.0% ni, 96.0% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu3 : 0.3% us, 0.3% sy, 0.0% ni, 99.3% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu4 : 11.0% us, 0.3% sy, 0.0% ni, 88.7% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu5 : 3.3% us, 0.0% sy, 0.0% ni, 96.7% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu6 : 0.0% us, 0.0% sy, 0.0% ni, 100.0% id, 0.0% wa, 0.0% hi, 0.0% si
Cpu7 : 0.0% us, 0.0% sy, 0.0% ni, 100.0% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 524288k total, 333060k used, 191228k free, 0k buffers
Swap: 0k total, 0k used, 0k free, 0k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
26471 apache 15 0 74688 21m 9600 S 11.0 4.2 0:02.47 httpd
27755 apache 15 0 78412 27m 11m S 5.7 5.4 0:06.07 httpd
17748 apache 15 0 75516 26m 13m S 4.0 5.2 0:08.69 httpd
21615 mysql 16 0 367m 175m 5532 S 2.3 34.2 32:56.92 mysqld
7379 apache 16 0 73648 21m 10m S 2.3 4.2 0:02.14 httpd
1 root 15 0 1984 648 560 S 0.0 0.1 0:01.18 init

11855 root 16 0 1648 576 484 S 0.0 0.1 0:05.57 syslogd
11927 root 16 0 7048 1044 656 S 0.0 0.2 0:23.62 sshd
11961 root 18 0 2640 864 700 S 0.0 0.2 0:00.00 xinetd
13317 root 16 0 3228 1100 576 S 0.0 0.2 0:00.49 crond
13433 root 18 0 5492 692 424 S 0.0 0.1 0:00.00 saslauthd
13434 root 18 0 5492 432 164 S 0.0 0.1 0:00.00 saslauthd
23622 smmsp 16 0 8112 1468 616 S 0.0 0.3 0:00.04 sendmail
23626 root 16 0 9020 1860 792 S 0.0 0.4 0:05.32 sendmail
32179 root 16 0 10084 2844 2280 R 0.0 0.5 0:03.72 sshd
3929 root 15 0 2516 1420 1144 S 0.0 0.3 0:00.24 bash
5564 root 15 0 10076 2840 2268 S 0.0 0.5 0:01.45 sshd
5569 root 15 0 6600 1600 1196 S 0.0 0.3 0:00.27 sftp-server
21529 root 17 0 2328 1100 944 S 0.0 0.2 0:00.01 mysqld_safe
19996 root 16 0 65432 7628 4532 S 0.0 1.5 0:00.05 httpd
19997 root 15 0 7112 1560 1228 S 0.0 0.3 0:00.00 rotatelogs
19998 root 15 0 7112 1564 1228 S 0.0 0.3 0:00.40 rotatelogs
20018 apache 16 0 75316 31m 18m S 0.0 6.2 1:05.01 httpd
10201 apache 16 0 74516 26m 13m S 0.0 5.1 0:09.70 httpd
5991 apache 15 0 75136 23m 10m S 0.0 4.5 0:01.38 httpd
7401 apache 16 0 74436 21m 9716 S 0.0 4.2 0:00.33 httpd
7402 apache 16 0 75496 23m 10m S 0.0 4.7 0:01.56 httpd
7409 apache 16 0 76236 22m 9008 S 0.0 4.4 0:01.95 httpd
13411 root 16 0 2124 1016 820 R 0.0 0.2 0:00.00 top

7. /etc/my.cnf
Code:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
old_passwords=1

##log-slow-queries = slow_queries.10sec.log
##long_query_time = 10
thread_cache_size = 24
key_buffer_size = 128M
query_cache_size = 96M
query_cache_limit = 4M
query_cache_type = 1
table_cache = 1024
low-priority-updates = TRUE
concurrent_insert = 2
delay_key_write = all
max_connections = 60
open_files_limit = 4096
max_heap_table_size = 32M
tmp_table_size = 32M

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[ndbd]
connect-string="nodeid=2;host=localhost:1186"

[ndb_mgm]
connect-string="host=localhost:1186"

8. MySQL stats
mysqladmin -u root -p var ext stat ver proc
<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 | 8384512 |
| bdb_home | /var/lib/mysql/ |
| bdb_log_buffer_size | 262144 |
| 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 | 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 | ALL |
| 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. 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-26-2009 01:40 AM
Server Optimization Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	04-26-2009 01:30 AM
Server Optimization Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	04-26-2009 01:21 AM