[ale] mysql and high load levels

[Joseph Andrew Knapka]

djinn at djinnspace.com wrote:
> 
> Well, someone on the mysql list is having the exact same problem as I, with the
> exact same setup (apache 1.3.20 + php4.0.6 + mysql 3.23.41)...but he's running
> 2.2.19.  Now I realise that 2.2.19 and 2.4 may have a good bit in common since
> they were developed more or less concurrently...I'm beginning to wonder if its
> not a PHP + shiny new mysql problem.  I tried backing off a couple versions of
> mysql with no results, but I may take it back further to the one I was running
> successfully...that will help determine if its kernel or mysql.    Since I'm not
> anywhere near my machines, and since I've been having so many problems lately,
> I'd rather not reboot with a new kernel unless I absolutely have to.
> 
> Top shows kswapd wayyyy down the list and my memory seems to be...well...it
> hovers between 85 and 95% but I can tackle that later  (the board on this system
> won't hold more than 512MB...this is a replacement for the system that died ...
> it has not been my week).
> Mysqld, on the other hand, is at the top of the list, jumping between 30 and 40%
> cpu utilization and 3 and 4%.  Sar shows the same thing.  During a load level
> spike, mysqld takes over 100% cpu utilization and seems to spawn processes...

Well, forget what I said then. It seems unlikely to be a 2.4 MM issue.
I'd suspect an application-level problem (which seems to be where you're
going anyway).

Cheers,

-- 
# Joe Knapka
# "You know how many remote castles there are along the
#  gorges? You can't MOVE for remote castles!" - Lu Tze re. Uberwald
# Linux MM docs:
http://home.earthlink.net/~jknapka/linux-mm/vmoutline.html
--
To unsubscribe: mail majordomo at ale.org with "unsubscribe ale" in message body.