[PHP-DB] mySQL max connections

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi I have a database thats taking a bit of a hammering - enough so that the number of connections spirals up and out of control. max_connections was originally at the default of 100 - but rising above 50 or so meant actual throughput dropped so

Re: [PHP-DB] mySQL max connections

I would suggest looking into MySQL's replication support. Split reads and writes so they go to separate servers. That is, create a master server where you send all database writes. And do all reads on the replicated slave servers. Have a look at this presentation I gave last week on this