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

Source: Internet
Author: User
Tags benchmark percona

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

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.