Results of the Full-Cache Test
Last updated: 2025-12-16 11:04:41
This article introduces the performance test results of TDSQL-C for MySQL's compiler-optimized high-performance edition under fully cached dataset characteristics in read-only, mixed read/write, and write-only scenarios.
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 | 67157.12 |
4-core 8 GB | 256 | 25000 | 250 | 81927.78 |
8-core 16 GB | 128 | 25000 | 250 | 147508.78 |
8-core 32 GB | 64 | 25000 | 250 | 134830.77 |
8-core 64 GB | 256 | 25000 | 250 | 162284.55 |
16-core 64 GB | 128 | 25000 | 250 | 253569.63 |
16-core 96 GB | 64 | 25000 | 250 | 275680.14 |
16-core 128 GB | 128 | 25000 | 250 | 279237.14 |
24-core 144 GB | 128 | 25000 | 250 | 359549.06 |
32-core 128 GB | 128 | 25000 | 250 | 469481.46 |
32-core 256 GB | 128 | 25000 | 250 | 472481.46 |
64-core 256 GB | 512 | 25000 | 250 | 705204.1 |
64-core 512 GB | 512 | 25000 | 250 | 705300.08 |
88-core 710 GB | 32 | 25000 | 250 | 1288237.1 |
Scenario 2: Read-Only (point select)
Specification | concurrent | Volume of Single-Table Data (table_size) | Total Number of Tables (Tables) | QPS |
2-core 4 GB | 64 | 25000 | 250 | 103964.29 |
4-core 8 GB | 64 | 25000 | 250 | 160432.69 |
8-core 16 GB | 64 | 25000 | 250 | 313895.43 |
8-core 32 GB | 128 | 25000 | 250 | 312152.46 |
8-core 64 GB | 256 | 25000 | 250 | 307095.12 |
16-core 64 GB | 128 | 25000 | 250 | 540219.2 |
16-core 96 GB | 128 | 25000 | 250 | 553683.3 |
16-core 128 GB | 128 | 25000 | 250 | 557387.48 |
24-core 144 GB | 256 | 25000 | 250 | 710764.8 |
32-core 128 GB | 256 | 25000 | 250 | 921266.52 |
32-core 256 GB | 256 | 25000 | 250 | 931116.61 |
64-core 256 GB | 512 | 25000 | 250 | 1309731.39 |
64-core 512 GB | 512 | 25000 | 250 | 1312190.48 |
88-core 710 GB | 1024 | 25000 | 250 | 2124814.89 |
Scenario 3: Mixed Read-Write (range select)
Specification | concurrent | Volume of Single-Table Data (table_size) | Total Number of Tables (Tables) | QPS |
2-core 4 GB | 64 | 25000 | 250 | 37582.98 |
4-core 8 GB | 128 | 25000 | 250 | 63166.51 |
8-cores 16 GB | 256 | 25000 | 250 | 130589.07 |
8-core 32 GB | 512 | 25000 | 250 | 123553.3 |
8-core 64 GB | 128 | 25000 | 250 | 121701.75 |
16-core 64 GB | 128 | 25000 | 250 | 226725.64 |
16-core 96 GB | 256 | 25000 | 250 | 243116.35 |
16-core 128 GB | 128 | 25000 | 250 | 243274.76 |
24-core 144 GB | 256 | 25000 | 250 | 333815.28 |
32-core 128 GB | 256 | 25000 | 250 | 451024.89 |
32-core 256 GB | 256 | 25000 | 250 | 451392.99 |
64-core 256 GB | 256 | 25000 | 250 | 670782.75 |
64-core 512 GB | 256 | 25000 | 250 | 674722.87 |
88-core 710 GB | 256 | 25000 | 250 | 978395.67 |
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 | 50761.78 |
4-core 8 GB | 64 | 25000 | 250 | 107002.71 |
8-core 16 GB | 128 | 25000 | 250 | 207201.66 |
8-core 32 GB | 256 | 25000 | 250 | 203370.75 |
8-core 64 GB | 256 | 25000 | 250 | 203891.75 |
16-core 64 GB | 256 | 25000 | 250 | 348399.43 |
16-core 96 GB | 256 | 25000 | 250 | 360603.45 |
16-core 128 GB | 128 | 25000 | 250 | 370570.5 |
24-core 144 GB | 256 | 25000 | 250 | 460349.45 |
32-core 128 GB | 256 | 25000 | 250 | 604026.95 |
32-core 256 GB | 256 | 25000 | 250 | 610779.6 |
64-core 256 GB | 256 | 25000 | 250 | 757522.73 |
64-core 512 GB | 256 | 25000 | 250 | 787119.57 |
88-core 710 GB | 512 | 25000 | 250 | 1090329.43 |
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 | 40182.79 |
4-core 8 GB | 128 | 25000 | 250 | 85121.39 |
8-core 16 GB | 128 | 25000 | 250 | 155333.32 |
8-core 32 GB | 128 | 25000 | 250 | 159027.87 |
8-core 64 GB | 128 | 25000 | 250 | 147361.41 |
16-core 64 GB | 128 | 25000 | 250 | 261582.62 |
16-core 96 GB | 128 | 25000 | 250 | 265005.32 |
16-core 128 GB | 128 | 25000 | 250 | 333482.98 |
24-core 144 GB | 1024 | 25000 | 250 | 338179.58 |
32-core 128 GB | 1024 | 25000 | 250 | 430672.91 |
32-core 256 GB | 1024 | 25000 | 250 | 434778.25 |
64-core 256 GB | 1024 | 25000 | 250 | 551520.53 |
64-core 512 GB | 1024 | 25000 | 250 | 558780.8 |
88-core 710 GB | 1500 | 25000 | 250 | 643965.01 |
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback