dodba监控mysql防注入_doDBA：Go 实现的 MySQL 监控工具

#doDBA

The doDBA tools is a console-based remote system monitor. that does not require special software on the remote system. it collects real-time performance data from linux and MySQL. And can generate a doing file to help you analyze the MySQL database. This program is free software.doDBA is written in go.

WeChat:doDBA

#Download

wget https://raw.githubusercontent.com/dblucyne/dodba_tools/master/doDBA --no-check-certificate

wget https://raw.githubusercontent.com/dblucyne/dodba_tools/master/doDBA.conf --no-check-certificate

chmod +x doDBA

or

git pull https://github.com/dblucyne/dodba_tools

#help

./doDBA -help

Usage: doDBA [OPTIONS]

-help

Display this help.

-c string

configuration file. (default "doDBA.conf")

-h string

Connect to host/IP.

-sys

Print system info.

-myall

Print system and mysql info.

-mysql

Print mysql info.

-innodb

Print innodb info.

-mytop

Print mysql prcesslist info , like top.

-i duration

refresh interval in seconds. (default 1s)

-t int

mysql doing on Threads_running. (default 50)

-hP string

Connect host port. (default "22")

-hp string

Connect host password.

-hu string

Connect host user. (default "root")

-mP string

Connect mysql port. (default "3306")

-mp string

Connect mysql password.

-mu string

Connect mysql user.

-rds

Ignore system info.

-log

Print to file by day.

-nocolor

Print to nocolor.

#Configuration

doDBA.conf

{

"Host":"",

"Huser": "root",

"Hport": "22",

"Hpwd": "",

"Muser": "dodba",

"Mpwd": "dodba",

"Mport":"3306"

}

For example:

./doDBA -c=doDBA.conf

#Example

./doDBA -h=10.1.xx.xx -myall

DoDBA tools on host 10.1.xx.xx

---------+---load--avg---+-----cpu-usage-----+-swap+----net----+----mysql-status-------+-slow---th---+---bytes---

time | 1m 5m 10m| usr sys iow ide|si so| recv send|QPS TPS ins upd del| sql run con| recv send

---------+---------------+-------------------+-----+-----------+-----------------------+-------------+-----------

13:52:00 | 4.00 3.68 3.60| 0.7 0.3 0.0 99.0| 0 0| 316K 4.3M|203 58 22 36 0| 0 2 52| 86K 1.8M

13:52:01 | 4.00 3.68 3.60| 5.3 0.3 0.1 94.3| 0 0| 275K 2.0M|251 67 27 40 0| 0 3 76| 104K 3.2M

13:52:02 | 4.00 3.68 3.60| 6.4 0.5 0.1 93.0| 0 0| 371K 4.1M|380 810 24 786 0| 0 3 40| 311K 5.0M

13:52:03 | 4.00 3.68 3.60| 5.4 0.4 0.0 94.2| 0 0| 510K 4.2M|648 283 30 253 0| 1 3 52| 216K 1.4M

13:52:04 | 4.00 3.68 3.60| 5.7 0.4 0.0 93.8| 0 0| 385K 2.7M|108 69 45 24 0| 0 4 48| 71K 2.1M

13:52:05 | 3.92 3.66 3.59| 6.2 0.5 0.0 93.3| 0 0| 206K 2.0M|339 96 52 44 0| 0 3 37| 107K 1.9M

./doDBA -h=10.1.xx.xx -myall -rds

DoDBA tools on host 10.1.xx.xx

---------+----load--avg----+-----cpu-usage-----+swap+----net----+-----mysql-status------+-slow---th---+---bytes---

time | 1m 5m 10m| usr sys iow ide|siso| recv send|QPS TPS ins upd del| sql run con| recv send

---------+-----------------+-------------------+----+-----------+-----------------------+-------------+-----------

17:19:17 | 0.00 0.00 0.00| 0.0 0.0 0.0 0.0| 0 0| 0K 0K|144 155 73 82 0| 0 1 5| 113K 229K

17:19:18 | 0.00 0.00 0.00| 0.0 0.0 0.0 0.0| 0 0| 0K 0K| 66 113 32 81 0| 0 2 6| 79K 109K

17:19:19 | 0.00 0.00 0.00| 0.0 0.0 0.0 0.0| 0 0| 0K 0K|273 117 30 87 0| 1 2 20| 135K 502K

17:19:20 | 0.00 0.00 0.00| 0.0 0.0 0.0 0.0| 0 0| 0K 0K|207 173 74 99 0| 1 2 17| 137K 279K

17:19:21 | 0.00 0.00 0.00| 0.0 0.0 0.0 0.0| 0 0| 0K 0K|161 233 105 128 0| 0 1 5| 146K 193K

./doDBA -h=10.1.xx.xx -myall -t=3

2016/12/14 11:47:52 ----------------processlist---------------

ID:606374462

User:ums_read

Host:10.1.xx.xx:31886

DB:mia

Command:Query

Time:3121

State:Sending data

Info:SELECT ......................

=====================================

2016-12-14 11:49:16 7f93ece24700 INNODB MONITOR OUTPUT

=====================================

Per second averages calculated from the last 1 seconds

-----------------

BACKGROUND THREAD

-----------------

srv_master_thread loops: 11256164 srv_active, 0 srv_shutdown, 27867 srv_idle

srv_master_thread log flush and writes: 11284031

----------

SEMAPHORES

----------

OS WAIT ARRAY INFO: reservation count 1562657988

OS WAIT ARRAY INFO: signal count 11589318962

Mutex spin waits 7915500772, rounds 7044249291, OS waits 29061199

RW-shared spins 15964124137, rounds 99809511531, OS waits 1188604739

RW-excl spins 1056480533, rounds 26766008869, OS waits 261290579

........................................

#image