Installation and use of MySQL benchmark tool tpcc-mysql
1.tpcc-mysql Introduction:
TPC (Tracsaction processing Performance Council) Transaction Performance Association is a non-profit organization that evaluates the hardware and software performance of large database systems, and TPC-C is developed by the TPC Association to test the performance of typical complex OLTP systems. The Tpcc-mysql is a Percona-based TPCC product that is designed for MySQL benchmark testing.
2. Website address:
Https://github.com/Percona-Lab/tpcc-mysql
3. Installation Method:
Download the source code on official website.
Store the source code on a server that needs to test MySQL.
Set MySQL Path
I have to MySQL is installed with the source, I have to path for:
Export Path=/usr/bin/mysql: $PATH
If you cannot find MySQL, perform a find command to find the following command, refer to the following:
Find/-name MySQL
Enter the source directory
Execute make
Note: When I execute the error:
/bin/sh:mysql_config: Command not found
Mysql_config not found.
check under command:
whereis mysql_config
Yes, No.
I checked behind and found that I was not installing Mysql-devel, after installing Mysql-devel.
re-executes
no more error.
When the compilation is complete, two files are generated:
650) this.width=650; "src=" Http://www.linuxtb.top/wp-content/uploads/2017/08/1-3-300x32.png "style=" margin:0px; Padding:0px;border:0px;vertical-align:middle;height:auto; "/>
Tpcc_start
Tpcc_load
Tpcc_load is a script that imports data
Tpcc_start is the script that executes the test
To the end of this installation.
4. Importing data
recommended test database:
mysqladmin-uroot-p Create TPCC1000
mysql-uroot-p tpcc1000 <create_table.sql
mysql-uroot-p Tpcc1000<add_fkey_idx.sql
Import data:
./tpcc_load-h127.0.0.1-d tpcc1000-u root-p "123456"-W 100
Create 100 warehouses and populate the data.
data is the
... DATA LOADING completed successfully.
import succeeded.
5. Execute test
command:
./tpcc_start-h 127.0.0.1-p 3306-d tpcc1000-u root-p "123456"-w 10-c 10-r 100-l 300-i 20-f/var/log/tpcc_mysql.log-t/var/log/tpcc_mysql.rtx
parameter description:
Execution Result:
trx:164, 95%: 1487.825, 99%: 1991.466, max_rt:2246.449, 165|1743.200, 17|1277.349, 16|4179.249, 16|4035.317
Detailed Explanation:
20 is the time interval I set above
164 transactions executed in 164 20 seconds
95% transaction average response time is 1487 seconds
99% transaction Average response time is 1991 seconds
MAX_RT Transaction Maximum response time is 2,246 seconds
[0] sc:1 lt:2644 rt:0 fl:0 avg_rt:947.1 (5)
[1] sc:164 lt:2477 rt:0 fl:0 avg_rt:209. 1 (5)
[2] sc:3 lt:261 rt:0 fl:0 avg_rt:418.6 (5)
[3] sc:0 lt:264 rt:0 fl:0 avg_rt:1932.7 (+)
in sec.
[0] sc:1 lt:2644 rt:0 fl:0
[1 "sc:164 lt:2477 rt:0 fl:0
[2] Sc:3 lt:261 rt:0 fl:0
[3] sc:0 lt:264 rt:0 fl:0
[4] sc:0 lt:265 rt:0 fl:0
(all must is [OK])
[transaction percentage]
payment:43.44% (>=43.0%) [OK]
order-status:4.34% (>= 4%) [OK]
delivery:4.34% (>= 4%) [OK]
stock-level:4.36% (>= 4%) [OK]
[response time (at least 90% passed)]
payment:6.21% [ng] *
order-status:1.14% [ng] *
delivery:0.00% [ng] *
stock-level:0.00% [NG] *
529.000 TPMC
Explain:
SC: seccess, the number of successful operations.
LT: late, which is the number of delays in operation.
RT: Retry, which refers to the number of operation retries.
FL: Failure refers to the number of failed operations.
My is the VMware Virtual machine test.
The data is too bad is normal.
There are reference documents:
http://blog.csdn.net/yumushui/article/details/37764467
Mainly English is not very good, reference to his parameters in English interpretation translation.
This article is from the "Gome Learning" blog, so be sure to keep this source http://goome.blog.51cto.com/4045241/1958328
TPCC-MYSQL MySQL benchmark tool using documentation