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

Innodb allocates almost 3GB instead if requested 1.5GB

Details

    Description

      This is a followup of MDEV-11520 .
      32bit Windows, with innodb_buffer_pool_size set to 1500M.
      however, error log (https://jira.mariadb.org/secure/attachment/42987/error.log) claims that 2.75GB were allocated instead, which is almost double the requested size. This creates memory pressure, resulting into failing allocations later, since only around 1GB virtual memory is left for the whole server(i.e on 64 Windows running 32bit mysqld.exe, because on 32bit Windows, this rounding would result in a server that cannot start

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11520 Extending an InnoDB data file unnecessarily allocates a large memory buffer on Windows

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-13177 MariaDB 10.2.6 eats virtual memory

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            wlad Vladislav Vaintroub created issue -
            wlad Vladislav Vaintroub made changes -
            Field Original Value New Value
            Issue Type Task [ 3 ] Bug [ 1 ]
            wlad Vladislav Vaintroub made changes -
            Affects Version/s 10.2 [ 14601 ]
            wlad Vladislav Vaintroub made changes -
            Description This is a followup of MDEV-11520 .
            32bit Windows, with innodb_buffer_pool_size set to 1500M.
            however, error log claims that 2.75GB were allocated instead, which is almost double the requested size
            wlad Vladislav Vaintroub made changes -
            Component/s Storage Engine - InnoDB [ 10129 ]
            wlad Vladislav Vaintroub made changes -
            Description This is a followup of MDEV-11520 .
            32bit Windows, with innodb_buffer_pool_size set to 1500M.
            however, error log claims that 2.75GB were allocated instead, which is almost double the requested size             		This is a followup of MDEV-11520 .
            32bit Windows, with innodb_buffer_pool_size set to 1500M.
            however, error log (https://jira.mariadb.org/secure/attachment/42987/error.log) claims that 2.75GB were allocated instead, which is almost double the requested size
            wlad Vladislav Vaintroub made changes -
            Description This is a followup of MDEV-11520 .
            32bit Windows, with innodb_buffer_pool_size set to 1500M.
            however, error log (https://jira.mariadb.org/secure/attachment/42987/error.log) claims that 2.75GB were allocated instead, which is almost double the requested size             		This is a followup of MDEV-11520 .
            32bit Windows, with innodb_buffer_pool_size set to 1500M.
            however, error log (https://jira.mariadb.org/secure/attachment/42987/error.log) claims that 2.75GB were allocated instead, which is almost double the requested size. This creates memory pressure, resulting into failing allocations later, since only around 1GB virtual memory is left for the whole server(i.e on 64 Windows running 32bit mysqld.exe, because on 32bit Windows, this rounding would result in a server that cannot start
            elenst Elena Stepanova made changes -
            Fix Version/s 10.2 [ 14601 ]
            Assignee Marko Mäkelä [ marko ]
            wlad Vladislav Vaintroub made changes -
            Labels 10.2-ga
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.6 [ 158 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked lower
            ratzpo Rasmus Johansson (Inactive) made changes -
            Sprint 10.2.6 [ 158 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Rank Ranked higher
            marko Marko Mäkelä made changes -
            Labels 10.2-ga
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            wlad Vladislav Vaintroub made changes -
            Assignee Marko Mäkelä [ marko ] Vladislav Vaintroub [ wlad ]
            wlad Vladislav Vaintroub made changes -
            Fix Version/s 10.2.7 [ 22543 ]
            Fix Version/s 10.2 [ 14601 ]
            Resolution Fixed [ 1 ]
            Status Open [ 1 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 79698 ] MariaDB v4 [ 151728 ]

            People

              wlad Vladislav Vaintroub
              wlad Vladislav Vaintroub
              Votes:
              0 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.