Hello!
We have one VE that have inside MySQL Server, this VPS is running a
mysql query that load very high all the server node and affecting others
VE's. How can I limit this VPS to avoid the high load caused by the
MySQL query.
Its the /proc/user_beancounters of the VE.
[root at servidor /]# cat /proc/user_beancounters
Version: 2.5
uid resource held
maxheld barrier limit failcnt
161: kmemsize 13171691
24077722 121151535 121151535 0
lockedpages 0
0 256 256 0
privvmpages 69201
213419 262144 270100 0
shmpages 162
1506 21504 21504 0
dummy 0
0 0 0 0
numproc 79
132 240 240 0
physpages 22768
157709 0 2147483647 0
vmguarpages 0
0 52428800 52428800 0
oomguarpages 22769
157710 26112 2147483647 0
numtcpsock 17
59 3600 3600 0
numflock 4
43 188 206 0
numpty 2
2 16 16 0
numsiginfo 0
9 256 256 0
tcpsndbuf 192192
913456 1720320 2703360 0
tcprcvbuf 278528
787520 27033600 27033600 0
othersockbuf 324800
612208 1126080 2097152 0
dgramrcvbuf 0
28512 262144 262144 0
numothersock 144
184 360 360 0
dcachesize 0
0 3409920 3624960 0
numfile 2087
3466 9312 9312 0
dummy 0
0 0 0 0
dummy 0
0 0 0 0
dummy 0
0 0 0 0
numiptent 14
14 128 128 0
[root at servidor /]#
Thank you!
--
Jose David Bravo Álvarez
ColombiaHosting E.U.
Línea Gratuita Nacional: 01 8000 120 190
PBX Bogotá: (1) 6683173 ext. 120
PBX Cali: (2) 4854089 ext. 120
http://www.colombiahosting.com.co