Tpcc-mysql Installation and use

First, installation

1. Download. Tpcc-mysql of the TAR package

2. Upload to Server (RZ)

3, Decompression (TAR-ZXVF Tpcc-mysql-src.tar)

II. Preparation of the database

Enter the database, run the Create_table.sql,add_fkey_idx.sql two tables (these two tables are extracted by tpcc-mysql)

Third, the use of ttpc_load to fill the test data (pouring into the warehouse for a long time)

Tpcc_load host ' dbname ' username password warehouse

(warehouse refers to the number of warehouses to create)

Iv. start of testing

Tpcc_start-h host-pport-d dbname-u username-p password-w 10-c 10-r 300-l 1800

-D Test Library

-U user Name

-p password

-W number of data warehouses used

The concurrency of the-c test

-R Preheat for a few seconds

-L How long to run the test

(This time drop_cons.sql is useful if you need to delete a table that you have created)

Tpcc-mysql Installation and use