MySQL Performance in Linux
There are various tools to monitor MySQL performance and troubleshoot. These kinds of tools don’t always perfect match for a MySQL developer or administrators. For the command needs, or may not work in some situations, such as remote or over the web monitoring.
So the best options for monitoring the MySQL server is to work around basics and use the basic commands to monitor the server. So that you can get a clear idea of server working.
Maintaining uptime of the server is very crucial for any online business. So uptime means how long the database has been running and up since its last shutdown or restart. You can get the information about uptime is very crucial in many situations, as it helps system administrators to check the status of MySQL database about, such as how many queries per second that MySQL database serves, threads, slow queries and lots of interesting statistics.
(MySQL top) is one of the best commands to give a clear view of the MYSQL Server monitoring tool, was written in Perl language that displays results in a tabular format much like other commands. mtop monitors MySQL queries which are taking the most amount of time to finish and kills those long running queries after certain specified time.
Mytop is one of other my classic open source and free console-based (non-gui) monitoring tool for MySQL database was written by Jereme Zawodny using Perl language. Mytop runs in a terminal and displays statistics about threads, queries, slow queries, uptime, load, etc. in tabular format, much similar to the Linux top program.
mysqladmin is a default command line MySQL client that comes pre-installed with MySQL package for performing administrative operations such as monitoring processes, checking server configuration, reloading privileges, current status, setting the root password, changing the root password, create/drop databases, and much more.