tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
TencentDB for MySQL
    Documentation
    Download PDF

    MySQL 8.0 Test Results

    Last updated: 2022-03-24 15:12:45
    Download PDF

      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.

      Contact Us
      Technical Support

      Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

      Submit a Ticket
      7x24 Phone Support
      Copyright © 2013-2024 Tencent Cloud. All Rights Reserved.
      Privacy PolicyLegalCookie Policy