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

This article mainly introduces the significance of QPS and TPS in the database, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

1. TPS:Transactions Per Second (number of transactions transmitted per second), that is, the number of transactions processed by the server per second. TPS includes a message in and a message out, plus a user database access. (service TPS = CAPS x average TPS per call)

TPS is the unit of measurement of software test results. A transaction is the process in which a client sends a request to the server and the server responds. The client starts the timing when sending the request and ends the timing after receiving the response from the server to calculate the time used and the number of transactions completed.

In general, the performance of the evaluation system is measured by the number of technology transactions completed per second. The overall processing capacity of the system depends on the TPS value of the module with the lowest processing capacity.

2. QPS: query rate per second QPS is a measure of how much traffic is processed by a particular query server in a specified period of time. On the Internet, the performance of a machine as a domain name system server is often measured by a query rate per second.

Corresponding to fetches/sec, that is, the number of response requests per second, that is, the maximum throughput capacity.

1 TPS: transactions per second. The TPS value requested by the client application is obtained in the following ways. The calculation method is as follows:

Questions = SHOW GLOBAL STATUS LIKE 'Questions'

Uptime = SHOW GLOBAL STATUS LIKE 'Uptime'

QPS=Questions/Uptime

2 QPS: Query per second. Here QPS refers to the total amount of Query executed by MySQL Server per second. The calculation method is as follows:

Com_commit = SHOW GLOBAL STATUS LIKE 'Com_commit'

Com_rollback = SHOW GLOBAL STATUS LIKE 'Com_rollback'

Uptime = SHOW GLOBAL STATUS LIKE 'Uptime'

TPS= (Com_commit + Com_rollback) / Uptime

IOPS: (Input/Output Operations Per Second), that is, the number of read and write operations per second, which is mostly used in databases and other situations to measure the performance of random access.

The performance of the IOPS on the storage side is different from that of the IO on the host side. IOPS refers to the number of accesses sent by the host per second. An IO of the host needs to access the storage multiple times. For example, when a host writes a smallest data block, it also goes through three steps: "send a write request, write data, and receive a write acknowledgement", that is, access by three storage sides.

IOPS's test benchmark tools mainly include Iometer, IoZone, FIO and so on, which can be used to test disk IOPS in different situations. For the application system, it is necessary to determine the load characteristics of the data first, and then select a reasonable IOPS index for measurement and comparative analysis, so as to select the appropriate storage medium and software system.

Thank you for reading this article carefully. I hope the article "what is the meaning of QPS and TPS in the database" shared by the editor will be helpful to you. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.