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 |
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 |
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 |
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 |
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 |
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 |
Was this page helpful?