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

This article is to share with you the query methods of TPS and QPS. I believe most people have not yet learned this skill. In order to make you understand better, I have summarized the following contents. Without saying much, let's read on.

Query methods of TPS and QPS:

Show GLOBAL STATUS LIKE 'questions'

Questions 498258465

Show GLOBAL STATUS LIKE 'uptime'

Uptime 29610598

Definition: QPS=Questions/Uptime

QPS=16.83

= =

SHOW GLOBAL STATUS LIKE 'com_commit'

Com_commit 2595110

SHOW GLOBAL STATUS LIKE 'com_rollback'

Com_rollback 1545433

Show GLOBAL STATUS LIKE 'uptime'

Uptime 29610598

Definition: TPS= Com_commit + Com_rollback/Uptime

TPS=0.1398

The above is the specific operation of TPS and QPS query, the code example is simple and clear, if you encounter this problem in your daily work. Through this article, I hope you can get something. For more details, please 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.