OLTP-Bench标准工具 需要中对 MySQL 的基础操作

1. 启动MySQL

# 登录mysql
mysql -u admin -p

# 用performance监控表
use performance_schema;

# 准备打开 events_long_history的权限
select * from setup_consumers;

# 修改两个权限
update performance_schema.setup_consumers set enabled = 'YES' where name ='events_transactions_history_long';
update performance_schema.setup_consumers set enabled = 'YES' where name ='events_statements_history_long';

2. 关闭MySQL or 刷新表

当跑完一个OLTP数据集的时候，我们需要手动刷新下performance_schema中的记录信息：
可以使用“截断”的功能，参考：原文档TRUNCATE例子

TRUNCATE TABLE performance_schema.events_transactions_history_long;
TRUNCATE TABLE performance_schema.events_statements_history_long;

3. 使用OLTP-Bench模拟负载

如果跑某个测例后，再跑其他的报错，那么就 drop db 再 create db

drop database benchbase;
create database benchbase;

所有的测例如下：

# tpc-c (5)
java -jar benchbase.jar -b tpcc -c config/mysql/sample_tpcc_config.xml --create=true --load=true --execute=true

# twitter (5)
java -jar benchbase.jar -b twitter -c config/mysql/sample_twitter_config.xml --create=true --load=true --execute=true

# chbenchmark
java -jar benchbase.jar -b tpcc,chbenchmark -c config/mysql/sample_chbenchmark_config.xml --create=true --load=true --execute=true

# AuctionMark (9)
java -jar benchbase.jar -b auctionmark -c config/mysql/sample_auctionmark_config.xml --create=true --load=true --execute=true

# Epinions (9)
java -jar benchbase.jar -b epinions -c config/mysql/sample_epinions_config.xml --create=true --load=true --execute=true

# Seats (6)
java -jar benchbase.jar -b seats -c config/mysql/sample_seats_config.xml --create=true --load=true --execute=true

# SIBench (2)sibench
java -jar benchbase.jar -b sibench -c config/mysql/sample_sibench_config.xml --create=true --load=true --execute=true

# SmallBank (6)
java -jar benchbase.jar -b smallbank -c config/mysql/sample_smallbank_config.xml --create=true --load=true --execute=true

# tatp (7)
java -jar benchbase.jar -b tatp -c config/mysql/sample_tatp_config.xml --create=true --load=true --execute=true

# Voter (1)
java -jar benchbase.jar -b voter -c config/mysql/sample_voter_config.xml --create=true --load=true --execute=true

# wikipedia (5)
java -jar benchbase.jar -b wikipedia -c config/mysql/sample_wikipedia_config.xml --create=true --load=true --execute=true

# ycsb (6)
java -jar benchbase.jar -b ycsb -c config/mysql/sample_ycsb_config.xml --create=true --load=true --execute=true

# sysbench_ro (10)

# sysbench_rw(10)