查看数据库负载并记录到文件中

最新推荐文章于 2024-04-11 10:14:24 发布

weixin_30673715

最新推荐文章于 2024-04-11 10:14:24 发布

阅读量82

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/wlemory/p/5509538.html

版权

查看数据库负载主要是查询数，连接进程数，正在运行的进程如下：

#!/bin/bash
# screen -D -m -S check_mysql_status sh /path2script/script &
while true; do
sudo mysql --execute='show global status;' | awk '/Queries/{q=$2} /Threads_connected/{tc=$2} /Threads_running/{printf"%20s %20s %20s\n", q, tc, $2}' >> output_log.txt
echo "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 are not sleeping.

转载于:https://www.cnblogs.com/wlemory/p/5509538.html