Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-16762

See significant throughput drop with MySQL version 8 from version 5.7

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Not a defect
    • 7.2.0, 7.1.0
    • 7.2.0
    • IDM 7.2.0 master, MySQL version 8.0.22 vs 5.7.0 runs on Linux 7.5 CentOS.
    • 2
    • 2021.Fall

    Description

      Many perf tests using MySQL as IDM repo showed significant throughput drop after upgraded MySQL version from 5.7.0 to 8.0.22 on perf test machines in PERFZONE. Here are the throughput/mean response times between MySQL 5.7.25(used 7.2.0 baseline) and 8.0.22(collected from latest test runs) using simple managed users CRUD tests:

      Tests MySQl 5.7.25 MySQL 8.0.22 Throughput Diff
      create 581/51 481/62 -17%
      read 1562/19 1516/20 -3%
      update 439/45 318/62 -28%
      delete 548/36 375/53 -32%
      query by id 1569/25 1560/25 0%

      Here are IDM and MySQL CPU, memory usages during  create managed user test runs, 

      MySQL Version IDM CPU IDM Memory MySQLd CPU MySQLd Memory
      MySQL5.7.25 789% 7.7% 158.8% 0.6%
      MySQL8.0.22 648% 7.8% 185% 0.9%

      Commands to start MySQL server using docker image:

      docker run -d --cpuset-cpus=0,1 --name mysql8.0.22_test -p=3306:3306 -e MYSQL_ROOT_PASSWORD=secret12 mysql:8.0.22 

      the similar command is used for version: 5.7.25

      Attached are jstack trace and idm metrics collected in the managed users create tests.

      I'm uncertain to choose the Jira type as an investigation story or bug, maybe it's not a bug but just something we need to investigate and understand.

      Attachments

        1. finished-create.5.7.25
          42 kB
        2. finished-create.8.0.22
          42 kB
        3. idm.jstack-5.7
          1.05 MB
        4. idm.jstack-8.0
          965 kB

        Activity

          People

            jason.vincent jason vincent
            Tinghua.Xu Tinghua Xu [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: