Server Opt Request / Upgrade Suggestion Request - TIA, again!

محروم.كوم · #1 06-08-2009, 08:50 PM

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): dual AMD Opteron 246 processors
how much memory installed: 4Gig RAM
hard drive type/configuration: 36GB SCSI non raid

linux distributor or windows version: Red Hat Enterprise Linux ES 4
apache/IIS version: Apache v2.0.52
PHP version: php 5.2.9
MySQL version: mysql 5.0.81

3. what version of vB are you running ?

3.7.6

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

--------

5. if possible how mysql was compiled/installed

from the actual mysql.org

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

Code:

top - 10:56:16 up 9:45, 2 users, load average: 24.49, 24.18, 20.91
Tasks: 128 total, 37 running, 90 sleeping, 1 stopped, 0 zombie
Cpu(s): 61.2% us, 7.4% sy, 0.0% ni, 26.4% id, 5.0% wa, 0.0% hi, 0.0% si
Mem: 4091464k total, 3832100k used, 259364k free, 330856k buffers
Swap: 1052248k total, 0k used, 1052248k free, 2848900k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
3008 mysql 5 -10 592m 220m 4432 S 34.2 5.5 35:06.54 mysqld
13030 apache 16 0 32544 10m 4196 R 3.2 0.3 0:06.25 httpd
13187 apache 16 0 36312 16m 5476 R 2.9 0.4 0:05.01 httpd
13188 apache 16 0 36708 16m 5132 R 2.9 0.4 0:04.92 httpd

13277 apache 16 0 36444 15m 4120 R 2.9 0.4 0:02.21 httpd
13283 apache 16 0 31768 10m 4144 R 2.9 0.3 0:02.71 httpd
13305 apache 16 0 36540 16m 4792 R 2.9 0.4 0:03.31 httpd
13326 apache 16 0 31776 10m 4140 R 2.9 0.3 0:01.46 httpd
13042 apache 16 0 37264 16m 4148 R 2.6 0.4 0:10.71 httpd
13243 apache 16 0 36552 15m 4268 R 2.6 0.4 0:05.21 httpd
13315 apache 15 0 31516 10m 4188 S 2.6 0.3 0:03.07 httpd
13359 apache 15 0 31172 10m 4088 S 2.6 0.3 0:01.29 httpd
13246 apache 16 0 36772 16m 5272 R 2.3 0.4 0:05.05 httpd
13281 apache 16 0 37008 16m 4168 R 2.3 0.4 0:04.32 httpd
13339 apache 17 0 35984 14m 4180 R 2.3 0.4 0:01.71 httpd
13350 apache 17 0 35896 15m 4168 R 2.3 0.4 0:00.99 httpd
13274 apache 16 0 35024 14m 5232 R 1.9 0.4 0:03.26 httpd
13244 apache 16 0 33956 12m 4172 R 1.6 0.3 0:04.21 httpd
13266 apache 16 0 35260 14m 4188 R 1.6 0.4 0:05.61 httpd
13062 apache 16 0 31792 10m 4180 R 1.3 0.3 0:07.27 httpd
13251 apache 16 0 33240 12m 4196 R 1.3 0.3 0:03.11 httpd
13272 apache 16 0 34960 13m 4164 R 1.3 0.3 0:03.80 httpd
13279 apache 16 0 35488 14m 4168 R 1.3 0.4 0:03.30 httpd
13362 apache 16 0 32472 11m 4088 R 1.3 0.3 0:01.06 httpd
13363 apache 16 0 35180 14m 5052 R 1.3 0.4 0:01.41 httpd
13348 apache 16 0 32648 11m 4112 R 1.0 0.3 0:01.12 httpd
13352 apache 16 0 32808 11m 4116 R 1.0 0.3 0:01.36 httpd
13365 apache 17 0 32272 11m 4052 R 1.0 0.3 0:00.95 httpd
13370 apache 16 0 36168 15m 4096 R 1.0 0.4 0:01.03 httpd
13066 apache 16 0 31560 10m 4228 S 0.6 0.3 0:06.84 httpd
13069 apache 16 0 32068 11m 4236 R 0.6 0.3 0:07.81 httpd
13171 apache 16 0 36604 17m 6196 R 0.6 0.4 0:06.33 httpd
13343 apache 16 0 36228 15m 4024 R 0.6 0.4 0:01.33 httpd
13374 apache 17 0 35868 14m 3596 R 0.6 0.4 0:00.11 httpd
446 root 15 0 0 0 0 S 0.3 0.0 0:03.30 kjournald
3171 root 15 0 3568 660 556 S 0.3 0.0 0:17.36 portsentry
13252 apache 15 0 31540 10m 4220 S 0.3 0.3 0:03.18 httpd
13296 apache 15 0 31276 10m 4232 S 0.3 0.3 0:03.52 httpd
1 root 16 0 2236 608 524 S 0.0 0.0 0:00.39 init
2 root 34 19 0 0 0 R 0.0 0.0 0:00.11 ksoftirqd/0
3 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/0
4 root 5 -10 0 0 0 S 0.0 0.0 0:00.01 khelper
5 root 15 -10 0 0 0 S 0.0 0.0 0:00.00 kacpid
35 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 kblockd/0
36 root 15 0 0 0 0 S 0.0 0.0 0:00.01 khubd
53 root 20 0 0 0 0 S 0.0 0.0 0:00.00 pdflush
54 root 15 0 0 0 0 S 0.0 0.0 0:00.25 pdflush
55 root 16 0 0 0 0 S 0.0 0.0 0:02.04 kswapd0
56 root 12 -10 0 0 0 S 0.0 0.0 0:00.00 aio/0
200 root 25 0 0 0 0 S 0.0 0.0 0:00.00 kseriod
422 root 15 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_0
440 root 20 0 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_1
1063 root 6 -10 0 0 0 S 0.0 0.0 0:00.00 kauditd
1798 root 6 -10 3492 536 448 S 0.0 0.0 0:00.08 udevd
1830 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 kedac
2138 root 19 0 0 0 0 S 0.0 0.0 0:00.00 kjournald
2139 root 15 0 0 0 0 S 0.0 0.0 0:00.10 kjournald
2140 root 15 0 0 0 0 S 0.0 0.0 0:00.72 kjournald
after hitting 1

Code:

top - 10:57:50 up 9:47, 2 users, load average: 29.86, 27.39, 22.45
Tasks: 144 total, 26 running, 117 sleeping, 1 stopped, 0 zombie
Cpu0 : 71.8% us, 28.2% sy, 0.0% ni, 0.0% id, 0.0% wa, 0.0% hi, 0.0% si
Mem: 4091464k total, 3873132k used, 218332k free, 331080k buffers
Swap: 1052248k total, 0k used, 1052248k free, 2864604k 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:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 500
key_buffer = 256M
myisam_sort_buffer_size = 128M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 4000
thread_cache_size = 384
wait_timeout = 20
connect_timeout = 10
tmp_table_size = 256M
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
thread_concurrency = 4
query_cache_limit = 6M
query_cache_size = 256M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
default-storage-engine = MyISAM
log-slow-queries
long_query_time=5
concurrent_insert = 2
max_heap_table_size = 256M
max_write_lock_count = 16
net_buffer_length = 16384
table_lock_wait_timeout = 30
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit = 8192
nice = -10

[mysqldump]
quick
max_allowed_packet = 64M

[myisamchk]
key_buffer = 384M
sort_buffer = 384M
read_buffer = 256M
write_buffer = 256M

8. MySQL stats from ssh telnet as root user type:(I'll update this answer ASAP)

Quote:
mysqladmin -u root -p var ext stat ver proc
copy and paste output here

Also if you want to better see what's going on install mysqlreport at http://www.vbulletin.com/forum/showthread.php?t=175177 and run it by typing

Quote:
./mysqlreport -r 10 > /statistics.txt
in ssh telnet and then copy and paste the output you see or look into statistics.txt file located at root directory /

Example below

9. is your vB the only thing on the server? or other scripts & sites which utilise php and mysql?

One install of wordpress, one install of mediawiki, and one install of vbulletin + vb blogs

10. how many average and max concurrent users on your vB forum ? and what your cookie timeout is ?

Currently (which is average): 639 (305 members & 334 guests & 144 logged out & 16 bots)

Cookie Timeout - 2200

11. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site. Please url link only - DO NOT copy and paste entire phpinfo.php page's contents to the thread!

http://www.actuarialoutpost.com/actu...um/phpinfo.php

12. if you run Apache and you have your own dedicated server or access to your httpd.conf (apache configuration file) can you post the values you have set for the following :

Apache 2 users: If you can't find these values in httpd.conf it's because they have moved. You may find the values in /usr/local/apache/conf/extra for http-mpm.conf and http-default.conf

PHP Code:

KeepAlive ON
MaxKeepAliveRequests 100
KeepAliveTimeout 4
MinSpareServers 5
MaxSpareServers 20
StartServers 8
MaxClients 256
Maxrequestsperchild value = 1000

13. check to see if any files i.e. apache log files are hitting 2GB or 4GB max file size limits i.e. see if you have max file size exceeded messages in apache error log

I have some db dumps that exceed 2 gigs, but that's it.

14. Post output from these 3 commands

uname -a:

Code:
Linux 76934-db.actuarialoutpost.com 2.6.9-78.0.22.EL #1 Fri Apr 24 12:35:12 EDT 2009 i686 athlon i386 GNU/Linux
ulimit -aH:
Code:
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 64511
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
cat /proc/cpuinfo:

Code:
processor : 0
vendor_id : AuthenticAMD
cpu family : 15
model : 5
model name : AMD Opteron(tm) Processor 246
stepping : 10
cpu MHz : 2000.000
cache size : 1024 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 pni syscall nx mmxext lm 3dnowext 3dnow
bogomips : 3989.24
For FreeBSD:

dmesg | grep -i CPU:
Code:
WARNING: NR_CPUS limit of 1 reached. Processor ignored.
Initializing CPU#0
CPU 0 irqstacks, hard=c0418000 soft=c0417000
CPU: After generic identify, caps: 078bfbff e1d3fbff 00000000 00000000

CPU: After vendor identify, caps: 078bfbff e1d3fbff 00000000 00000000
CPU: L1 I Cache: 64K (64 bytes/line), D cache 64K (64 bytes/line)
CPU: L2 Cache: 1024K (64 bytes/line)
CPU: After all inits, caps: 078bf3ff e1d3fbff 00000000 00000410
Intel machine check reporting enabled on CPU#0.
CPU: AMD Opteron(tm) Processor 246 stepping 0a
ACPI: Processor [CPU1] (supports C1, 8 throttling states)
powernow-k8: Found AMD Opteron(tm) Processor 246 single processor(1 cpu cores) (version 2.00.00-rhel4)

Do you think it would be best to upgrade to a 64 bit OS and upgrade to 8 gigs of ram? Do you have any other suggestions that I could do with my server, OR is there a completely different setup that you think might work better for my forum? Memcached? __DEFINE_LIKE_SHARE__

أدوات الموضوع
مشاهدة صفحة طباعة الموضوع أرسل هذا الموضوع إلى صديق
انواع عرض الموضوع
العرض العادي الانتقال إلى العرض المتطور الانتقال إلى العرض الشجري

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
Forum Your request timed out. Please retry the request.	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	07-13-2010 01:10 AM
Server Optimizing Request after server upgrade	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	08-07-2009 09:40 AM
I'm after a server format, Server optimisation request.	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	07-10-2009 06:10 PM
Request for a vbulletin manual (2nd request after few years)	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-06-2009 01:40 AM
Server Optimization Request - Please help! Server loads way too high!	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-05-2009 02:00 AM