Breaking News: Grepper is joining You.com. Read the official announcement!

Calculate innodb_buffer_pool_size

Jason M Potter answered on October 15, 2022 Popularity 8/10 Helpfulness 3/10

answer Calculate innodb_buffer_pool_size

Calculate innodb_buffer_pool_size

Comment

## Calculate innodb_buffer_pool_size for dedicated database servers
awk '/MemTotal/{$3="GB"; $2=sprintf("%.0f",$2/1048576); print; $1="  Mem80%:"; $2=sprintf("%.0f",$2*.8); print}' /proc/meminfo
## Example Output:
MemTotal: 15 GB
Mem80%: 12 GB

## Calculate innodb_buffer_pool_size for shared servers
awk '/MemAvail/{$3="G";_=$2;$2=sprintf("% 3.0f",_/1048576);print; for (i=80;i>=25;i-=10) {$1="MemAvail_"i"%:";$2=sprintf("% 3.0f",_*(i/100)/1048576);$4=sprintf("| %.0f M",_*(i/100)/1024); print; } }' /proc/meminfo
## Example Output:
MemAvailable:  25 G
MemAvail_80%:  20 G | 20087 M
MemAvail_70%:  17 G | 17576 M
MemAvail_60%:  15 G | 15065 M
MemAvail_50%:  12 G | 12554 M
MemAvail_40%:  10 G | 10043 M
MemAvail_30%:   7 G | 7533 M

Popularity 8/10 Helpfulness 3/10 Language shell

Source: www.liquidweb.com

Tags: buffer calc figure innodb out shell size

Link to this answer
Share Copy Link