I'm on a shared hosting account. I was wondering if there is anyway for me to find out how many MySQL concurrent connections my account is using? I asked this because my site is mainly a Vbulletin forum and there are host who have a hard limit on this. If i can find out my usage, i will know if the hard limit offered by a host is enough before i signed up with them.

Thank you.

Greetings:

mysqladmin extended-status

I was wondering if the statistics listed is for the whole server OR for my username only?

Since i'm on a share account and doesn't have root, i ran the following command.

mysqladmin -uUSERNAME -pPASSWORD extended-status

Greetings:

To be honest, I don't know.

You can probably check out the documentation on the mysqladmin extended-status command at http://www.mysql.com/

Thank you.

I do believe you are looking for something like:

mysqladmin extended-status -v -u youraccount_yourUsername -p
Enter password:

Threads_running (2nd from the bottom is what you would want) and I do believe it is for the whole server.

This should give you for just your own account:

mysqladmin processlist -v -u youraccount_yourUsername -p
Enter password:

Using the following will give you a "Help" list:

mysqladmin -u yourUsername -p

Thank you Website Rob,

That is very helpful. I will go on and explore further.

Edited

I missed the 2nd part of Website Rob's answer.