Interpretation of MySQL AB stress test

This article turns from: http://www.cnblogs.com/lemtree/articles/1676641.html.

is Apache's own test tool AB (Apache benchmark). In the Apache Bin directory.
Format:./ab [Options] [http://]hostname[:p Ort]/path
Parameters:
-N requests number of requests to perform
//Number of requests executed in the test session. By default, only one request is executed
-c concurrency number of multiple requests to make
//Number of requests generated at one time. The default is one at a time.
-T TimeLimit Seconds to Max. Wait for responses
The maximum number of seconds that the//test takes. Its internal implied value is-n 50000. It allows you to limit the testing of the server to a fixed total time. By default, there is no time limit.
-P postfile File containing data to POST
//Contains files that require post data.
-T Content-type content-type header for POSTing
//post The Content-type header information used by the data.
-V verbosity how much troubleshooting info to print
//Set the level of detail to display information-4 or greater displays header information, 3 or greater values can display response codes (404, 200, etc.), and 2 or greater values can display warnings and other information. -V Displays the version number and exits.
-W Print out results in HTML tables
//Output results in HTML table format. By default, it is a table with a two-column width on a white background.
-I use HEAD instead of GET
//Execute HEAD request instead of get.
-X attributes String to insert as table attributes
//
-Y attributes String to insert as TR attributes
//
-Z attributes String to insert as TD or TH attributes
//
-C attribute Add cookie, eg. ' Apache=1234. (repeatable)
//-C Cookie-name=value attach a cookie to the request: line. Its typical form is a parameter pair of Name=value. This parameter can be repeated.
-H attribute Add arbitrary header line, eg. ' Accept-encoding:gzip '
Inserted after all normal header lines. (repeatable)
-A attribute Add Basic WWW authentication, the attributes
is a colon separated username and password.
-P attribute Add Basic Proxy authentication, the attributes
is a colon separated username and password.
//-P Proxy-auth-username:password provides a Basic authentication trust to a transit agent. The user name and password are separated by a: and sent in Base64 encoded form. This string is sent regardless of whether the server is required (that is, if the 401 authentication requirement code is sent).
-X Proxy:port ProxyServer and port number to use
-V Print version number and exit
-K Use HTTP KeepAlive feature
-D do not show percentiles served table.
-S do not show confidence estimators and warnings.
-G filename Output collected data to gnuplot format file.
-e filename Output CSV file with percentages served
-H Display Usage information (this message)
-attributes the string that sets the property. There are various statically declared fixed-length buffers in the defect program. In addition, parsing of command-line arguments, the response headers of the server, and other external inputs can be very simple, which may have undesirable consequences. It does not realize the http/1.x completely; Accept only certain ' expected ' response formats. The frequent use of STRSTR (3) can lead to performance problems, that is, you may be testing the performance of AB rather than the server.

Example:

./ab-c 1000-n http://www.baidu.com/
This represents processing 1000 requests at the same time and running the index.php file 1000 times.

Server software:apache/2.0.54
//platform Apache version 2.0.54
Server hostname:127.0.0.1
//Server host name
Server port:80
//Server Port
Document Path:/index.html.zh-cn.gb2312
//test page document
Document length:1018 bytes
//Document size
Concurrency level:1000
//concurrency number
Time taken for tests:8.188731 seconds
//duration of the entire test
Complete requests:1000
//Number of requests completed
Failed requests:0
//Number of failed requests
Write errors:0
Total transferred:1361581 bytes
//network traffic in the entire scene
HTML transferred:1055666 bytes
//The amount of HTML content transferred throughout the scene
Requests per second:122.12 [#/sec] (mean)
//One of the most concerned indicators, equivalent to the number of transactions per second in LR, followed by mean in parentheses indicates that this is an average
Time per request:8188.731 [MS] (mean)
//One of the two most concerned indicators, equivalent to the average transaction response time in LR, followed by mean in parentheses indicates that this is an average
Time per request:8.189 [MS] (mean, across all concurrent requests)
//average of actual run time per request
Transfer rate:162.30 [Kbytes/sec] Received
//Average traffic on the network per second can help to eliminate the problem of prolonged response time due to excessive network traffic
Connection Times (MS)
Min MEAN[+/-SD] Median max
Connect:4 646 1078.7 89 3291
processing:165 992 493.1 938 4712
waiting:118 934 480.6 882 4554
total:813 1638 1338.9 1093 7785
//The decomposition of the time consumed on the network, the specific algorithm of the data is not very clear
Percentage of the requests served within a certain time (MS)
50% 1093
66% 1247
75% 1373
80% 1493
90% 4061
95% 4398
98% 5608
99% 7368
100% 7785 (Longest request)
//response of all requests in the entire scene. Each request in the scene has a response time, where 50% of the user's response time is less than 1093 milliseconds, 60% of the user response time is less than 1247 milliseconds, and the maximum response time is less than 7785 milliseconds
due to concurrent requests, the CPU is not actually processed at the same time, but instead is rotated on a per-request basis, so basically the first time of the request is approximately equal to the second time per request multiplied by the number of concurrent requests .

Interpretation of MySQL ab stress test (RPM)