Hi Scott
Regardless of the bug found in 3.23.31, this problem of mine have been
going on for some time now, over many versions of MySQL, gammas, betas
and finals.
As for the queries themselves, I cannot list all of them as there are
hundreds of them in our web sites. If you think there are few queries
that cause this problem, then to what direction should I care most?
Thanks
Noor
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 21, 2001 9:55 PM
To: Noor Dawod
Cc: MySQL List
Subject: Re: Unexplained high-loads on FreeBSD
You didn't give any details about the database and how it is being
used/accessed.
There may NOT be anything wrong with your setup. It may actually be
inefficiencies in your code or queries that are causing the problems.
Also Note MySQL 3.23.31 has a serious bug!
- Scott
> Hello all,
>
> I've been trying to fix a problem we're facing without luck for the
last
> few weeks. I also searched mailing lists for a similar problem, both
> MySQL and FreeBSD, without luck.
>
> The situation is as follows... A brank new server was deployed last
> month for our company. It's a 933Mhz Xeon-based server, with 1GB of
> memory, a RAID-5 system utilizing 4 IBM SCSI 10K RPM LVD disks. As you
> can see, a very high-performance server for the Web. I installed
FreeBSD
> 4.1.1 on it, then upgraded to 4.2-STABLE up to last week's snapshot.
> Currently, it has Apache 1.3.14 + mod_ssl, MySQL 3.23.31 and PHP
> 4.0.4pl1 -- as you can imagine, most RECENT versions.
>
> The problem persists, though, and here it is: every once in a while,
> sometimes once a week, the mysqld process goes into OVERHEAT state
with
> CPU usage getting as high as 97%, thus making it almost impossible for
> clients to connect to it. I checked mysqld's process usage once while
> this happened, and I found around 60 processes (connections). Not a
big
> deal as I saw much more processes connect to the same daemon before,
and
> still it continued to work.
>
> Anyways, this problem keeps bugging me all the time. I look at lists
> over and over and cannot understand why this is happening. I've even
> tried limiting Apache to a minimum of connections (sometimes as low as
> 300 maximum requests for the whole Apache daemons), but it didn't
> help -- eventualy, mysqld would go into this almost-dead state and no
> more Web pages would be served correctly.
>
> I'm attaching the my.cnf file for you to examine. Remember, this is
the
> stock my.cnf file that came with MySQL for large Web sites (those
having
> more than 512MB of memory), with a little modification.
>
> I'd appreciate any hint or fix that you might have, and I would even
let
> serious bug-hunters/mysql gurus get a shell on our server to try to
> check and fix this problem.
>
> Thanks in advance.
>
> Noor
--
--------------------------------------
Scott A. Gerhardt P.Geo.
Gerhardt Information Technologies
[EMAIL PROTECTED]
--------------------------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
