Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.2.12
-
None
-
Centos 7
-
10.4.0-1
Description
I set the memory for my engine to 34GB
show variables like 'rocks%block%'
|
-> ;
|
+-------------------------------------------------+-------------+
|
| Variable_name | Value |
|
+-------------------------------------------------+-------------+
|
| rocksdb_block_cache_size | 36507222016 |
|
and memlock=1 in /etc/my.cnf
but it locks only 10GB
|
cat /proc/$( pgrep -o mysql )/status | grep VmLck
|
VmLck: 10354096 kB
|
My limits are fine:
|
cat /proc/$( pgrep -o mysql )/limits
|
Limit Soft Limit Hard Limit Units
|
Max cpu time unlimited unlimited seconds
|
Max file size unlimited unlimited bytes
|
Max data size unlimited unlimited bytes
|
Max stack size 8388608 unlimited bytes
|
Max core file size 0 unlimited bytes
|
Max resident set unlimited unlimited bytes
|
Max processes 543577 543577 processes
|
Max open files 10000 10000 files
|
Max locked memory unlimited unlimited bytes
|
Max address space unlimited unlimited bytes
|
Max file locks unlimited unlimited locks
|
Max pending signals 543577 543577 signals
|
Max msgqueue size 819200 819200 bytes
|
Max nice priority 0 0
|
Max realtime priority 0 0
|
Max realtime timeout unlimited unlimited us
|
The box has plenty of free memory
free -g
|
total used free shared buff/cache available
|
Mem: 132 65 18 2 48 54
|
How do I make sure that mariadb locks all memory so it ever gets paged out or killed by the OOM?