View database load and log to file

View the database load is mainly the number of queries, the number of connection processes, the process is running as follows:

#!/bin/bash# Screen-d-m-S Check_mysql_statusSH/path2script/script & while true; DosudoMySQL--execute='show global status;'|awk '/queries/{q=$2}/threads_connected/{tc=$2}/threads_running/{printf "%20s%20s%20s\n", Q, TC, $ $}'>>Output_log.txtEcho "Sleep 5 Seconds";Sleep 5; Done

Queries:
The number of statements excuted by the server

Threads_connected:
The number of currently open connections.

Threads_running:
The number of threads that is not sleeping.

View database load and log to file