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

What this article shares with you is an example analysis of the TPCC-MySQL test results. The editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

Detailed explanation of TPCC-MySQL output result

The previous article introduced the installation and use of the test tool tpcc-mysql, but there is basically no analysis of tpcc-mysql results on the Internet. This article describes how to analyze the test results:

A test example

[root@rac1 tpcc-mysql] # tpcc_start-hlocalhost-d tpcc- u root-p''- w 5-c 5-r 120-l 300-f tpcc_mysql_20130403.xls

* *

* * easy### TPC-C Load Generator * *

* *

Option h with value 'localhost'

Option d with value 'tpcc'

Option u with value 'root'

Option p with value''

Option w with value'5'

Option c with value'5'

Option r with value '120'

Option l with value '300'

Option f with value 'tpcc_mysql_20130403.xls'

[server]: localhost

[port]: 3306

[DBname]: tpcc

[user]: root

[pass]:

[warehouse]: 5

[connection]: 5

[rampup]: 120 (sec.)

[measure]: 300 (sec.)

The above part can be ignored, if you don't understand, please refer to the introduction of the previous article.

RAMP-UP TIME. (120 sec.)-warm-up time

MEASURING START.

10,861 (0): 1.544 | 2.791 (0): 0.471 | 1.265, 86 (0): 0.245 | 0.500, 87 (0): 2.102 | 3.095, 86 (0): 5.127 | 11.375

20826 (0): 1.419 | 1.681 (0): 0.418 | 0.637, 83 (0): 0.174 | 0.181, 82 (0): 1.975 | 2.239, 82 (0): 4.447 | 4.848

30848 (0): 1.463 | 2.296 (0): 0.422 | 0.943, 85 (0): 0.180 | 0.201, 85 (0): 1.865 | 2.174, 85 (0): 4.267 | 8.545

40802 (0): 1.518 | 2.436: 0.497 | 0.820, 80 (0): 0.224 | 0.344, 81 (0): 1.925 | 2.115, 81 (0): 4.373 | 4.886

50851 (0): 1.678 | 3.510 (0): 0.483 | 0.590, 85 (0): 0.234 | 0.295, 85 (0): 1.832 | 1.903, 85 (0): 6.480 | 8.878

60855 (0): 1.457 | 1.889 (0): 0.456 | 0.741, 85 (0): 0.205 | 0.230, 84 (0): 2.123 | 2.281, 85 (0): 4.648 | 10.951

70843 (0): 1.474 | 1.752: 0.447 | 0.781, 85 (0): 0.228 | 0.244, 86 (0): 2.045 | 2.058, 85 (0): 4.357 | 4.808

80838 (0): 1.471 | 1.737 (0): 0.447 | 0.769, 84 (0): 0.176 | 0.247, 84 (0): 1.856 | 1.988, 84 (0): 4.054 | 4.336

90820 (0): 1.499 | 2.230 (0): 0.540 | 1.114, 82 (0): 0.221 | 0.260, 81 (0): 2.112 | 2.177, 81 (0): 4.485 | 4.582

100785 (0): 1.504 | 2.217: 0.426 | 0.912, 78 (0): 0.188 | 0.189, 78 (0): 2.010 | 2.227, 79 (0): 4.280 | 4.862

110,893 (0): 1.449 | 2.576 (0): 0.444 | 0.732, 89 (0): 0.183 | 0.187, 89 (0): 1.976 | 1.978, 89 (0): 5.972 | 6.259

120838 (0): 1.482 | 1.818: 0.480 | 0.802, 84 (0): 0.307 | 0.333, 84 (0): 1.887 | 2.657, 84 (0): 4.079 | 4.105

.

210,832 (0): 1.464 | 2.587 (0): 0.496 | 0.954, 83 (0): 0.246 | 0.371, 85 (0): 2.055 | 3.083, 84 (0): 6.794 | 10.487

220825 (0): 1.493 | 1.906 (0): 0.479 | 0.864, 83 (0): 0.258 | 0.294, 83 (0): 1.891 | 2.111, 83 (0): 4.154 | 8.172

230810 (0): 1.512 | 2.304: 0.478 | 0.605, 80 (0): 0.207 | 0.226, 78 (0): 1.965 | 2.032, 81 (0): 4.192 | 4.499

240879 (0): 1.489 | 1.889 873 (0): 0.477 | 1.096, 89 (0): 0.196 | 0.199, 89 (0): 1.985 | 2.005, 88 (0): 6.170 | 6.262

250859 (0): 1.388 | 1.772 859 (0): 0.417 | 0.689, 86 (0): 0.260 | 0.278, 86 (0): 1.787 | 1.833, 86 (0): 4.062 | 5.333

260789 (0): 1.517 | 2.585 (0): 0.523 | 0.764, 78 (0): 0.211 | 0.343, 78 (0): 1.683 | 1.721, 79 (0): 4.182 | 9.561

270821 (0): 1.463 | 2.214: 0.415 | 0.653, 83 (0): 0.236 | 0.243, 83 (0): 1.739 | 2.034, 81 (0): 4.482 | 5.035

280748 (0): 1.519 | 2.312: 0.463 | 0.892, 74 (0): 0.185 | 0.316, 76 (0): 1.818 | 2.107, 75 (0): 4.247 | 4.303

290834 (0): 1.514 | 2.821 (0): 0.440 | 0.687, 84 (0): 0.278 | 0.287, 82 (0): 1.947 | 2.096, 83 (0): 4.184 | 4.466

300,793 (0): 1.583 | 2.225 (0): 0.474 | 0.860, 79 (0): 0.193 | 0.200, 80 (0): 2.006 | 2.111, 80 (0): 4.433 | 4.553

STOPPING THREADS.

[0] sc:24839 lt:0 rt:0 fl:0

[1] sc:24839 lt:0 rt:0 fl:0

[2] sc:2484 lt:0 rt:0 fl:0

[3] sc:2485 lt:0 rt:0 fl:0

[4] sc:2484 lt:0 rt:0 fl:0

In 300 sec.

[0] sc:24839 lt:0 rt:0 fl:0

[1] sc:24839 lt:0 rt:0 fl:0

[2] sc:2484 lt:0 rt:0 fl:0

[3] sc:2485 lt:0 rt:0 fl:0

[4] sc:2484 lt:0 rt:0 fl:0

(all must be [OK])

[transaction percentage]

Payment: 43.48% (> = 43.0%) [OK]

Order-Status: 4.35% (> = 4.0%) [OK]

Delivery: 4.35% (> = 4.0%) [OK]

Stock-Level: 4.35% (> = 4.0%) [OK]

[response time (at least 90% passed)]

New-Order: 100.005% [OK]

Payment: 100.005% [OK]

Order-Status: 100.005% [OK]

Delivery: 100.005% [OK]

Stock-Level: 100.005% [OK]

4967.800 TpmC

Result analysis:

The details are as follows:

New-Order: new order

Payment: payment

Order-Status: order query

Delivery: shipping

Stock-Level: inventory

Predefined variables:

In order to clearly explain the following, first define some variables to facilitate the following calculation and explanation. The details are as follows:

Success = number of records successfully executed

Late = number of records with delayed execution

The number of records of the last successful execution of pre_success=

Pre_late = the number of records that failed the last execution

Late definition:

The definition of late varies from business to business. The threshold values for operation delay defined by the five business logic are as follows:

New-Order 5ms

Payment 5ms

Order-Status 5ms

Delivery 80ms

Stock-Level 20ms

Calculate:

According to the variables defined above, calculate the results of the corresponding fields and explain the meaning of the corresponding fields.

1. Successful transactions within the interval (including successful and delayed transactions): sl=success+late-pre_success-pre_late

2. Transactions delayed during the interval: l=late-pre_late

3. Average rt: rt90 of the first 90% records (actually 99%) during the interval

4. The largest rt in the interval: max_rt

Case analysis:

According to the output results and the above calculation and explanation, the unexplained parts are analyzed as follows:

Count New-Order Payment Order-Status Delivery Stock-Level

Sl (l): rt90 | max_rt sl (l): rt90 | max_rt

#, # (#): # |

10,861 (0): 1.544 | 2.791 (0): 0.471 | 1.265, 86 (0): 0.245 | 0.500, 87 (0): 2.102 | 3.095, 86 (0): 5.127 | 11.375

The above results indicate that there are 861 successful transactions and 0 delayed transactions during the new order interval, and 90% of the rt is less than the highest rt 2.791ms of 1.54ms.

There are 86 successful transactions and 0 delayed transactions in order query. 90% of rt is the highest in 0.245ms, rt in 0.500ms.

87 transactions were successfully shipped and 0 transactions were delayed. 90% of the rt was the highest in 2.102ms, rt in 3.095ms.

There are 86 successful transactions and 0 delayed transactions in inventory. 90% of rt is the highest in 5.127ms rt in 11.375ms.

Usually when testing mysql, we also collect information from the entire server (usually disk iops) and make charts for later analysis.

The above is an example analysis of the TPCC-MySQL test results, and the editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. 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.