Knowledgebase

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.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Information Needed For SSL Certificate - CSR

We need the following information to generate a Certificate Signing Request (CSR): For the SSL...

Information Needed For SSL Certificate - CSR

We need the following information to generate a Certificate Signing Request (CSR): For the SSL...

Creating a Welcome message for SSH logins

Did you ever want to change or create a new login message antime someone logs into SSH? We'll...

Creating a Welcome message for SSH logins

Did you ever want to change or create a new login message antime someone logs into SSH? We'll...

Facts on Bandwidth

How much is 1 meg? Every time someone views your web page all of the data (html code, text,...