Shulou(Shulou.com)05/31 Report--

This article mainly shows you "MySQL how to achieve real-time computing QPS, TPS SHELL script", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "MySQL how to achieve real-time computing QPS, TPS SHELL script" this article.

The first example:

# cat mysql_qps.sh

#! / bin/bash

MYSQL_CON= "/ usr/local/mysql/bin/mysql"

TIME= "$1"

OLD_QUERY= `$ MYSQL_CON-e "show global status like 'questions';" | awk-F ['','s'] 'NR==2 {print $3}' `

Echo "$OLD_QUERY"

Sleep "$TIME"

NEW_QUERY= `$ MYSQL_CON-e "show global status like 'questions';" | awk-F ['','s'] 'NR==2 {print $3}' `

Echo "$NEW_QUERY"

TIME_QUERY= `expr $NEW_QUERY-$OLD_ QUERY`

QPS= `expr $TIME_QUERY / $time`

Echo "$QPS"

Check the QPS for the next 10 seconds:

#. / mysql_qps.sh 10

The second example: read the status information of mysql through mysqladmin interval, calculate the difference, and get the statistical information.

# cat mysql_qps-tps.sh

#! / bin/bash

/ usr/local/mysql/bin/mysqladmin-uroot-paired root' extended-status-i1 | awk 'BEGIN {local_switch=0;print "QPS Commit Rollback TPS Threads_con Threads_run\ nMurray -"}

$2 ~ / Queries$/ {QQ stories 4MB LQ investors LQ shares 4;}

$2 ~ / Com_commit$/ {centering 4 Mustang 4 Muhammad 4;}

$2 ~ / Com_rollback$/ {rpm, 4MB, lr, lrc, lr, r, r, o, r, o,

$2 ~ / Threads_connected$/ {tc=$4;}

$2 ~ / Threads_running$/ {tr=$4

If (local_switch==0)

{local_switch=1; count=0}

Else {

If (count > 10)

{count=0;print "- -\ nQPS Commit Rollback TPS Threads_con Threads_run\ nMurray -" }

Else {

Count+=1

Printf "%-6d%-8d%-7d%-8d%-10d% d\ n"

}

}

}'

The running results are as follows:

#. / mysql_qps-tps.sh

QPS Commit Rollback TPS Threads_con Threads_run

Mysqladmin: [Warning] Using a password on the command line interface can be insecure.

3104 292 400 692 350 3

2488 246 305 551 350 2

3394 331 440 771 350 3

3066 279 395 674 350 3

3400 316 442 758 350 2

3082 278 415 693 350 3

3533 275 430 705 350 3

2638 249 356 605 350 2

3819 315 523 838 350 2

3206 287 449 736 350 2

2949 259 408 667 350 2

QPS Commit Rollback TPS Threads_con Threads_run

2985 284 399 683 350 2

3042 288 402 690 350 2

3208 282 431 713 350 4

3232 290 437 727 350 2

3220 287 435 722 350 5

3270 308 431 739 350 2

4022 373 546 919 350 2

5497 521 721 1242 350 3

328 18 32 50 350 2

4606 434 602 1036 350 2

1070 101 129 230 350 2

The above is all the contents of the article "how MySQL implements real-time computing QPS and TPS SHELL scripts". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

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.