Hi,
my server centos 6 32bit, server config. 12core 16gb ram,only http and mysql(innodb).
promble: httpd service taking 90% cpu usage.
below is top command result and my.cnf conf..
some times site hangs.
any solution on this issue
top - 16:11:13 up 6 days, 5:38, 3 users, load average: 31.50, 30.64, 24.67
Tasks: 259 total, 35 running, 224 sleeping, 0 stopped, 0 zombie
Cpu(s): 61.2%us, 7.9%sy, 0.0%ni, 30.5%id, 0.2%wa, 0.1%hi, 0.1%si, 0.0%st
Mem: 15982704k total, 6111196k used, 9871508k free, 365788k buffers
Swap: 6291448k total, 0k used, 6291448k free, 2648472k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1500 apache 20 0 81188 55m 4660 R 47.7 0.4 3:53.51 httpd
1167 apache 20 0 80184 55m 4680 R 36.3 0.4 13:37.91 httpd
942 apache 20 0 86352 61m 4708 R 34.3 0.4 12:59.12 httpd
1157 apache 20 0 84272 59m 4704 R 34.3 0.4 13:04.18 httpd
1307 apache 20 0 86316 60m 4684 R 34.3 0.4 10:33.57 httpd
1363 apache 20 0 80164 55m 4676 R 34.3 0.4 7:07.59 httpd
1386 apache 20 0 86336 60m 4676 R 34.3 0.4 5:58.29 httpd
1620 apache 20 0 80164 54m 4660 R 34.3 0.3 3:01.97 httpd
937 apache 20 0 84084 59m 4712 R 32.4 0.4 13:04.31 httpd
1147 apache 20 0 84260 59m 4696 R 32.4 0.4 12:21.55 httpd
1158 apache 20 0 84084 60m 4688 R 32.4 0.4 12:39.18 httpd
1159 apache 20 0 84288 59m 4696 R 32.4 0.4 13:12.04 httpd
my.cnf conf. file
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
set-variable=max_allowed_packet=100M
set-variable=max_connections=500
set-variable=key_buffer_size=100M
#set-variable=key_buffer_size=64M
set-variable=sort_buffer_size=64M
#set-variable=innodb_buffer_pool_size=32M
set-variable=innodb_buffer_pool_size=1024M
#set-variable=innodb_buffer_pool_size=2048M
#set-variable=table_cache=1024
set-variable=table_cache=256
set-variable=thread_cache_size=16
set-variable=query_cache_size=16M
#set-variable=innodb_log_file_size=100MB
set-variable=interactive_timeout=60
set-variable=wait_timeout=60