TPCC installation and testing

TPCC installation and testing 1. install 1.yum install bzr2.bzr branch lp :~ Percona-dev/perconatools/tpcc-mysql3.cd tpcc-mysql/src/4. make 2. load data mysqladmin-h10.1.10.95-uroot-pxxxx-P3307 create tpccmysql-h10.1.10.95-uroot-pxxxx-P3307 <your-h10.1.10.95-uroot-pxxxx-P3307 <upload data to a single thread. /tpcc_load 10.1.10.95: 3307 tpcc root "xxxx" 1000 multi-threaded data loading tpcc_load [server] [DB] [user] [pass] [warehouse] [part] [min_wh] [max_wh] * [part]: 1 = ITEMS 2 = WAREHOUSE 3 = CUSTOMER 4 = ORDERS modify the load. sh script. /load. sh 3. start to test 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: -h server_host: MYSQL server name-P port: MYSQL port. Default Value: 3306-d database_name: database used for testing-u mysql_user: log on to the MYSQL server account-p mysql_password: Password-w warehouses: warehouse quantity-c connections: Number of processes. Default Value: 1-r warmup_time: Warm-up time, in seconds. Default Value: 10 seconds. -l running_time test time, in seconds. The default value is 20 seconds-I report_interval. The report interval-f report_file specifies the report file name.