On Thu, 10 Feb 2000, Leslie Mikesell wrote:
> According to Ryan, Aaron:
>
> > We found that we are quicking using up the max connections to the MySQL
> > database
> > and when we raise the max connection, the performance gets worse. What was
> > MySQL designed
> > to handle, should it be able to handle 2000 connections, or is that outside
> > the scope
> > of the design of the server.
> >
> > Does anyone have any suggestions or similar experiences with scaling.
>
> Have you already taken the step of setting up a non-mod_perl proxy
> front end and avoiding sending any unnecessary requests (images,
> static html, etc.) to the database-connected backend? If not, you
> may be able to reduce the number of connections you need by a
> factor of 10 or so.
Plus using Mason to cache components to reduce the number of queries or
any other method to cache the query results. I think you can also run more
than one mysql server on the same DB...
_______________________________________________________________________
Stas Bekman mailto:[EMAIL PROTECTED] http://www.stason.org/stas
Perl,CGI,Apache,Linux,Web,Java,PC http://www.stason.org/stas/TULARC
perl.apache.org modperl.sourcegarden.org perlmonth.com perl.org
single o-> + single o-+ = singlesheaven http://www.singlesheaven.com
