CPU Utilization is 100% and Load Avg is High

["Namitha Rao" <namithajr@xxxxxxxxx>]

Hi,

I have dedicated servers for Apache and MySQL. 

Test Setup:  Isolated setup  GigE card on  dedicated servers l connected to GigE Switch.  

Apache Sever:   Intel(R) Pentium(R) 4 CPU 3.06GHz , 2GB RAM, SuSE Linux version 2.6.5-7.97-smp

MySQL Server: Intel(R) Pentium(R) 4 CPU 2.40GHz, 256MB RAM , SUSE Linux version 2.6.11.4-20a

Apache Server Tuning Configuration:

##Prefork Mpm
 
 StartServers      16
 MinSpareServers   32
 MaxSpareServers   64
 ServerLimit      180
 MaxClients       180
 MaxRequestsPerChild 10000
 KeepAlive On
 MaxKeepAliveRequests 100
 KeepAliveTimeout 15

MySQL Configuration:

[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-locking
key_buffer = 16M
max_connections=500
net_buffer_length = 8K
read_rnd_buffer_size =1M
max_user_connections = 500
key_buffer = 16M
myisam_sort_buffer_size = 32M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
interactive_timeout = 25
wait_timeout = 1000
connect_timeout = 10
max_allowed_packet = 1M
max_connect_errors = 999999
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1
tmp_table_size = 16M

innodb_data_home_dir = /usr/local/mysql/var/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/var/
innodb_log_arch_dir = /usr/local/mysql/var/
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
                               

Issue: 
With 10 users connecting to server simultaneously CPU Utilization
on  Apache Server  rises to 100% and load average also
increases.  When i try loading the server with 50 users
simulatneous connection load average rises upto 60.

CPU Utilization and load on MySQL Server has no issues.

What is wrong in my apache configuration. Iam trying to scale my server to be used by 150 simulatneous users.

Are the server tuning-parameters  set  wronly?  Has anyone faced the same problem? 


Thanks in advance,
Namitha.