Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-5517

4GB Limit on large_pages shared memory set-up

    Details

      Description

      Large pages allocations with innodb buffer pool chunk 4GB and more causing incorrect size for memory segment.

      --large-pages --innodb_buffer_pool_chunk_size=4G

      I've started mysqld as root, but it's also possible to see the same issue with proper value for /proc/sys/vm/hugetlb_shm_group:

      https://dev.mysql.com/doc/refman/8.0/en/large-page-support.html

       
      sync; echo 3 > /proc/sys/vm/drop_caches
      echo 5120 > /proc/sys/vm/nr_hugepages # 10GB
      ulimit -l unlimited
      bin/mysqld --no-defaults --user=root --datadir=$PWD/data --lc-messages-dir=$PWD/share/english --initialize-insecure --skip-networking
      bin/mysqld --no-defaults --user=root --datadir=$PWD/data --lc-messages-dir=$PWD/share/english --socket=$PWD/data/mysqld.sock --skip-networking --innodb_buffer_pool_instances=2 --large-pages --innodb_buffer_pool_chunk_size=4G --innodb_buffer_pool_size=8G
      ipcs -m

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  zsolt.parragi Zsolt Parragi
                  Reporter:
                  nickolay.ihalainen Nickolay Ihalainen
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - Not Specified
                    Not Specified
                    Logged:
                    Time Spent - 4 hours, 22 minutes
                    4h 22m