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

Opening all .ibd files on InnoDB startup can be slow

Details

    Description

      2023-08-14 9:13:29 0 [Note] InnoDB: Uses event mutexes
      2023-08-14 9:13:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
      2023-08-14 9:13:29 0 [Note] InnoDB: Number of pools: 1
      2023-08-14 9:13:29 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
      2023-08-14 9:13:29 0 [Note] InnoDB: Initializing buffer pool, total size = 5368709120, chunk size = 134217728
      2023-08-14 9:13:29 0 [Note] InnoDB: Completed initialization of buffer pool
      2023-08-14 9:13:31 0 [Note] InnoDB: 128 rollback segments are active.
      2023-08-14 9:17:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables
      2023-08-14 9:17:50 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
      2023-08-14 9:17:50 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
      2023-08-14 9:17:50 0 [Note] InnoDB: 10.5.22 started; log sequence number 197013855628; transaction id 455278971

      2023-08-14 9:13:31 0 [Note] InnoDB: 128 rollback segments are active.
      2023-08-14 9:17:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables.

      MySQL starts slowly, rollback segments and Creating shared tablespace with an interval of over 4 minutes.

      Attachments

        1. 1.jpg
          1.jpg
          414 kB
        2. 2.jpg
          2.jpg
          489 kB
        3. 3.jpg
          3.jpg
          156 kB
        4. Capture.PNG
          Capture.PNG
          317 kB
        5. dump50.sql.gz
          1.13 MB
        6. my.ini
          2 kB

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-32228 Optimize is_file_on_ssd() to speedup opening tablespaces on Windows

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33360 fil_node_t::handle had better not be protected by fil_system.mutex

          • Major - Major loss of function.
          • Confirmed

          Activity

            Ascending order - Click to sort in descending order
            kennyliao kennyliao created issue -
            marko Marko Mäkelä made changes -
            Field Original Value New Value
            Assignee Marko Mäkelä [ marko ]
            Status Open [ 1 ] Needs Feedback [ 10501 ]
            kennyliao kennyliao made changes -
            Comment [ i set the initialization of a 3GiB buffer pool ,innodb_buffer_pool_size = 3072MiB ]
            marko Marko Mäkelä made changes -
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.10 [ 27530 ]
            Fix Version/s 10.11 [ 27614 ]
            Fix Version/s 11.0 [ 28320 ]
            Fix Version/s 11.1 [ 28549 ]
            Fix Version/s 11.2 [ 28603 ]
            Environment Microsoft Windows
            Labels performance
            Priority Blocker [ 1 ] Critical [ 2 ]
            marko Marko Mäkelä made changes -
            Status Needs Feedback [ 10501 ] Open [ 1 ]
            kennyliao kennyliao made changes -
            Comment [  !1.png|thumbnail! ]
            kennyliao kennyliao made changes -
            Attachment 微信图片_20230829140120.jpg [ 71732 ]
            kennyliao kennyliao made changes -
            Attachment 1.jpg [ 71733 ]
            kennyliao kennyliao made changes -
            Attachment 2.jpg [ 71734 ]
            kennyliao kennyliao made changes -
            Attachment 3.jpg [ 71735 ]
            kennyliao kennyliao made changes -
            Attachment 微信图片_20230829140120.jpg [ 71732 ]
            kennyliao kennyliao made changes -
            Affects Version/s 10.5 [ 23123 ]
            Affects Version/s 10.5.22 [ 29011 ]
            hholzgra Hartmut Holzgraefe made changes -
            Attachment Capture.PNG [ 71949 ]
            hholzgra Hartmut Holzgraefe made changes -
            Attachment dump50.sql.gz [ 71950 ]
            danblack Daniel Black made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            wlad Vladislav Vaintroub made changes -
            marko Marko Mäkelä made changes -
            Status Confirmed [ 10101 ] In Progress [ 3 ]
            marko Marko Mäkelä made changes -
            Component/s Storage Engine - InnoDB [ 10129 ]
            Component/s Server [ 13907 ]
            Fix Version/s 11.3 [ 28565 ]
            Fix Version/s 10.10 [ 27530 ]
            Affects Version/s 10.6 [ 24028 ]
            Summary mariadb10.5.22 startup is slow Opening all .ibd files on InnoDB startup is slow on Microsoft Windows
            marko Marko Mäkelä made changes -
            Assignee Marko Mäkelä [ marko ] Thirunarayanan Balathandayuthapani [ thiru ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            marko Marko Mäkelä made changes -
            Summary Opening all .ibd files on InnoDB startup is slow on Microsoft Windows Opening all .ibd files on InnoDB startup can be slow
            thiru Thirunarayanan Balathandayuthapani made changes -
            Assignee Thirunarayanan Balathandayuthapani [ thiru ] Marko Mäkelä [ marko ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            marko Marko Mäkelä made changes -
            issue.field.resolutiondate 2023-11-17 14:54:39.0 2023-11-17 14:54:38.689
            marko Marko Mäkelä made changes -
            Fix Version/s 10.6.17 [ 29518 ]
            Fix Version/s 10.11.7 [ 29519 ]
            Fix Version/s 11.0.5 [ 29520 ]
            Fix Version/s 11.1.4 [ 29024 ]
            Fix Version/s 11.2.3 [ 29521 ]
            Fix Version/s 11.3.2 [ 29522 ]
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.11 [ 27614 ]
            Fix Version/s 11.0 [ 28320 ]
            Fix Version/s 11.1 [ 28549 ]
            Fix Version/s 11.3 [ 28565 ]
            Fix Version/s 11.2 [ 28603 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            marko Marko Mäkelä made changes -
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 180868

            People

              marko Marko Mäkelä
              kennyliao kennyliao
              Votes:
              0 Vote for this issue
              Watchers:
              7 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.