In this section you can learn how to monitor the MySQL Database. MySQL system store the all of the critical data and easy to maintenance in every cases.
In this section you can learn how to monitor the MySQL Database.
system store the all of the critical data and easy to maintenance in
every cases. It is very popular database and make quick easy to store or its
access, and update Data.
- 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.
- 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
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.