tencent cloud

Feedback

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
    
    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