MySQL Benchmark tool tpcc-mysql installation, use, results interpretation

TPCC is a specification for online transaction processing systems (OLTP systems), and in general we refer to such systems as business processing systems, Tpcc-mysql is a product derived from Percona tpc-c (hereinafter TPCC), designed for MySQL benchmarks. Its source is stacked on launchpad, with Bazaar Management, project address: Https://code.launchpad.net/~percona-dev/perconatools/tpcc-mysql, A dedicated benchmarking tool for MySQL, simulating e-commerce business processes. However, the results of Tpcc-mysql were not certified by TPC, but only as a reference data.

First, download and install Tpcc-mysql

1. Installing Epel

Yum Install Epel-release.noarch

2. Installing the BZR version Control tool

Yum Install BZR

3.cd/tmp

4. Started to download Tpcc-mysql source with BZR client

BZR Branch Lp:~percona-dev/perconatools/tpcc-mysql

5. Installation

Cd/tmp/tpcc-mysql/src

Mke

If make does not have an error, the TPCC Binary command line tool is generated under/tmp/tpcc-mysql tpcc_load, Tpcc_start

Second, prepare for testing

1. Create a test table structure

Mysql-uroot-poracle-e ' Create Database TPCC '

Mysql-uroot-poracle TPCC < Create_table.sql
Mysql-uroot-poracle TPCC < Add_fkey_idx.sql

2.tpcc-mysql's business logic and several of its related tables function as follows

New-order: New orders, one complete order transaction, almost all tables involved

Payment: Payment, main correspondence orders, history table

Order-status: Order status, main corresponding orders, Order_line table

Delivery: Delivery, main correspondence Order_line table

Stock-level: Inventory, main corresponding stock table

Other related tables:

client: Main Customer table

Area: Main Correspondence District Table

Product: Main Correspondence Item table

Warehouse: Main Correspondence Warehouse Table

3. Create data

./tpcc_load localhost TPCC root Oracle #最后的数字是代表几个仓库, the larger the warehouse, the greater the amount of data. The longer it takes, the better the data simulates your true data volume, or at least more than your buffer pool

4. Start testing

./tpcc_start:invalid option---usage:tpcc_start-h server_host-p port-d database_name-u mysql_user-p Mysql_password -w warehouses-c connections-r warmup_time-l running_time-i report_interval-f report_file-t trx_file #./tpcc_st art-hlocalhost-d tpcc-u root-p root-w 100-c 8-r 10-l

III. Analysis of output results

MySQL Benchmark tool tpcc-mysql installation, use, results interpretation