526互联

TiDB vs MySQL测试

发布时间 2023-04-03 10:52:50作者: edclol

TiDB vs MySQL测试

TiDB

硬盘占用

image-20230302102305864

image-20230302143431365

image-20230302143459105

image-20230302143617542

image-20230302143629568

image-20230302143706560

image-20230302143724222

image-20230303152135748

开始插入

image-20230302143011628

image-20230302143024728

image-20230302143040997

image-20230302143111003

image-20230302143840140

测试

Point select 测试命令


sysbench --config-file=config oltp_point_select --tables=1 --table-size=100000000  --db-ps-mode=auto --rand-type=uniform run

image-20230303161940996

Update index 测试命令

sysbench --config-file=config oltp_update_index --tables=1 --table-size=100000000  --db-ps-mode=auto --rand-type=uniform run

image-20230303163343905

Read-only 测试命令

sysbench --config-file=config oltp_read_only --tables=1 --table-size=100000000  --db-ps-mode=auto --rand-type=uniform run

image-20230303164727226

MySQL

硬盘占用

![image-20230302143337380](./assets/image-20230302143337380.png

image-20230302152110691

测试

sysbench --config-file=node004_config oltp_point_select --tables=1 --table-size=100000000 run

image-20230302155813408

Point select 测试命令

sysbench --config-file=node004_config oltp_point_select --tables=1 --table-size=100000000 --db-ps-mode=auto --rand-type=uniform run

image-20230302164950275

Update index 测试命令


sysbench --config-file=node004_config oltp_update_index --tables=1 --table-size=100000000 --db-ps-mode=auto --rand-type=uniform run

image-20230302170115682

Read-only 测试命令

sysbench --config-file=node004_config oltp_read_only --tables=1 --table-size=100000000 --db-ps-mode=auto --rand-type=uniform run

image-20230303145344587