Portal Home > Knowledgebase > Articles Database > Load high..
Load high..
Posted by howsthat, 11-28-2007, 12:02 AM |
i was previously using maxclients 256 in httpd.conf and the load was normal even when the server was processing 256 requests..
recently i had changed it to 320 coz of which my load had increased a lot.. Now when i have decreased it back to 256 the load is still high even when the no of requests are just 150..
WHat can be the possible reason
|
Posted by gate2vn, 11-28-2007, 12:09 AM |
How about the top result command?
|
Posted by howsthat, 11-28-2007, 12:18 AM |
well right now my load is low.. during evening time it increases a lot..
will put the top result in the evening
|
Posted by david510, 11-28-2007, 12:46 AM |
Also watch the apache status page when the server load goes high to see if any specific site is taking more resource on server. Use the following command from shell to see the database activity.
mysqladmin -i3 processlist
|
Posted by activelobby4u, 11-28-2007, 08:29 AM |
mysqladmin proc stat
would give you a list of queries including the slow queries
|
Posted by howsthat, 11-28-2007, 01:33 PM |
top - 12:32:45 up 89 days, 20:03, 1 user, load average: 18.78, 14.50, 11.57
Tasks: 355 total, 9 running, 345 sleeping, 1 stopped, 0 zombie
Cpu(s): 73.8%us, 24.7%sy, 0.0%ni, 0.5%id, 0.0%wa, 0.2%hi, 0.8%si, 0.0%st
Mem: 1489484k total, 1457372k used, 32112k free, 8912k buffers
Swap: 2031608k total, 36336k used, 1995272k free, 655252k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
11638 mysql 15 0 141m 45m 3604 S 190 3.1 15939:39 mysqld
16163 nobody 15 0 30368 14m 3780 S 1 1.0 0:10.45 httpd
22520 nobody 15 0 37928 11m 2472 S 1 0.8 3:21.34 python
27447 root 15 0 2296 1148 784 R 1 0.1 0:00.36 top
9836 nobody 15 0 30532 13m 3684 S 0 0.9 0:21.39 httpd
9850 nobody 15 0 30012 13m 3624 S 0 0.9 0:11.82 httpd
9866 nobody 15 0 32032 14m 3572 S 0 1.0 0:08.02 httpd
9909 nobody 15 0 32224 14m 3776 S 0 1.0 0:11.05 httpd
10075 nobody 15 0 30132 13m 3648 S 0 0.9 0:08.20 httpd
12006 nobody 15 0 30068 13m 3628 S 0 0.9 0:11.95 httpd
12408 nobody 15 0 32588 15m 3580 S 0 1.0 0:09.96 httpd
13370 nobody 15 0 30252 13m 3624 S 0 0.9 0:07.51 httpd
21107 nobody 15 0 46908 20m 2440 S 0 1.4 1:53.25 python
22697 nobody 15 0 48532 22m 2472 S 0 1.5 2:44.93 python
24034 nobody 15 0 30716 13m 3452 S 0 0.9 0:02.99 httpd
24688 nobody 16 0 29476 12m 3440 R 0 0.9 0:01.44 httpd
25033 nobody 15 0 32848 6868 2472 S 0 0.5 0:11.85 python
|
Posted by howsthat, 11-28-2007, 01:44 PM |
when i do /usr/sbin/httpd status
the cpu usage shown there is
Total accesses: 332333 - Total Traffic: 47.6 GB
CPU Usage: u988.14 s423.49 cu69.2 cs8.73 - 1.65% CPU load
3.69 requests/sec - 0.5 MB/second - 150.2 kB/request
|
Posted by gate2vn, 11-28-2007, 09:41 PM |
did you try to optimize your mysql yet? and which script is using python there?
|
Posted by activelobby4u, 11-28-2007, 10:18 PM |
11638 mysql 15 0 141m 45m 3604 S 190 3.1 15939:39 mysqld
----------
Mysql usage is on top. Its best to optimize it and then proceed
|
Posted by howsthat, 11-29-2007, 12:31 AM |
i had but thats the max i could do..
i think some load was due to the python script i was using yest.. otherwise the load remains to 10 - 12
|
Add to Favourites Print this Article
Also Read