tencent cloud

Feedback

TDSQL-C for MySQL

1 TB Single Table Scenario Test Results

Last updated: 2023-11-20 17:44:29
This document lists the performance comparison test results between TDSQL-C for MySQL and TencentDB for MySQL in the 1 TB single table scenario.

Overview

In the 1 TB single table scenario, the test dataset contains 4 billion data records in one single table with a storage space of 1 TB.

Test Conclusion

In the read scenario, TDSQL-C for MySQL can achieve a CPU utilization of above 90% on compute nodes. The test shows that the resource utilization of TDSQL-C for MySQL is better than that of TencentDB for MySQL.
In the write scenario, TDSQL-C for MySQL outperforms TencentDB for MySQL under lower specifications, and as the specifications and data volume increase, its performance advantage gets much greater.
Dataset Characteristics
Test Scenario
Read Type
Conclusion
1 TB single table
Write
-
TDSQL-C for MySQL has a higher performance
Read
POINT SELECT
TDSQL-C for MySQL and TencentDB for MySQL have generally the same performance under most specifications, but the former outperforms the latter under the maximum specification
Read
RANGE SELECT
TDSQL-C for MySQL and TencentDB for MySQL have generally the same performance under most specifications
Read-write
POINT SELECT
TDSQL-C for MySQL has a higher performance
Read-write
RANGE SELECT
TDSQL-C for MySQL and TencentDB for MySQL have generally the same performance under most specifications

Test Results

Scenario 1: Write

Specification
Concurrency
Table Size
Tables
QPS
TencentDB for MySQL
TDSQL-C for MySQL
2-core 16 GB MEM
256
4000000000
1
10881
17816
4-core 16 GB MEM
512
4000000000
1
26827
33700
4-core 32 GB MEM
512
4000000000
1
31404
41098
8-core 32 GB MEM
512
4000000000
1
44167
76047
8-core 64 GB MEM
512
4000000000
1
55609
81191
16-core 64 GB MEM
512
4000000000
1
88401
134317
16-core 96 GB MEM
512
4000000000
1
97068
134923
16-core 128 GB MEM
512
4000000000
1
101274
134340
32-core 128 GB MEM
512
4000000000
1
111626
196333
32-core 256 GB MEM
512
4000000000
1
131058
206395
64-core 256 GB MEM
512
4000000000
1
140587
256415
Scenario 2: Read

Specification
Concurrency
Table Size
Tables
QPS
TencentDB for MySQL
TDSQL-C for MySQL
2-core 16 GB MEM
256
4000000000
1
29135
31504
4-core 16 GB MEM
512
4000000000
1
59667
61128
4-core 32 GB MEM
512
4000000000
1
66219
64707
8-core 32 GB MEM
512
4000000000
1
119374
128884
8-core 64 GB MEM
512
4000000000
1
127005
129857
16-core 64 GB MEM
1000
4000000000
1
229007
210873
16-core 96 GB MEM
1000
4000000000
1
230460
217415
16-core 128 GB MEM
1000
4000000000
1
236767
228319
32-core 128 GB MEM
1000
4000000000
1
377009
368868
32-core 256 GB MEM
1000
4000000000
1
412356
421931
64-core 256 GB MEM
1000
4000000000
1
569523
794997
Scenario 3: Read

Specification
Concurrency
Table Size
Tables
QPS
TencentDB for MySQL
TDSQL-C for MySQL
2-core 16 GB MEM
32
4000000000
1
11773
14358
4-core 16 GB MEM
64
4000000000
1
25688
26093
4-core 32 GB MEM
64
4000000000
1
26826
28748
8-core 32 GB MEM
128
4000000000
1
48998
54387
8-core 64 GB MEM
128
4000000000
1
54987
60345
16-core 64 GB MEM
256
4000000000
1
103212
113117
16-core 96 GB MEM
256
4000000000
1
105302
113609
16-core 128 GB MEM
256
4000000000
1
108209
114218
32-core 128 GB MEM
512
4000000000
1
187161
190716
32-core 256 GB MEM
512
4000000000
1
192407
190472
64-core 256 GB MEM
1000
4000000000
1
308631
319047
Scenario 4: Read-write

Specification
Concurrency
Table Size
Tables
QPS
TencentDB for MySQL
TDSQL-C for MySQL
2-core 16 GB MEM
64
4000000000
1
16313
24150
4-core 16 GB MEM
64
4000000000
1
38896
42051
4-core 32 GB MEM
128
4000000000
1
47036
53506
8-core 32 GB MEM
256
4000000000
1
80167
103935
8-core 64 GB MEM
256
4000000000
1
93335
123395
16-core 64 GB MEM
512
4000000000
1
135267
220769
16-core 96 GB MEM
512
4000000000
1
140926
229214
16-core 128 GB MEM
512
4000000000
1
152629
234357
32-core 128 GB MEM
512
4000000000
1
199042
381067
32-core 256 GB MEM
512
4000000000
1
223027
384323
64-core 256 GB MEM
1000
4000000000
1
283722
520265
Scenario 5: Read-write (RANGE SELECT)

Specification
Concurrency
Table Size
Tables
QPS
TencentDB for MySQL
TDSQL-C for MySQL
2-core 16 GB MEM
256
4000000000
1
10177
12129
4-core 16 GB MEM
512
4000000000
1
23475
22560
4-core 32 GB MEM
512
4000000000
1
27023
26009
8-core 32 GB MEM
512
4000000000
1
48087
52183
8-core 64 GB MEM
512
4000000000
1
53915
53766
16-core 64 GB MEM
512
4000000000
1
98038
95518
16-core 96 GB MEM
512
4000000000
1
97504
97117
16-core 128 GB MEM
512
4000000000
1
101461
99140
32-core 128 GB MEM
512
4000000000
1
154222
171150
32-core 256 GB MEM
512
4000000000
1
182955
183249
64-core 256 GB MEM
512
4000000000
1
246526
266539


Catalog

In The Article

1 TB Single Table Scenario Test Results

Contact Us

Contact our sales team or business advisors to help your business.

Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon