Hi
my database engine stopped suddenly and when I try to open it from shell it
give me message too many connection then the server hang and I restart it and
every thing go ok but how I can know the reason of that hanging and what have
to optimize the number of connections
BR
On Thu, 17 Jul 2003, Eben Goodman wrote:
> This comment confuses me:
> I have seem some sites code that actually open multiple connections to the
> same database..
I have worked on some larger sites that 30+ past and current
developers worked on.. Some good, some terrible.. The code typically
This comment confuses me:
I have seem some sites code that actually open multiple connections to the
same database..
If I am using php's mysql_connect() function, then every time a query is
run this function gets run. Wouldn't this mean that for every query a
new "connection" is opened to the s
DOh! i mean script_append part ;) .. basically it's a garbage
collector..
On Thu, 17 Jul 2003 [EMAIL PROTECTED] wrote:
>
> Suggestion.. make a small script called closeall.php .. basically it has
> some code to force closed the mysql connection opened (be sure to run a
> close for all opene
Suggestion.. make a small script called closeall.php .. basically it has
some code to force closed the mysql connection opened (be sure to run a
close for all openened handles)
I have seem some sites code that actually open multiple connections to the
same database..
Add this file into php.ini u
I run a site that gets a fair amount of traffic throughout the day. For
days at a time the site runs smoothly, and then, at seemingly random
intervals I get the mysql error "Too many connections". The only
solution for this is to stop the mysql service and restart it. I
changed the max_conne
Hi,
I've just seen when the maximum connection number is reached and you try to shutdown
MySQL with mysqladmin shutdown, it couldn't be executed because of "too many
connections" error.
It would be smarter if mysqladmin could shutdown MySQL whatever the number of
connections, even if the maxi
