Re: 3.23

[Zeev Suraski]

Where's the load coming from?  Is MySQL consuming most of the CPU time?
Is it httpd?  (I assume you have PHP cmpiled as an Apache module, if you
don't - that's a major issue!).

If it's MySQL, all I can suggest to you is either pay for extended support
(if you get 7 million hits a day, a couple of thousand dollars don't sound
like too much) or try to optimize your queries and schema.

If it's httpd, wait a couple of weeks until PHP 4.0 Beta 1 is out, it
should give you blazing fast performance in comparison to PHP 3.0 (of
course, you'd be risking yourself with Beta software, but it's a
production-quality beta).

Zeev

On Tue, 22 Jun 1999, Adam Powell wrote:

> 
> I have a mission-critical application that is basically COMPLETELY
> overloaded... the load on the server is 12 and I need to do something about
> it.  I am currently using mySQL 3.22.20a - do you think upgrading to the
> latest version is a good idea or not?  Is 3.
> 23 safe enough to start using?
> 
> Adam
> 
> ----- Original Message -----
> From: Sasha Pachev <sasha@stripped>
> To: Chris Unger <cunger@stripped>
> Cc: <mysql@stripped>
> Sent: Tuesday, June 22, 1999 4:02 AM
> Subject: Re: Upgrading Mysql to 3.22.23b
> 
> 
> > Chris Unger wrote:
> > >
> > >         what is this error mean????
> > >
> > > mysqld restarted on  Tue Jun 22 09:25:06 EDT 1999
> > > 990622  9:25:06  Warning: setrlimit returned ok, but didn't change
> limits.
> > > Max open files is 360
> > > 990622  9:25:06  Warning: Changed limits: max_connections: 70
> table_cache: 140
> > > /usr/libexec/ld.so: Undefined symbol "_fchdir" called from
> > > mysqld:/usr/lib/libc_r.so.3.0 at 0x201bd6a8
> > >
> > > I'm upgrading from a previous version. Which I have done many times
> before,
> > > just now the damn thing isn't working. Any help would be greatly
> appreciated.
> > >
> >
> > Looks like you have imcompatible libraries. Can you provide some info on
> > the OS, and whether you distrubution is source you compiled or binary?
> >
> > --
> > Sasha Pachev
> > http://www.sashanet.com/ (home)
> > http://www.direct1.com/ (work)
> >
> > ---------------------------------------------------------------------
> > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> > posting. To request this thread, e-mail mysql-thread5628@stripped
> >
> > To unsubscribe, send a message to the address shown in the
> > List-Unsubscribe header of this message. If you cannot see it,
> > e-mail mysql-unsubscribe@stripped instead.
> >
> >
> 
> 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread5633@stripped
> 
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
> 

-- 
-----------------------------------------------------
Zeev Suraski <zeev@stripped>
For a PGP public key, finger bourbon@stripped