First you need to login to your Dedicated server as root via SSH. Then type the following command to show the current MySQL status and usage:

mysqladmin status

In addition you can type the command below in order to receive information about the exact operation the MySQL service is executing at this moment:

mysqladmin processlist