Does the FreeBSD 13.2 system support MYSQL to enable large page support?

A

Alucn

sysctl hw.pagesize
4096
Click to expand...
large-pages=ON Add to the dede file and restart MYSQL, the log display is normal.
Do you need any other settings? How to verify that it is working properly?
Thank you all!
 
cracauer@ said:
`procstat vm $$`

under FLAGS, if there is "S" then the mapping is superpages.
Click to expand...
Hello, is this the data？
root@freebsd:~ # procstat vm $$
PID START END PRT RES PRES REF SHD FLAG TP PATH
2037 0x7c1480660000 0x7c1480678000 r-- 24 112 10 6 CN--- vn /bin/csh
2037 0x7c1480687000 0x7c14806d3000 r-x 76 112 10 6 CN--- vn /bin/csh
2037 0x7c14806e2000 0x7c14806e4000 r-- 2 0 1 0 CN--- vn /bin/csh
2037 0x7c14806e4000 0x7c14806e5000 rw- 1 0 1 0 CN--- vn /bin/csh
2037 0x7c14806f4000 0x7c14806f7000 rw- 3 0 1 0 CN--- vn /bin/csh
2037 0x7c14806f7000 0x7c148071e000 rw- 9 9 1 0 C---- df
2037 0x7c14c09b2000 0x7c1500992000 --- 0 0 0 0 ----- gd
2037 0x7c1500992000 0x7c15009b2000 rw- 8 8 1 0 C--D- df
2037 0x7c15015d6000 0x7c15015f3000 rw- 26 26 1 0 CN--- df
2037 0x7c15024e9000 0x7c15024ed000 r-- 4 12 24 12 CN--- vn /lib/libcrypt.so.5
2037 0x7c15024ed000 0x7c15024fc000 --- 0 0 0 0 CN--- gd
2037 0x7c15024fc000 0x7c1502504000 r-x 8 12 24 12 CN--- vn /lib/libcrypt.so.5
2037 0x7c1502504000 0x7c1502513000 --- 0 0 0 0 CN--- gd
2037 0x7c1502513000 0x7c1502514000 rw- 1 0 1 0 CN--- vn /lib/libcrypt.so.5
2037 0x7c1502514000 0x7c1502523000 --- 0 0 0 0 CN--- gd
2037 0x7c1502523000 0x7c1502525000 rw- 2 0 1 0 CN--- vn /lib/libcrypt.so.5
2037 0x7c1502525000 0x7c1502536000 rw- 0 0 0 0 ----- --
2037 0x7c1502e31000 0x7c1502e5e000 r-- 45 96 15 9 CN--- vn /lib/libncursesw.so.9
2037 0x7c1502e5e000 0x7c1502e6d000 --- 0 0 0 0 CN--- gd
2037 0x7c1502e6d000 0x7c1502ea5000 r-x 40 96 15 9 CN--- vn /lib/libncursesw.so.9
2037 0x7c1502ea5000 0x7c1502eb4000 --- 0 0 0 0 CN--- gd
2037 0x7c1502eb4000 0x7c1502eb7000 r-- 3 0 1 0 CN--- vn /lib/libncursesw.so.9
2037 0x7c1502eb7000 0x7c1502eb8000 rw- 1 0 1 0 CN--- vn /lib/libncursesw.so.9
2037 0x7c1502eb8000 0x7c1502ec7000 --- 0 0 0 0 CN--- gd
2037 0x7c1502ec7000 0x7c1502ec9000 rw- 2 0 1 0 CN--- vn /lib/libncursesw.so.9
2037 0x7c1502ec9000 0x7c1502eca000 rw- 1 1 1 0 CN--- df
2037 0x7c15034b9000 0x7c15034e1000 rw- 3 3 1 0 C---- df
2037 0x7c1504218000 0x7c1504292000 r-- 82 376 65 35 CN--- vn /lib/libc.so.7
2037 0x7c1504292000 0x7c15042a1000 --- 0 0 0 0 CN--- gd
2037 0x7c15042a1000 0x7c15043d1000 r-x 272 376 65 35 CN--- vn /lib/libc.so.7
2037 0x7c15043d1000 0x7c15043e0000 --- 0 0 0 0 CN--- gd
2037 0x7c15043e0000 0x7c15043e9000 r-- 9 0 1 0 CN--- vn /lib/libc.so.7
2037 0x7c15043e9000 0x7c15043ea000 rw- 1 0 1 0 CN--- vn /lib/libc.so.7
2037 0x7c15043ea000 0x7c15043f9000 --- 0 0 0 0 CN--- gd
2037 0x7c15043f9000 0x7c1504400000 rw- 7 0 1 0 CN--- vn /lib/libc.so.7
2037 0x7c1504400000 0x7c1504622000 rw- 18 18 1 0 CN--- df
2037 0x7c1505000000 0x7c1505200000 rw- 12 12 1 0 CN--- df
2037 0x7c150614e000 0x7c150634e000 rw- 189 189 1 0 C---- df
2037 0x7c1506600000 0x7c1506a00000 rw- 3 3 1 0 CN--- df
2037 0x7c1507218000 0x7c1507219000 r-- 1 2 8 4 CN--- vn /usr/lib/i18n/libUTF8.so.4
2037 0x7c1507219000 0x7c1507228000 --- 0 0 0 0 CN--- gd
2037 0x7c1507228000 0x7c150722a000 r-x 2 2 8 4 CN--- vn /usr/lib/i18n/libUTF8.so.4
2037 0x7c150722a000 0x7c1507239000 --- 0 0 0 0 CN--- gd
2037 0x7c1507239000 0x7c150723a000 rw- 1 0 1 0 CN--- vn /usr/lib/i18n/libUTF8.so.4
2037 0x7c150723a000 0x7c1507249000 --- 0 0 0 0 CN--- gd
2037 0x7c1507249000 0x7c150724a000 rw- 1 0 1 0 CN--- vn /usr/lib/i18n/libUTF8.so.4
2037 0x7c1507b30000 0x7c1507b31000 r-- 1 3 8 4 CN--- vn /usr/lib/i18n/libiconv_std.so.4
2037 0x7c1507b31000 0x7c1507b40000 --- 0 0 0 0 CN--- gd
2037 0x7c1507b40000 0x7c1507b42000 r-x 2 3 8 4 CN--- vn /usr/lib/i18n/libiconv_std.so.4
2037 0x7c1507b42000 0x7c1507b51000 --- 0 0 0 0 CN--- gd
2037 0x7c1507b51000 0x7c1507b52000 rw- 1 0 1 0 CN--- vn /usr/lib/i18n/libiconv_std.so.4
2037 0x7c1507b52000 0x7c1507b61000 --- 0 0 0 0 CN--- gd
2037 0x7c1507b61000 0x7c1507b62000 rw- 1 0 1 0 CN--- vn /usr/lib/i18n/libiconv_std.so.4
2037 0x7c1508278000 0x7c1508279000 r-- 1 2 8 4 CN--- vn /usr/lib/i18n/libmapper_none.so.4
2037 0x7c1508279000 0x7c1508288000 --- 0 0 0 0 CN--- gd
2037 0x7c1508288000 0x7c1508289000 r-x 1 2 8 4 CN--- vn /usr/lib/i18n/libmapper_none.so.4
2037 0x7c1508289000 0x7c1508298000 --- 0 0 0 0 CN--- gd
2037 0x7c1508298000 0x7c1508299000 rw- 1 0 1 0 CN--- vn /usr/lib/i18n/libmapper_none.so.4
2037 0x7c1508299000 0x7c15082a8000 --- 0 0 0 0 CN--- gd
2037 0x7c15082a8000 0x7c15082a9000 rw- 1 0 1 0 CN--- vn /usr/lib/i18n/libmapper_none.so.4
2037 0xb0fa5198f000 0xb0fa51996000 r-- 7 28 56 26 CN--- vn /libexec/ld-elf.so.1
2037 0xb0fa519a5000 0xb0fa519ba000 r-x 21 28 56 26 CN--- vn /libexec/ld-elf.so.1
2037 0xb0fa519c9000 0xb0fa519ca000 r-- 1 0 1 0 CN--- vn /libexec/ld-elf.so.1
2037 0xb0fa519d9000 0xb0fa519da000 rw- 1 0 1 0 CN--- vn /libexec/ld-elf.so.1
2037 0xb0fa519da000 0xb0fa519db000 rw- 1 1 1 0 CN--- df
2037 0xfffffffff000 0x1000000000000 r-x 1 1 18 0 ----- ph
Click to expand...
 
Here is some addition information :

Information for VM, file descriptor, and cpuset options is available only to the owner of a process or the superuser.
Click to expand...

To check to see if MySQL is using large page support :

Get the PID number for MySQL
Code: 
$ top
PID USERNAME    THR PRI NICE   SIZE    RES STATE    C   TIME    WCPU COMMAND
54316 mysql        44  20    0   799M   347M select  15   3:52   1.64% mysqld

As superuser, use procstat and check for S under FLAG
Code: 
$ sudo procstat vm pid 54316
PID              START                END PRT  RES PRES REF SHD FLAG  TP PATH
54316      0x200000             0x1d3c000 r-- 6972 14602   4   2 CNS-- vn /usr/local/libexec/mysqld
 
You must log in or register to reply here.
Back
Top