tencent cloud

Feedback

MySQL 8.0 Test Results

Last updated: 2024-07-23 17:41:50
    This document describes the performance test results of a general TencentDB for MySQL 8.0 instance.

    Scenario 1: Full Cache

    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.
    
    CPU
    (Core)
    Memory
    (MB)
    Concurrency
    Data Volume/Table
    Total Tables
    SysBench TPS
    SysBench QPS
    avg_lat
    1
    1000
    8
    25000
    150
    570.35
    11406.9
    14.03
    1
    2000
    8
    25000
    150
    634.44
    12688.9
    12.61
    2
    4000
    16
    25000
    150
    932.46
    18649.2
    17.16
    4
    8000
    32
    25000
    150
    2025.13
    40502.7
    15.8
    4
    16000
    32
    25000
    150
    2013.2
    40264
    15.89
    8
    16000
    64
    25000
    150
    3555.2
    71104.1
    18
    8
    32000
    64
    25000
    150
    3564.24
    71284.7
    17.95
    16
    32000
    128
    25000
    150
    5767.44
    115349
    22.19
    16
    64000
    128
    25000
    150
    6558.19
    131164
    19.51
    16
    96000
    128
    25000
    150
    6517.01
    130340
    19.63
    16
    128000
    128
    25000
    150
    6539.98
    130800
    19.57

    Scenario 2: Disk I/O

    In the disk I/O scenario, as only part of the data can be put into the cache, the disk needs to be read and written to update the cache during queries.
    
    CPU
    (Core)
    Memory
    (MB)
    Concurrency
    Data Volume/Table
    Total Tables
    SysBench TPS
    SysBench QPS
    avg_lat
    1
    1000
    8
    800000
    6
    582.76
    11655.1
    13.73
    1
    2000
    8
    800000
    12
    588.92
    11778.4
    13.58
    2
    4000
    16
    800000
    24
    899.06
    17981.2
    17.8
    4
    8000
    32
    800000
    48
    1915.83
    38316.6
    16.7
    4
    16000
    32
    6000000
    13
    1884.2
    37684
    16.98
    8
    16000
    64
    6000000
    13
    3356.71
    67134.2
    19.06
    8
    32000
    64
    6000000
    25
    3266.73
    65334.6
    19.59
    16
    32000
    128
    6000000
    25
    5370.18
    107404
    23.83
    16
    64000
    128
    6000000
    49
    5910.85
    118217
    21.65
    16
    96000
    128
    6000000
    74
    5813.94
    116279
    22.01
    16
    128000
    128
    6000000
    98
    5700.06
    114001
    22.45
    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