I am not able to figure out what is the good load average (which is not an alaram) for my data base server.
Can you please help me to find out it.
lscpu gives me this
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
On-line CPU(s) list: 0-31
Thread(s) per core: 2
Core(s) per socket: 8
CPU socket(s): 2
NUMA node(s): 2
Vendor ID: GenuineIntel
CPU family: 6
CPU MHz: 1064.000
L1d cache: 32K
L1i cache: 32K
L2 cache: 256K
L3 cache: 18432K
NUMA node0 CPU(s): 0-7,16-23
NUMA node1 CPU(s): 8-15,24-31
and cat /proc/cpuinfo I will attach
Based on this Link http://www.golinuxhub.com/2014/06/understanding-load-average-in-linux-and.html
less /proc/cpuinfo | grep "physical id" | sort|uniq | wc -l gives me 2
and less /proc/cpuinfo | grep "core id" | sort|uniq | wc -l gives me 8
so I calculated 2*8 =16 is 100% load and any thing above this is alaram.
Also could you please tell me what is from cpu info
physical id : 0
siblings : 16
core id : 0
cpu cores : 8
how it is architected ? Also what is processor,cores and cpu ? also how hyperthreading is acrhitected . How does it help us ?
My manager says if your system is 32 processor one and cores are 8 then it It is a machine of 32*8=256 cores
So you will have 256 processors and load average < 256 is perfectly fine.