Re: Debian sarge Mysql 4.1 (Too many connections)
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Tue, 8 Aug 2006 19:36:06 -0400
"Roberto C. Sanchez" <roberto@familiasanchez.net> wrote:
> On Wed, Aug 09, 2006 at 10:35:56AM +1200, Simon wrote:
> > Hi There,
> >
> > We are running MySQL in a shared hosting evnironment with around 200
> > PHP/MySQL websites and getting this error:
> >
> > Warning: mysql_connect(): Too many connections in
> > "/path/to/file.php" on line 9
> > Cannot connect to the server at this time.
> >
> > at some stages during the day.
> >
> > Would someone be able to take a look at our my.cnf and see if we
> > have anything incorrect that would lead to this issue?
> >
> Have you considered switching to PostgreSQL? Seriously, it is more
> robust, more scalable and much more compliant with the SQL language
> specification.
Switch ~200 customer websites to postgresql? Just because the sites are
becoming sucessful and attracting traffic? Surely you're not serious.
Yes, I know they could all be changed over, but that doesn't sound like
a practical solution to his problem. I doubt postgresql is that much
better at handling lots of connections.
Jacob
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)
iD8DBQFE2SbakpJ43hY3cTURAsUzAKCBT9ogOj0d1/DXmuiTG2h+HYGfiACgm4qo
gyzQmBmb3UB1RS1+es49fiA=
=P42N
-----END PGP SIGNATURE-----
Reply to: