[Resolved] Count Connections to mysql

[fean0r]

Is there a way to count how my connections I have to my mysql database?

and

Is there a way to close all connections to the mysql database?

Thanks

[thorpe]

you should only have 1 connection open at a time.

[fean0r]

But if multiple users are access my site at the same time they will open a new connection?

[thorpe]

yes they will.

you can free resources using.

mysql_free_result($link);

you might want to look at the mysql functions. here

[fean0r]

thanks

[Drakla]

run the query: SHOW STATUS and you'll get back a heap o' stuff that'll tell you what's going on in the world of your MySQL server. SHOW VARIABLES also gives fun reading. Somebody should make a coffee table book of it.