The MySQL database is rapidly becoming the default choice for big enterprises and pioneering Web 2.0 companies. MySQL system store the all of the critical data and easy to maintenance in every cases. While the adoption rate of MySQL continues to grow in momentum, it poses some unique challenges for traditional DBAs in monitoring and rectifying the problems. Here are the list of things which to be keep in mind by MySQL DBAs.

1. MySQL sort key command :
* MySQL Use \h for help.
* \c command for clear
* \r command for reconnect to the server and database or host .
* \e command for edit and with $EDITOR
* \q command for Exit
* \g command for send to mysql server
* \G command for send the mysql; and display the result vertically
* \p command for print current command
* \q command quit mysql
* \# command for Rebuild completion hash
* \s command for get status information from the server
* \u command for another database and take the database name as argument.

2. Following are the main items you can use to monitor your system:-

* The MySQL admin extended ,mysql absolute value
* The MySQL admin extended -i10 – relative value
* The MySQL admin process list
* The MySQL “e show inno database status”
* The MySQL OS data ,vm state/iostat
* The MySQL error log
* The MySQL table space info

The MySQL admin extended MySQL absolute value

* slave_running: If the system is a slave replication server, this is an indication of the slave’s health.
* Threads_connected: Number of clients currently connected .
* Thread_running: If the database that overload then you will get an increased number of queries running.

The MySQL admin extended (counters)
You store the performance counter value and compute the difference with the new values. Difference should be more then 10 seconds.
The following values are good candidates for checking:-

* Absorted_client: The number of client that were aborted.

MySQL currently lacks some advanced features available in other enterprise databases. But there are few good MySQL monitoring tools out there in the market provide monitoring and advisory information on various system metrics.