Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 19th March 2007, 21:56
FalkoL FalkoL is offline
Junior Member
 
Join Date: Mar 2007
Posts: 7
Thanks: 2
Thanked 0 Times in 0 Posts
Unhappy Maximum Performance High Traffic Webserver

Hello,

I'm working for a High traffic Website as a SystemAdmin. We recently put a new Server online and we are not really satisfied with the performance.

Our configuration.
Hardware:
Dell PowerEdge 1950
with Dual dual2core Xeon 5130, 2GB RAM and Raid 1 SAS HDD's

Software:
Debian Sarge, Kernel 2.6 custom for Dell PowerEdge 1950, Apache2 with SSL, Rewrite and deflate, Mysql 5, PHP4 with turck mmcache, VHCS2

Some conf files what I change after reading the Maximum Performance Howto
apache2.conf

Timeout 10
KeepAlive On
MaxKeepAliveRequests 0
KeepAliveTimeout 2
<IfModule prefork.c>
StartServers 8
MinSpareServers 16
MaxSpareServers 32
ServerLimit 256
MaxClients 256
MaxRequestsPerChild 500
</IfModule>
HostnameLookups Off

my.cnf
key_buffer = 64M
max_allowed_packet = 1M
thread_stack = 128K
thread_cache_size = 8
table_cache =1024
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_concurrency = 8
max_connections = 250
interactive_timeout = 100
wait_timeout=60
connect_timeout=10
#
# * Query Cache Configuration
#
query_cache_limit = 2M
query_cache_size = 128M
query_cache_type = 1


Our Problem
Our website www.kiwicollection.com have a lot of Pic's and is pretty big. Right now every time more than 100 clients are at the same time on the Server the server load goes up to the sky and the server starting to swap and get slower.

Have any body a Idea what I do wrong`???

Thanks for helping.
Falko
Reply With Quote
Sponsored Links
  #2  
Old 20th March 2007, 10:12
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,395
Thanks: 833
Thanked 5,490 Times in 4,322 Posts
Default

Are the images in the database oer where thy served directly from filesystem?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 20th March 2007, 17:42
FalkoL FalkoL is offline
Junior Member
 
Join Date: Mar 2007
Posts: 7
Thanks: 2
Thanked 0 Times in 0 Posts
Default

The only think whats happend with the images is that the phars to the images is saved in the DB, to php get the phars to the images from mysql and posted as html to the page.


I don't really know if that meens ther are in the database.

The most load come from mysql and then apache.

Here a little top cut out.
top - 01:39:56 up 21:44, 1 user, load average: 0.30, 0.31, 0.70
Tasks: 120 total, 3 running, 117 sleeping, 0 stopped, 0 zombie
Cpu(s): 26.0% us, 3.7% sy, 0.0% ni, 69.7% id, 0.3% wa, 0.0% hi, 0.3% si
Mem: 906568k total, 884640k used, 21928k free, 23524k buffers
Swap: 1951888k total, 7280k used, 1944608k free, 600308k cached

2612 mysql 15 0 391m 173m 5268 S 20.6 19.6 166:23.24 mysqld
11243 www-data 15 0 50360 7088 4476 S 0.7 0.8 0:00.26 apache2
11270 www-data 15 0 50452 6644 3988 S 0.7 0.7 0:00.12 apache2
11230 www-data 16 0 50296 8072 5568 S 0.3 0.9 0:00.44 apache2
11244 www-data 15 0 50452 8316 5608 S 0.3 0.9 0:00.27 apache2
11256 www-data 15 0 50688 6824 4068 S 0.3 0.8 0:00.25 apache2
11265 www-data 15 0 50392 7904 5304 S 0.3 0.9 0:00.20 apache2
11275 www-data 15 0 50452 6656 4000 S 0.3 0.7 0:00.18 apache2
11288 www-data 15 0 50800 7052 4212 S 0.3 0.8 0:00.10 apache2
11289 www-data 15 0 50324 5792 3264 S 0.3 0.6 0:00.12 apache2
11291 www-data 15 0 50360 7228 4660 S 0.3 0.8 0:00.09 apache2
11306 www-data 15 0 50404 5528 3016 S 0.3 0.6 0:00.01 apache2
11332 www-data 15 0 50224 6172 3752 S 0.3 0.7 0:00.01 apache2

may it helps to make a better pic from my problem
Reply With Quote
  #4  
Old 21st March 2007, 15:39
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,743 Times in 2,577 Posts
 
Default

Take a look here: http://www.debianhelp.co.uk/mysqlperformance.htm
http://www.profitpapers.com/papers/p...l-for-load.php

BTW, thread_concurrency should be no. of processors * 2. So unless you have a quad-core system, 8 is too high.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Failover Webserver asyadiqin Server Operation 4 8th January 2007 17:25
WEBALIZER FTP TRAFFIC CONT in WEB TRAFFIC dloopsrl Installation/Configuration 3 20th September 2006 17:39
Traffic Limit katschi Feature Requests 2 16th August 2005 23:40


All times are GMT +2. The time now is 07:39.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.