链接
    https://help.aliyun.com/document_detail/405018.html

    阿里云团队已经把里面的benchmarksql.tar.gz已经对mysql进行定制,比较方便

    Mycat2在只涉及单库分表或一个mysql,无论使用XA还是Proxy都能通过TPC-C测试,因为事务仍然是本地事务

    1. 导入数据使用下面命令
    2. //tpcc_load [server] [DB] [user] [pass] [warehouse]
    3. server：数据库 IP
    4. DB：数据库名称
    5. user：用户名
    6. pass：密码
    7. warehouse：仓库数量
    9. # ./tpcc_load 127.0.0.1 8066 tpcc root 123456 10

    运行测试

    1. # ./tpcc_start --help
    2. ***************************************
    3. *** ###easy### TPC-C Load Generator ***
    4. ***************************************
    5. ./tpcc_start: invalid option -- '-'
    6. 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
    1. # ~/tpcc-mysql/tpcc_start -h 127.0.0.1 -P 8066 -d tpcc -u root -p 123456 -w 10 -c 10 -r 120 -l 300 -f /tmp/tpcc_mysql.log -t /tmp/tpcc_mysql.rtx

    或者

    1. cd benchmarksql/run
    2. ./runBenchmark.sh props.mysql

    建表语句

    1. CREATE DATABASE if not exists tpcc;
    2. USE tpcc;
    3. CREATE TABLE config (
    4.   cfg_name    VARCHAR(30) PRIMARY KEY,
    5.   cfg_value   VARCHAR(50)
    6. );
    8. CREATE TABLE warehouse (
    9.   w_id        INTEGER   NOT NULL,
    10.   w_ytd       DECIMAL(12,2),
    11.   w_tax       DECIMAL(4,4),
    12.   w_name      VARCHAR(10),
    13.   w_street_1  VARCHAR(20),
    14.   w_street_2  VARCHAR(20),
    15.   w_city      VARCHAR(20),
    16.   w_state     CHAR(2),
    17.   w_zip       CHAR(9),
    18.   PRIMARY KEY (w_id)
    19. ) dbpartition BY HASH(`w_id`);
    21. CREATE TABLE district (
    22.   d_w_id       INTEGER       NOT NULL,
    23.   d_id         INTEGER       NOT NULL,
    24.   d_ytd        DECIMAL(12,2),
    25.   d_tax        DECIMAL(4,4),
    26.   d_next_o_id  INTEGER,
    27.   d_name       VARCHAR(10),
    28.   d_street_1   VARCHAR(20),
    29.   d_street_2   VARCHAR(20),
    30.   d_city       VARCHAR(20),
    31.   d_state      CHAR(2),
    32.   d_zip        CHAR(9),
    33.   PRIMARY KEY (d_w_id, d_id)
    34. ) dbpartition BY HASH(`d_w_id`);
    36. CREATE TABLE customer (
    37.   c_w_id         INTEGER        NOT NULL,
    38.   c_d_id         INTEGER        NOT NULL,
    39.   c_id           INTEGER        NOT NULL,
    40.   c_discount     DECIMAL(4,4),
    41.   c_credit       CHAR(2),
    42.   c_last         VARCHAR(16),
    43.   c_first        VARCHAR(16),
    44.   c_credit_lim   DECIMAL(12,2),
    45.   c_balance      DECIMAL(12,2),
    46.   c_ytd_payment  DECIMAL(12,2),
    47.   c_payment_cnt  INTEGER,
    48.   c_delivery_cnt INTEGER,
    49.   c_street_1     VARCHAR(20),
    50.   c_street_2     VARCHAR(20),
    51.   c_city         VARCHAR(20),
    52.   c_state        CHAR(2),
    53.   c_zip          CHAR(9),
    54.   c_phone        CHAR(16),
    55.   c_since        TIMESTAMP,
    56.   c_middle       CHAR(2),
    57.   c_data         VARCHAR(500),
    58.   PRIMARY KEY (c_w_id, c_d_id, c_id)
    59. ) dbpartition BY HASH(`c_w_id`);
    61. CREATE sequence hist_id_seq;
    63. CREATE TABLE history (
    64.   hist_id  INTEGER,
    65.   h_c_id   INTEGER,
    66.   h_c_d_id INTEGER,
    67.   h_c_w_id INTEGER,
    68.   h_d_id   INTEGER,
    69.   h_w_id   INTEGER,
    70.   h_date   TIMESTAMP,
    71.   h_amount DECIMAL(6,2),
    72.   h_data   VARCHAR(24)
    73. ) dbpartition BY HASH(`h_w_id`);
    75. CREATE TABLE new_orders (
    76.   no_w_id  INTEGER   NOT NULL,
    77.   no_d_id  INTEGER   NOT NULL,
    78.   no_o_id  INTEGER   NOT NULL,
    79.   PRIMARY KEY (no_w_id, no_d_id, no_o_id)
    80. ) dbpartition BY HASH(`no_w_id`);
    82. CREATE TABLE `orders` (
    83.   o_w_id       INTEGER      NOT NULL,
    84.   o_d_id       INTEGER      NOT NULL,
    85.   o_id         INTEGER      NOT NULL,
    86.   o_c_id       INTEGER,
    87.   o_carrier_id INTEGER,
    88.   o_ol_cnt     INTEGER,
    89.   o_all_local  INTEGER,
    90.   o_entry_d    TIMESTAMP,
    91.   PRIMARY KEY (o_w_id, o_d_id, o_id)
    92. ) dbpartition BY HASH(`o_w_id`);
    94. CREATE TABLE order_line (
    95.   ol_w_id         INTEGER   NOT NULL,
    96.   ol_d_id         INTEGER   NOT NULL,
    97.   ol_o_id         INTEGER   NOT NULL,
    98.   ol_number       INTEGER   NOT NULL,
    99.   ol_i_id         INTEGER   NOT NULL,
    100.   ol_delivery_d   TIMESTAMP,
    101.   ol_amount       DECIMAL(6,2),
    102.   ol_supply_w_id  INTEGER,
    103.   ol_quantity     INTEGER,
    104.   ol_dist_info    CHAR(24),
    105.   PRIMARY KEY (ol_w_id, ol_d_id, ol_o_id, ol_number)
    106. ) dbpartition BY HASH(`ol_w_id`);
    108. CREATE TABLE item (
    109.   i_id     INTEGER      NOT NULL,
    110.   i_name   VARCHAR(24),
    111.   i_price  DECIMAL(5,2),
    112.   i_data   VARCHAR(50),
    113.   i_im_id  INTEGER,
    114.   PRIMARY KEY (i_id)
    115. ) dbpartition BY HASH(`i_id`);
    117. CREATE TABLE stock (
    118.   s_w_id       INTEGER       NOT NULL,
    119.   s_i_id       INTEGER       NOT NULL,
    120.   s_quantity   INTEGER,
    121.   s_ytd        INTEGER,
    122.   s_order_cnt  INTEGER,
    123.   s_remote_cnt INTEGER,
    124.   s_data       VARCHAR(50),
    125.   s_dist_01    CHAR(24),
    126.   s_dist_02    CHAR(24),
    127.   s_dist_03    CHAR(24),
    128.   s_dist_04    CHAR(24),
    129.   s_dist_05    CHAR(24),
    130.   s_dist_06    CHAR(24),
    131.   s_dist_07    CHAR(24),
    132.   s_dist_08    CHAR(24),
    133.   s_dist_09    CHAR(24),
    134.   s_dist_10    CHAR(24),
    135.   PRIMARY KEY (s_w_id, s_i_id)
    136. ) dbpartition BY HASH(`s_w_id`);

    参考
    https://www.cnblogs.com/lfri/p/10735739.html
    https://help.aliyun.com/document_detail/405018.html