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

4GB Limit on large_pages shared memory set-up

    XMLWordPrintable

    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

        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

                    Smart Checklist