tencent cloud

TDSQL for MySQL

Announcements
Alarm Upgrade
Product Introduction
Overview
Strengths
Use Cases
Regions and AZs
InnoDB engine
Purchase Guide
Billing Overview (InnoDB)
Product Pricing (InnoDB)
Purchase and Upgrade
Refund
Payment Overdue
Backup Space Billing
Getting Started
InnoDB Engine
Operation Guide（InnoDB）
Instance Management
Disaster Recovery Read-Only Instance
Changing Networks
Account Management
Security Management
Slow Query Analysis
Backup and Rollback
Data Migration
Database Audit
Practical Tutorial
Import from Standalone Instance to TDSQL Instance
Import Between TDSQL Instances
Selection of TDSQL Instance and Shard Configuration
Security White Paper
Platform Security Design
Tenant Security Features
Development Guide
InnoDB
API Documentation
History
Introduction
API Category
Security Group APIs
Other APIs
Making API Requests
TDSQL APIs
Data Types
Error Codes
FAQs
InnoDB
General References
Performance Comparison Data for Strong Sync
Glossary
Contact Us
ドキュメントTDSQL for MySQLGeneral ReferencesPerformance Comparison Data for Strong Sync

Performance Comparison Data for Strong Sync

PDF
フォーカスモード
フォントサイズ
最終更新日: 2024-01-06 17:35:36
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

Concurrence
Version
QPS
Average Response Time (ms)
99% Response Time (ms)
50
Open-source MySQL
304585
0.16
0.26
50
TDSQL
330695
0.15
0.24
100
Open-source MySQL
407443
0.24
0.48
100
TDSQL
484640
0.2
0.72
200
Open-source MySQL
433401
0.57
1
200
TDSQL
498215
0.55
1.22
500
Open-source MySQL
428542
1.16
2.42
500
TDSQL
494874
1.01
2.61
1000
Open-source MySQL
412775
2.4
6.3
1000
TDSQL
478393
2.08
4.21

Write request (write) test results

Concurrence
Version
QPS
Average Response Time (ms)
99% Response Time (ms)
50
Open-source MySQL
14816
3.37
4.82
50
TDSQL
28925
1.73
2.55
100
Open-source MySQL
25046
3.99
6.91
100
TDSQL
43466
2.3
4
200
Open-source MySQL
32690
6.12
10.86
200
TDSQL
54045
3.7
7.27
500
Open-source MySQL
37192
13.44
21.1
500
TDSQL
70370
7.25
15.52
1000
Open-source MySQL
35447
28.2
40.47
1000
TDSQL
69890
14.35
30.73

Hybrid scenario (OLTP) test results

Concurrence
Version
QPS
Average Response Time (ms)
99% Response Time (ms)
50
Open-source MySQL
63806
4.7
7.13
50
TDSQL
162883
1.84
3.45
100
Open-source MySQL
102516
5.85
11.4
100
TDSQL
173974
3.58
6.64
200
Open-source MySQL
124550
9.64
18.92
200
TDSQL
208128
5.76
11.9
500
Open-source MySQL
125386
23.93
39.68
500
TDSQL
232543
13.58
27.81
1000
Open-source MySQL
121765
49.29
80.71
1000
TDSQL
226130
27.76
54.78
前の記事へ: IO Metric Exception次の記事へ: Glossary

ヘルプとサポート

この記事はお役に立ちましたか？

フィードバック