The Cache: Technology Expert's Forum
 
*
Welcome, Guest. Please login or register. September 22, 2019, 08:23:21 PM

Login with username, password and session length


Pages: [1]
  Print  
Author Topic: How to determine what is causing High Load?  (Read 4320 times)
nutballs
Administrator
Lifer
*****
Offline Offline

Posts: 5627


Back in my day we had 9 planets


View Profile
« on: March 09, 2011, 07:43:50 PM »

Is there anyway to see what is actually causing Apache load to be high? For example, in MYSQL you can "show processlist;" to see what is currently in process. Is there anything like that for apache?

I know there is apachetop, but um, heads or tails i cannot make.
Logged

I could eat a bowl of Alphabet Soup and shit a better argument than that.
perkiset
Olde World Hacker
Administrator
Lifer
*****
Offline Offline

Posts: 10096



View Profile
« Reply #1 on: March 09, 2011, 10:39:38 PM »

Hmm. I'd start with the Apache logs themselves to see what's been called, endeavor to triangulate with a process called by it. Dunno more than that and Apache top really...
Logged

It is now believed, that after having lived in one compound with 3 wives and never leaving the house for 5 years, Bin Laden called the U.S. Navy Seals himself.
nutballs
Administrator
Lifer
*****
Offline Offline

Posts: 5627


Back in my day we had 9 planets


View Profile
« Reply #2 on: March 10, 2011, 08:55:52 AM »

yea its a bit odd there there is nothing (at least that I can find) to report on "slow executes" like slow queries in mysql.
Logged

I could eat a bowl of Alphabet Soup and shit a better argument than that.
perkiset
Olde World Hacker
Administrator
Lifer
*****
Offline Offline

Posts: 10096



View Profile
« Reply #3 on: March 10, 2011, 09:02:54 AM »

I don't think it'd show that way - Apache has no way of knowing if your scripts are slow, or simply working their butt off.

Is it all PHP stuff or dotNyet? I'd do some logging there. Sometimes when I find a system slow, I simply restart Apache and that clears it up. It's rare, but sometimes I find it to get peanutbuttered up and there's no clear indication AT ALL as to what is going on ... no system load, no DB load, nothing. There's probably a log file or something that could show it but I dunno.

BTW, make sure your access and error logs are small and tight - they should be rotated. There could be an issue there. Easiest if you don't need the data: stop apache, kill'em and restart.
Logged

It is now believed, that after having lived in one compound with 3 wives and never leaving the house for 5 years, Bin Laden called the U.S. Navy Seals himself.
herbacious
Journeyman
***
Offline Offline

Posts: 51


View Profile
« Reply #4 on: March 10, 2011, 03:07:06 PM »

nice, apachetop never heard of it

looks useful, will get that set up tomorrow Grin
Logged
vsloathe
vim ftw!
Global Moderator
Lifer
*****
Offline Offline

Posts: 1669



View Profile
« Reply #5 on: March 11, 2011, 08:17:03 AM »

Seconded re: access and error logs.

Ours run about 4TB per day of access logs.
Logged

hai
perkiset
Olde World Hacker
Administrator
Lifer
*****
Offline Offline

Posts: 10096



View Profile
« Reply #6 on: March 11, 2011, 09:02:25 AM »

4 TEE of access log? Methinks you've got the logging set too high  ROFLMAO
Logged

It is now believed, that after having lived in one compound with 3 wives and never leaving the house for 5 years, Bin Laden called the U.S. Navy Seals himself.
vsloathe
vim ftw!
Global Moderator
Lifer
*****
Offline Offline

Posts: 1669



View Profile
« Reply #7 on: March 15, 2011, 09:37:52 AM »

4 TEE of access log? Methinks you've got the logging set too high  ROFLMAO

30 million hits a day, just from spiders.
Logged

hai
perkiset
Olde World Hacker
Administrator
Lifer
*****
Offline Offline

Posts: 10096



View Profile
« Reply #8 on: March 15, 2011, 09:44:15 AM »

Ah yes, I remember days like that, albeit never that huge. Used to bog me down it I wasn't careful.
Logged

It is now believed, that after having lived in one compound with 3 wives and never leaving the house for 5 years, Bin Laden called the U.S. Navy Seals himself.
Pages: [1]
  Print  
 
Jump to:  

Perkiset's Place Home   Best of The Cache   phpMyIDE: MySQL Stored Procedures, Functions & Triggers
Politics @ Perkiset's   Pinkhat's Perspective   
cache
mart
coder
programmers
ajax
php
javascript
Powered by MySQL Powered by PHP Powered by SMF 1.1.2 | SMF © 2006-2007, Simple Machines LLC
Seo4Smf v0.2 © Webmaster's Talks


Valid XHTML 1.0! Valid CSS!