How can I monitor what my MySQL server is doing?

A handy little Linux application called mytop fits this just perfectly. This is a near-time monitor just like the UNIX utility ‘top’ that specifically looks at what the MySQL server is doing. It updates every few seconds, so you can get a reasonable look at your SQL performance. It’s capable of displaying a huge amount of information, so be sure to read the documentation. It also assumes that you’re connecting to the MySQL server on localhost with the root user and no password. These can be changed either in the script itself or on the command line.

http://jeremy.zawodny.com/mysql/mytop/

Need More Personalized Help?

If you have any further issues, questions, or would like some assistance checking on this or anything else, please reach out to us from your my.hivelocity.net account and provide your server credentials within the encrypted field for the best possible security and support.

If you are unable to reach your my.hivelocity.net account or if you are on the go, please reach out from your valid my.hivelocity.net account email to us here at: [email protected]. We are also available to you through our phone and live chat system 24/7/365.

Back to: Operating System

Create a Free Account

Chat with an Expert

Configure a Bare Metal Server

Latest

Categories +

Operating System

...

Tags +

...