Windows Server 脚本记录Apache、Mysql 每分钟并发数

打开windows server 计划任务管理器。定时执行如下的Bat脚本即可。

在D盘新建一个monitor文件夹，创建ApacheMysql.bat文件。内容如下：

在monitor文件夹中新建mysql、apache文件夹

进入mysql文件夹，创建sql.sql文件，保存如下内容：

select count(*) from information_schema.processlist where command != 'Sleep' into outfile 'd:/monitor/mysql/b';

执行后，脚本会生成日志文件。记录当前时间与当前并发数，保存在各自文件夹中。

@echo off

setlocal enabledelayedexpansion

echo %date:~,%%date:~,%%date:~,% %time:~,%:%time:~,%:%time:~,% >d:\monitor\apache\a

netstat -ant |find /i "ESTABLISHED"|find /i ":80 " /c >d:\monitor\apache\b

cd \

d:

cd monitor

cd apache

for /f "tokens=*" %%i in (a) do (

set /a n+=

set #!n!=%%i)

set n=

(for /f "tokens=*" %%i in (b) do (

set /a n+=

call echo %%#!n!%%%%i))>>apacheResult

del a b

cd C:\Program Files\MySQL\MySQL Server 5.6\bin\

set user_mysql=dbmonitor

set password_mysql=dbPassword

mysql -u%user_mysql% -p%password_mysql% < d:\monitor\mysql\sql.sql

echo %date:~,%%date:~,%%date:~,% %time:~,%:%time:~,%:%time:~,% >d:\monitor\mysql\a

cd \

d:

cd monitor

cd mysql

for /f "tokens=*" %%i in (a) do (

set /a n+=

set #!n!=%%i)

set n=

(for /f "tokens=*" %%i in (b) do (

set /a n+=

call echo %%#!n!%%%%i))>>mysqlResult

del a b

:end

Monitor Code

巴特西

Windows Server 脚本记录Apache、Mysql 每分钟并发数

最新文章

热门文章