by Vijay » Sat Sep 23, 2006 8:42 am
Here is the output of sql query
+------+------+-----------------+----------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+------+-----------------+----------+---------+------+-------+-----------------------+
| 1296 | cron | 127.0.0.1:54018 | asterisk | Sleep | 206 | | NULL |
| 1297 | cron | 127.0.0.1:54020 | asterisk | Sleep | 205 | | NULL |
| 1298 | cron | 127.0.0.1:54022 | asterisk | Sleep | 0 | | NULL |
| 1303 | cron | 127.0.0.1:54030 | asterisk | Sleep | 2 | | NULL |
| 1304 | cron | 127.0.0.1:54031 | asterisk | Sleep | 0 | | NULL |
| 1305 | cron | 127.0.0.1:54032 | asterisk | Sleep | 0 | | NULL |
| 1316 | cron | 127.0.0.1:54046 | asterisk | Sleep | 11 | | NULL |
| 1320 | root | localhost | asterisk | Query | 0 | NULL | show full processlist |
+------+------+-----------------+----------+---------+------+-------+-----------------------+
Even asterisk is not in loop, usually when we are not dialing, the load on server remains as 0.05 or so(in normal cases on other servers), but now it seems any S/w is causing the trouble in this server, in normal state as well its showing a load of 1.25, and with 1 hour of dialing with 6 agents, it is going upto 150, here is the output again of top when no dialing is happening, and even asterisk does not seems to be in any loop, because stopping asterisk also does not bring down load on server, any guess what could be the issue???
top - 08:42:04 up 4:40, 3 users, load average: 1.00, 1.02, 1.00
Tasks: 102 total, 1 running, 94 sleeping, 0 stopped, 7 zombie
Cpu(s): 0.2% us, 0.2% sy, 0.0% ni, 99.1% id, 0.4% wa, 0.0% hi, 0.0% si
Mem: 2068224k total, 1344632k used, 723592k free, 117276k buffers
Swap: 2097136k total, 0k used, 2097136k free, 950800k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
3185 mysql 16 0 99.8m 14m 3228 S 1.3 0.7 0:11.98 mysqld
21907 root 16 0 0 0 0 Z 0.3 0.0 0:00.07 AST_VDhopper.pl <defunct>
1 root 16 0 680 252 216 S 0.0 0.0 0:01.36 init
2 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/0
3 root 39 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/0
4 root RT 0 0 0 0 S 0.0 0.0 0:00.02 migration/1
5 root 39 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1
6 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/2
7 root 39 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/2
8 root RT 0 0 0 0 S 0.0 0.0 0:00.03 migration/3
9 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/3
10 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/0
11 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/1
12 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 events/2
13 root 10 -5 0 0 0 S 0.0 0.0 0:00.01 events/3
14 root 10 -5 0 0 0 S 0.0 0.0 0:00.01 khelper
15 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kthread
20 root 10 -5 0 0 0 S 0.0 0.0 0:00.17 kblockd/0
21 root 10 -5 0 0 0 S 0.0 0.0 0:00.02 kblockd/1
22 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kblockd/2
23 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kblockd/3
24 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kacpid
134 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 khubd
367 root 15 0 0 0 0 S 0.0 0.0 0:03.39 pdflush
368 root 15 0 0 0 0 S 0.0 0.0 0:03.42 pdflush
369 root 16 0 0 0 0 S 0.0 0.0 0:06.05 kswapd0
370 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 aio/0
371 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 aio/1
372 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 aio/2
373 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 aio/3
404 root 16 0 0 0 0 S 0.0 0.0 0:00.00 shpchpd_event
992 root 10 -5 0 0 0 S 0.0 0.0 0:00.00 kseriod
1083 root 11 -5 0 0 0 S 0.0 0.0 0:00.00 scsi_eh_2