LKML: Sven Rudolph: Re: HP server and atto driver from hell::
Submit search form. Web lkml.org. Subject, Re: HP server and atto driver from hell. From, Sven Rudolph <>. Date, Fri, 09 May 2008 15:03:29 +0200
http://lkml.org/lkml/2008/5/9/178HOME |
Going bald quickly over here!! :) I've been wandering about the forums looking for answers and nothing seems to work for me... I've tweaked this silly thing so many times, I can't remember where it worked best - it just doesn't work well at all.
Server description:
-Processors 4
-Model Pentium II (Deschutes)
-Chip MHz 449.85 MHz
-Cache Size 512 KB
-System Bogomips 1795.68
-Compaq Smart-2/P RAID Controller w/ 10K RPM SCSI drives
Software:
- Kernel 2.2.14-5.0smp
- PHP v4.0.6 (Zend optimizer and cache enabled)
- Apache 1.3.22
- MySQL 3.23.46 (see http://www.dsschat.com/stats.php)
- vBulletin 2.2.1
- database is about 960M
- search index is about 10.5 million records
- posts is about 523,000 records
- threads is about 104,000 records
Relevant Configuration Snippets:
- my.cnf
skip-locking
skip-name-resolve
set-variable = max_connections=450
set-variable = max_connect_errors=150
set-variable = max_user_connections=450
set-variable = key_buffer=384M
set-variable = max_allowed_packet=1M
set-variable = table_cache=1024
set-variable = sort_buffer=2M
set-variable = record_buffer=2M
set-variable = thread_cache=8
set-variable = thread_concurrency=8
set-variable = myisam_sort_buffer_size=64M
- httpd.conf (running lingerd)
Timeout 30
KeepAlive Off
MaxKeepAliveRequests 100
MinSpareServers 10
MaxSpareServers 75
StartServers 100
MaxClients 350
MaxRequestsPerChild 0
SendBufferSize 131072
- php.ini
mysql.allow_persistent = On
mysql.max_persistent = -1
mysql.max_links = -1
The problem is that it just runs slow - way too slow for this machine. I've tried persistent and non-persistent connections - no help. Everything else responds just fine on the server unless your coming in via a browser! Load average seems to just sit at around 12-20. Response times are hideous (especially when we get over 300 users - we maxed out at 521 in December). :( It even gets to the point where it simply replies with a "Cannot find server" error and the machine has lots of resources still available...
The server isn't really doing anything but running vBulletin.
Hopefully that's enough info to start with. I'm am completely bedaffled on this and would certainly appreciate anyone offering some help on this configuration. CoolBoy's Weblog: Glass Fish Installation from Hell, really?::
Dec 14, 2007 Glass Fish Installation from Hell, really? I like Sun's open source application server, GlassFish, thus when I feels a bit offended when
http://coolboykl.blogspot.com/2007/12/glass-fish-installation-from-hell.htmlHOME |
Perlbal on danga.com -- config from hell: msg#00017 web.server ::
Perlbal on danga.com -- c - Find Help in our web.server.perlbal.general Forum.
http://osdir.com/ml/web.server.perlbal.general/2005-08/msg00017.htmlHOME |
1. your key_buffer cache is too large and you're missing a join_buffer size variable
2. if you're not hosting other sites which make use of mysql get rid of the max_user_connections NOT max_connections.
3. your max_connections MAYBE too small if you peaked at 521 users
4. upgrade your kernel to the latest stable version 2.4.17
5. noticed your table_locks_waited figure in mysql status output is very high probably suggesting mysql table locking issues which are slowing mysql queries and your site down - http://vbulletin.com/forum/showthread.php?s=&threadid=37174&highlight=table+locking
change your my.cnf file to something like below and restart mysql
- my.cnf
skip-locking
skip-name-resolve
set-variable = max_connections=600
set-variable = max_connect_errors=40
set-variable = key_buffer=24M
set-variable = max_allowed_packet=1M
set-variable = table_cache=1024
set-variable = join_buffer=2M
set-variable = sort_buffer=3M
set-variable = record_buffer=2M
set-variable = thread_cache_size=256
set-variable = thread_concurrency=8
set-variable = myisam_sort_buffer_size=64M
set-variable = wait_timeout=3600
set-variable = connect_timeout=10
[safe_mysqld]
open-files-limit=8192
[myisamchk]
set-variable = key_buffer=384M
set-variable = sort_buffer=384M
set-variable = read_buffer=16M
set-variable = write_buffer=16M
- httpd.conf (running lingerd)
Timeout 30
KeepAlive Off
MaxKeepAliveRequests 100
MinSpareServers 10
MaxSpareServers 20
StartServers 15
MaxClients 256
MaxRequestsPerChild 0
SendBufferSize 131072
restart apache
try a few days with pconnects on and monitor cpu and memory load/usage and then try the same number of days without pconnects and do the same
why are you htaccessing your site :confused:
Originally posted by nuno
why are you htaccessing your site :confused:
Does it make that much of a difference?
There are a couple of areas that we drop an htaccess file into when it gets too busy so that it is "members only".
Originally posted by eva2000
try a few days with pconnects on and monitor cpu and memory load/usage and then try the same number of days without pconnects and do the same [/B]
Wow! That appears to have already made some impressive differences! I will do as above and report back!
Thanks!!!
 Where's The Advantage In Windows Genuine Advantage?
 Stocks Bounce After S&P Joins Bear Market |
