tencent cloud

This document provides a performance comparison between a TDSQL shard and open-source MySQL (not optimized) for your reference.

Testing Environment for Comparison

Hardware: 24-core CPU; 128 GB memory; 1.8 TB SSD
Network environment: LAN with an average network latency of 0.80 ms
Operating system: CentOS 7.0
Data volume: 10 tables. Each of them has 2,180,000 data rows of about 5.2 GB. InnoDB buffer: 30 GB
Open-source version: MySQL 5.7.17 community version (not optimized; semi-sync enabled)
TDSQL shard version: MySQL 5.7 (strong sync enabled; thread pool enabled by default) with the following parameters:

• thread_pool_max_threads=2000
• thread_pool_oversubscribe = 10
• thread_pool_stall_limit = 50
• thread_handling = 2

Detailed Comparison Data

1. Data initialization parameters

create database caccts ;
./sysbench --num-threads=500 --test=./tests/db/oltp.lua.bak --oltp-table-size=2180000 --oltp-tables-count=10 --oltp-point-selects=1 --oltp-simple-ranges=0 --oltp-sum-ranges=0 --oltp-order-ranges=0 --oltp-index-updates=1 --oltp-non-index-updates=0 --report-interval=1 --mysql-user=xxxxxx --mysql-password=xxxxxx --mysql-host=xxxxxx --mysql-db=caccts --max-time=360000 --max-requests=2000000000 prepare

2. Non-index update (UPDATE)

./sysbench --num-threads=500 --test=./tests/db/update\_non\_index.lua --oltp-table-size=2180000 --oltp-tables-count=10 --percentile=99 --report-interval=1 --mysql-host=xxxx --mysql-user=xxx --mysql-password=xxx --mysql-db=caccts --max-time=360000 --max-requests=2000000000 --mysql-port=3306 run

3. Read-only (SELECT)

./sysbench --num-threads=500 --test=./tests/db/select.lua --oltp-table-size=2180000 --oltp-tables-count=10 --percentile=99 --report-interval=1 --mysql-host=xxxx --mysql-user=xxx --mysql-password=xxx --mysql-db=caccts --max-time=360000 -- max-requests=2000000000 --mysql-port=3306 run

4. Hybrid test

./sysbench\_orig --num-threads=500 --test=./tests/db/oltp\_new.lua --oltp-read-only=off --oltp-table-size=2180000 --oltp-tables-count=10 --oltp-point-selects=1 --oltp-simple-ranges=0 --oltp-sum-ranges=0 --oltp-order-ranges=0 --oltp-distinct-ranges=0 --oltp-index-updates=1 --oltp-non-index-updates=0 --percentile=99 --report-interval=1 --mysql-host=xxxx -- mysql-user=xxx --mysql-password=xxx --mysql-db=caccts --max-time=360000 --max-requests=2000000000 --mysql-port=3306 run

Read request (READ) test results

Write request (write) test results

Hybrid scenario (OLTP) test results