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