Results of the Full-Cache Test
Last updated: 2025-12-10 16:18:35
This article describes the performance test results of TDSQL-C for MySQL under read-only, hybrid read-write, and write-only scenarios when the dataset is fully cached.
Definition of Fully Cached
Fully-cached scenario refers to a situation where all data can be stored in cache, eliminating the need to read from or write to disks for cache updates during querying.
Test Scenarios for Fully-Cached and Read Types
Dataset Characteristics | Test Scenario | Read Type |
Fully-Cached | Read-Only | range select |
| | point select |
| Mixed Read/Write | range select |
| | point select |
| Write-Only | - |
Fully-Cached Test Results
Scenario 1: Read-Only (range select)
Specification | concurrent | Single-Table Data Volume (table_size) | Total Number of Tables (Tables) | QPS |
2-core 4 GB | 64 | 25000 | 250 | 44613.74 |
4-core 8 GB | 256 | 25000 | 250 | 58183.91 |
8-core 16 GB | 128 | 25000 | 250 | 89774.81 |
8-core 32 GB | 64 | 25000 | 250 | 89939.51 |
8-core 64 GB | 256 | 25000 | 250 | 105651.42 |
16-core 64 GB | 128 | 25000 | 250 | 172325.85 |
16-core 96 GB | 64 | 25000 | 250 | 171543.18 |
16-core 128 GB | 128 | 25000 | 250 | 172207.71 |
24-core 144 GB | 128 | 25000 | 250 | 253575.68 |
32-core 128 GB | 128 | 25000 | 250 | 309436.4 |
32-core 256 GB | 128 | 25000 | 250 | 309426.71 |
64-core 256 GB | 512 | 25000 | 250 | 514380.66 |
64-core 512 GB | 512 | 25000 | 250 | 514400.36 |
88-core 710 GB | 32 | 25000 | 250 | 944192.16 |
Scenario 2: Read-Only (point select)
Specification | concurrent | Single-Table Data Volume (table_size) | Total Number of Tables (Tables) | QPS |
2-core 4 GB | 64 | 25000 | 250 | 70427.77 |
4-core 8 GB | 64 | 25000 | 250 | 98276.43 |
8-core 16 GB | 64 | 25000 | 250 | 184217.54 |
8-core 32 GB | 128 | 25000 | 250 | 185239.75 |
8-core 64 GB | 256 | 25000 | 250 | 188593.28 |
16-core 64 GB | 128 | 25000 | 250 | 357340.39 |
16-core 96 GB | 128 | 25000 | 250 | 359330.67 |
16-core 128 GB | 128 | 25000 | 250 | 358882.04 |
24-core 144 GB | 256 | 25000 | 250 | 499279.58 |
32-core 128 GB | 256 | 25000 | 250 | 653442.34 |
32-core 256 GB | 256 | 25000 | 250 | 662565.13 |
64-core 256 GB | 512 | 25000 | 250 | 936391.58 |
64-core 512 GB | 512 | 25000 | 250 | 981499.52 |
88-core 710 GB | 1024 | 25000 | 250 | 1554269.37 |
Scenario 3: Mixed Read-Write (range select)
Specification | concurrent | Single-Table Data Volume (table_size) | Total Number of Tables (Tables) | QPS |
2-core 4 GB | 64 | 25000 | 250 | 23733.31 |
4-core 8 GB | 128 | 25000 | 250 | 43194.53 |
8-core 16 GB | 256 | 25000 | 250 | 78650.06 |
8-core 32 GB | 512 | 25000 | 250 | 79727.2 |
8-core 64 GB | 128 | 25000 | 250 | 79531.15 |
16-core 64 GB | 128 | 25000 | 250 | 151194.82 |
16-core 96 GB | 256 | 25000 | 250 | 153050.09 |
16-core 128 GB | 128 | 25000 | 250 | 154380.69 |
24-core 144 GB | 256 | 25000 | 250 | 223228.12 |
32-core 128 GB | 256 | 25000 | 250 | 296140.77 |
32-core 256 GB | 256 | 25000 | 250 | 306861.71 |
64-core 256 GB | 256 | 25000 | 250 | 485157 |
64-core 512 GB | 256 | 25000 | 250 | 490113.07 |
88-core 710 GB | 256 | 25000 | 250 | 742107.07 |
Scenario 4: Mixed Read-Write (point select)
Specification | concurrent | Single-Table Data Volume (table_size) | Total Number of Tables (Tables) | QPS |
2-core 4 GB | 64 | 25000 | 250 | 33696.24 |
4-core 8 GB | 64 | 25000 | 250 | 66878.78 |
8-core 16 GB | 128 | 25000 | 250 | 121551.65 |
8-core 32 GB | 256 | 25000 | 250 | 123148.86 |
8-core 64 GB | 256 | 25000 | 250 | 124961.51 |
16-core 64 GB | 256 | 25000 | 250 | 231962.71 |
16-core 96 GB | 256 | 25000 | 250 | 233617.5 |
16-core 128 GB | 128 | 25000 | 250 | 233620.29 |
24-core 144 GB | 256 | 25000 | 250 | 326349 |
32-core 128 GB | 256 | 25000 | 250 | 418784.82 |
32-core 256 GB | 256 | 25000 | 250 | 423749.9 |
64-core 256 GB | 256 | 25000 | 250 | 551369.09 |
64-core 512 GB | 256 | 25000 | 250 | 582483.33 |
88-core 710 GB | 512 | 25000 | 250 | 809446.57 |
Scenario 5: Write-Only
Specification | concurrent | Single-Table Data Volume (table_size) | Total Number of Tables (Tables) | QPS |
2-core 4 GB | 128 | 25000 | 250 | 26232.98 |
4-core 8 GB | 128 | 25000 | 250 | 51016.74 |
8-core 16 GB | 128 | 25000 | 250 | 101316.26 |
8-core 32 GB | 128 | 25000 | 250 | 102144.65 |
8-core 64 GB | 128 | 25000 | 250 | 101816.95 |
16-core 64 GB | 128 | 25000 | 250 | 178527.42 |
16-core 96 GB | 128 | 25000 | 250 | 181410.96 |
16-core 128 GB | 128 | 25000 | 250 | 180262.74 |
24-core 144 GB | 1024 | 25000 | 250 | 236567.99 |
32-core 128 GB | 1024 | 25000 | 250 | 292344.16 |
32-core 256 GB | 1024 | 25000 | 250 | 309690.15 |
64-core 256 GB | 1024 | 25000 | 250 | 395110.02 |
64-core 512 GB | 1024 | 25000 | 250 | 394911.08 |
88-core 710 GB | 1500 | 25000 | 250 | 507327.18 |
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback