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.

[r...@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
[r...@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

_______________________________________________
Users mailing list
Users@openvz.org
https://openvz.org/mailman/listinfo/users

Reply via email to