Hi,

From the command prompt can we find how many connectionts to the database and how many quaries to this database.

How could I check it?


thanks
Stephenn

mysqladmin processlist

The MySQL docs (http://www.mysql.com/doc/en/mysqladmin.html) tell you how to do this with mysqladmin from the command line.

#> mysqladmin proc stat

will give you this information... check the docs for how to interpret it.

mysqladmin -h

'mysqladmin status' might be helpful?

Hi,

How do we find the exact userid for the mysql process?

Thanks

Are you using Cpanel ? If you are, running mysqladmin processlist will show you the database connected. And in Cpanel, the prefix is actually the userid.