tencent cloud

Feedback

Test Results - 1 TB Single Table Scenario

Last updated: 2022-04-13 12:04:11

    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 CharacteristicsTest ScenarioRead TypeConclusion
    1 TB single tableWrite-TDSQL-C for MySQL has a higher performance
    ReadPOINT SELECTTDSQL-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
    ReadRANGE SELECTTDSQL-C for MySQL and TencentDB for MySQL have generally the same performance under most specifications
    Read-writePOINT SELECTTDSQL-C for MySQL has a higher performance
    Read-writeRANGE SELECTTDSQL-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 MEM256400000000011088117816
    4-core 16 GB MEM512400000000012682733700
    4-core 32 GB MEM512400000000013140441098
    8-core 32 GB MEM512400000000014416776047
    8-core 64 GB MEM512400000000015560981191
    16-core 64 GB MEM5124000000000188401134317
    16-core 96 GB MEM5124000000000197068134923
    16-core 128 GB MEM51240000000001101274134340
    32-core 128 GB MEM51240000000001111626196333
    32-core 256 GB MEM51240000000001131058206395
    64-core 256 GB MEM51240000000001140587256415

    Scenario 2: Read (POINT SELECT)

    Specification Concurrency Table Size Tables QPS
    TencentDB for MySQL TDSQL-C for MySQL
    2-core 16 GB MEM256400000000012913531504
    4-core 16 GB MEM512400000000015966761128
    4-core 32 GB MEM512400000000016621964707
    8-core 32 GB MEM51240000000001119374128884
    8-core 64 GB MEM51240000000001127005129857
    16-core 64 GB MEM100040000000001229007210873
    16-core 96 GB MEM100040000000001230460217415
    16-core 128 GB MEM100040000000001236767228319
    32-core 128 GB MEM100040000000001377009368868
    32-core 256 GB MEM100040000000001412356421931
    64-core 256 GB MEM100040000000001569523794997

    Scenario 3: Read (RANGE SELECT)

    Specification Concurrency Table Size Tables QPS
    TencentDB for MySQL TDSQL-C for MySQL
    2-core 16 GB MEM32400000000011177314358
    4-core 16 GB MEM64400000000012568826093
    4-core 32 GB MEM64400000000012682628748
    8-core 32 GB MEM128400000000014899854387
    8-core 64 GB MEM128400000000015498760345
    16-core 64 GB MEM25640000000001103212113117
    16-core 96 GB MEM25640000000001105302113609
    16-core 128 GB MEM25640000000001108209114218
    32-core 128 GB MEM51240000000001187161190716
    32-core 256 GB MEM51240000000001192407190472
    64-core 256 GB MEM100040000000001308631319047

    Scenario 4: Read-write (POINT SELECT)

    Specification Concurrency Table Size Tables QPS
    TencentDB for MySQL TDSQL-C for MySQL
    2-core 16 GB MEM64400000000011631324150
    4-core 16 GB MEM64400000000013889642051
    4-core 32 GB MEM128400000000014703653506
    8-core 32 GB MEM2564000000000180167103935
    8-core 64 GB MEM2564000000000193335123395
    16-core 64 GB MEM51240000000001135267220769
    16-core 96 GB MEM51240000000001140926229214
    16-core 128 GB MEM51240000000001152629234357
    32-core 128 GB MEM51240000000001199042381067
    32-core 256 GB MEM51240000000001223027384323
    64-core 256 GB MEM100040000000001283722520265

    Scenario 5: Read-write (RANGE SELECT)

    Specification Concurrency Table Size Tables QPS
    TencentDB for MySQL TDSQL-C for MySQL
    2-core 16 GB MEM256400000000011017712129
    4-core 16 GB MEM512400000000012347522560
    4-core 32 GB MEM512400000000012702326009
    8-core 32 GB MEM512400000000014808752183
    8-core 64 GB MEM512400000000015391553766
    16-core 64 GB MEM512400000000019803895518
    16-core 96 GB MEM512400000000019750497117
    16-core 128 GB MEM5124000000000110146199140
    32-core 128 GB MEM51240000000001154222171150
    32-core 256 GB MEM51240000000001182955183249
    64-core 256 GB MEM51240000000001246526266539
    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