Topic awaiting preservation: How many connections (Page 1 of 1)

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

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

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();