Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-32490

performance differs a lot between INNODB and MYISAM

    XMLWordPrintable

Details

    Description

      Using the same SQL statements to create tables, insert data and select data on INNODB and MYISAM respectively, the select performance differs by 100%.
      They are all simple data operations. Is this performance gap normal?

      The create&insert&select SQLs and performance statistics are in the attachment.

      Attachments

        1. create&insert.sql
          84 kB
        2. select1.sql
          8 kB
        3. select2.sql
          8 kB
        4. WX20231017-170059@2x.png
          WX20231017-170059@2x.png
          167 kB
        5. WX20231017-170122@2x.png
          WX20231017-170122@2x.png
          147 kB

        Activity

          People

            Unassigned Unassigned
            csfuzz csfuzz
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.