NYCPHP Meetup

NYPHP.org

[nycphp-talk] Advice: Too many mysql connections.

Chris Shiflett shiflett at php.net
Fri Nov 7 22:58:34 EST 2003


--- Ian Forsyth <ian at plusfour.org> wrote:
> What are your opinions regarding 1. Hardware, is there enough ram on 
> the box to handle increasing the 'max_connections' to 500.

Yes, probably. I frequently push MySQL up to 4096 connections. All you
need to do is use top to tune your server. Also, use the prebuilt binaries
MySQL AB offers if you're going to be pushing MySQL hard. I've experienced
random crashes under heavy load when using a binary built from source.

Chris

=====
My Blog
     http://shiflett.org/
HTTP Developer's Handbook
     http://httphandbook.org/
RAMP Training Courses
     http://www.nyphp.org/ramp



More information about the talk mailing list