tencent cloud

Feedback

Full Cache Scenario Test Results

Last updated: 2022-04-13 12:04:10
    This document lists the performance comparison test results between TDSQL-C for MySQL and TencentDB for MySQL in the full cache scenario.

    Full Cache Scenario Overview

    In the full cache scenario, as all data can be put into the cache, the disk doesn't need to be read and written to update the cache during queries.

    Full Cache Scenario Test Conclusion

    The higher the instance specification, the more obvious the performance advantage of TDSQL-C for MySQL. TencentDB for MySQL's write and read-write performance reaches a bottleneck at the 32-core specification, but TDSQL-C for MySQL can further increase the QPS with more CPU cores.
    In most scenarios, 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.
    TDSQL-C for MySQL is more stable in terms of request delay (RTT) and almost doesn't jitter at all when the dataset is fully cached.
    Dataset Characteristics
    Test Scenario
    Read Type
    Conclusion
    Full cache
    Write
    -
    TDSQL-C for MySQL has a higher performance
    Read
    POINT SELECT
    TDSQL-C for MySQL has a higher performance
    Read
    RANGE SELECT
    TDSQL-C for MySQL and TencentDB for MySQL have generally the same performance under low specifications, but the latter outperforms the former under high 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

    Full Cache Scenario Test Results

    Scenario 1: Write
    
    Specification
    Concurrency
    Table Size
    Tables
    QPS
    TencentDB for MySQL
    TDSQL-C for MySQL
    2-core 16 GB MEM
    96
    25000
    250
    15665
    30054
    4-core 16 GB MEM
    192
    25000
    250
    40574
    53334
    4-core 32 GB MEM
    192
    25000
    250
    42966
    53713
    8-core 32 GB MEM
    256
    25000
    250
    67229
    100737
    8-core 64 GB MEM
    256
    25000
    250
    76955
    99480
    16-core 64 GB MEM
    512
    25000
    250
    134590
    181035
    16-core 96 GB MEM
    512
    25000
    250
    142419
    181029
    16-core 128 GB MEM
    512
    25000
    250
    144529
    181482
    32-core 128 GB MEM
    1000
    25000
    250
    224786
    319913
    32-core 256 GB MEM
    1000
    25000
    250
    220350
    370294
    64-core 256 GB MEM
    1000
    25000
    250
    236079
    448221
    Scenario 2: Read (POINT SELECT)
    
    Specification
    Concurrency
    Table Size
    Tables
    QPS
    TencentDB for MySQL
    TDSQL-C for MySQL
    2-core 16 GB MEM
    1500
    25000
    250
    38633
    57153
    4-core 16 GB MEM
    1500
    25000
    250
    80398
    108368
    4-core 32 GB MEM
    1500
    25000
    250
    81100
    108639
    8-core 32 GB MEM
    1500
    25000
    250
    159885
    185710
    8-core 64 GB MEM
    1500
    25000
    250
    172800
    206007
    16-core 64 GB MEM
    2000
    25000
    250
    313223
    402101
    16-core 96 GB MEM
    2000
    25000
    250
    321229
    402101
    16-core 128 GB MEM
    2000
    25000
    250
    321617
    403809
    32-core 128 GB MEM
    2000
    25000
    250
    409118
    715886
    32-core 256 GB MEM
    2000
    25000
    250
    549297
    719295
    64-core 256 GB MEM
    2000
    25000
    250
    670026
    1125180
    Scenario 3: Read (RANGE SELECT)
    
    Specification
    Concurrency
    Table Size
    Tables
    QPS
    TencentDB for MySQL
    TDSQL-C for MySQL
    2-core 16 GB MEM
    64
    25000
    250
    14474
    15837
    4-core 16 GB MEM
    64
    25000
    250
    31523
    31169
    4-core 32 GB MEM
    64
    25000
    250
    31988
    31048
    8-core 32 GB MEM
    64
    25000
    250
    50362
    59531
    8-core 64 GB MEM
    64
    25000
    250
    63686
    59008
    16-core 64 GB MEM
    128
    25000
    250
    113098
    113779
    16-core 96 GB MEM
    128
    25000
    250
    124928
    113377
    16-core 128 GB MEM
    128
    25000
    250
    128728
    113606
    32-core 128 GB MEM
    256
    25000
    250
    212540
    197144
    32-core 256 GB MEM
    256
    25000
    250
    199970
    197796
    64-core 256 GB MEM
    256
    25000
    250
    304502
    289460
    Scenario 4: Read-write (POINT SELECT)
    
    Specification
    Concurrency
    Table Size
    Tables
    QPS
    TencentDB for MySQL
    TDSQL-C for MySQL
    2-core 16 GB MEM
    512
    25000
    250
    22554
    38001
    4-core 16 GB MEM
    512
    25000
    250
    57841
    71560
    4-core 32 GB MEM
    512
    25000
    250
    60797
    72625
    8-core 32 GB MEM
    512
    25000
    250
    97243
    138499
    8-core 64 GB MEM
    512
    25000
    250
    112912
    138784
    16-core 64 GB MEM
    512
    25000
    250
    198182
    247586
    16-core 96 GB MEM
    512
    25000
    250
    203479
    247631
    16-core 128 GB MEM
    512
    25000
    250
    209947
    248301
    32-core 128 GB MEM
    512
    25000
    250
    348721
    400126
    32-core 256 GB MEM
    512
    25000
    250
    333932
    379531
    64-core 256 GB MEM
    512
    25000
    250
    439984
    553040
    Scenario 5: Read-write (RANGE SELECT)
    
    
    Specification
    Concurrency
    Table Size
    Tables
    QPS
    TencentDB for MySQL
    TDSQL-C for MySQL
    2-core 16 GB MEM
    64
    25000
    250
    13568
    16072
    4-core 16 GB MEM
    256
    25000
    250
    33318
    34553
    4-core 32 GB MEM
    256
    25000
    250
    33766
    34321
    8-core 32 GB MEM
    256
    25000
    250
    55588
    65190
    8-core 64 GB MEM
    256
    25000
    250
    62616
    65701
    16-core 64 GB MEM
    256
    25000
    250
    111148
    123984
    16-core 96 GB MEM
    256
    25000
    250
    131182
    124659
    16-core 128 GB MEM
    384
    25000
    250
    130767
    125947
    32-core 128 GB MEM
    384
    25000
    250
    218580
    214861
    32-core 256 GB MEM
    384
    25000
    250
    210922
    216303
    64-core 256 GB MEM
    384
    25000
    250
    308399
    312941
    
    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