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
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
Take a look here: http://www.debianhelp.co.uk/mysqlperformance.htm http://www.profitpapers.com/papers/performance-tuning-mysql-for-load.php BTW, thread_concurrency should be no. of processors * 2. So unless you have a quad-core system, 8 is too high.