TPCC-MYSQL MySQL benchmark tool using documentation

Source: Internet
Author: User
Tags benchmark documentation percona



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


Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.