Closed Thread Icon

Topic awaiting preservation: How many connections (Page 1 of 1) Pages that link to <a href="https://ozoneasylum.com/backlink?for=12016" title="Pages that link to Topic awaiting preservation: How many connections (Page 1 of 1)" rel="nofollow" >Topic awaiting preservation: How many connections <span class="small">(Page 1 of 1)</span>\

 
Osaires
Paranoid (IV) Inmate

From: oslo, Norway
Insane since: Aug 2001

posted posted 01-24-2002 16:36

is there any way i can see how many connections that is open to my db?
it's a mysql db, and i use php to access.

i just want to make sure that all connections to that db will be closed



jiblet
Paranoid (IV) Inmate

From: Minneapolis, MN, USA
Insane since: May 2000

posted posted 01-24-2002 16:45

I really don't know the details of this, but I think mysqladmin can give you this information. I'm not sure if this is the information you want, but try:

mysqladmin processlist

you also may need username/pw like so:

mysqladmin -u jiblet -p processlist

Then it will prompt you for your password. In my case this just showed me one line of information which I assumed pertained to the command I issued itself.

-jiblet

Osaires
Paranoid (IV) Inmate

From: oslo, Norway
Insane since: Aug 2001

posted posted 01-24-2002 17:51

Damn, i don't know what i do roung,

in my php script i open a db and after geting the info i need i close it.

but lately i get this error: Too many connections in //dir/dir/dir

what am i doing roung, and how can i fix this problem

is this roung: mysql_close();

« BackwardsOnwards »

Show Forum Drop Down Menu