Shulou(Shulou.com)06/01 Report--

1. Test script

[root@mysql5 ~] # cat proce.sh

While true

Do

Mysql-uroot-pmysql-e'show processlist\ G' | grep State > > / root/mysql.log

Sleep 1

Done

2. Tail-f

[root@mysql5] # tail-f mysql.log

State:

State: starting

State:

State: starting

State:

State: starting

State:

State: starting

State:

State: starting

State:

State: starting

State:

State: starting

State:

State: starting

State:

State: starting

3. Sort, remove duplicates and count mysql.log by row

[root@mysql5 ~] # sort mysql.log | uniq-c

24 State:

24 State: starting

4. Analyze the database according to the information of state.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.