Results 1 to 5 of 5
-
12-13-2006, 06:44 PM #1WHT Addict
- Join Date
- Aug 2002
- Location
- Canada!
- Posts
- 161
mysqld died and hit privvmpages barrier
Code:uid resource held maxheld barrier limit failcnt 2400: kmemsize 3613685 15989987 68157440 68157440 0 lockedpages 0 0 32 32 0 privvmpages 44933 131365 131072 131072 4632 shmpages 2081 2737 8192 8192 0 dummy 0 0 0 0 0 numproc 50 233 2560 2560 0 physpages 10524 39869 0 2147483647 0 vmguarpages 0 0 65536 2147483647 0 oomguarpages 10524 39871 6144 2147483647 0 numtcpsock 15 144 20480 20480 0 numflock 1 6 2560 2560 0 numpty 1 2 16 16 0 numsiginfo 0 113 2560 2560 0 tcpsndbuf 163228 425720 8388608 16777216 0 tcprcvbuf 196608 577036 8388608 16777216 0 othersockbuf 17888 1184892 8388608 16777216 0 dgramrcvbuf 0 8380 8388608 16777216 0 numothersock 14 236 20480 20480 0 dcachesize 0 0 15728640 15728640 0 numfile 1147 2511 40960 40960 0 dummy 0 0 0 0 0 dummy 0 0 0 0 0 dummy 0 0 0 0 0 numiptent 93 93 128 128 0
Code:[Thu Dec 14 00:10:04 2006] [notice] SIGHUP received. Attempting to restart [Thu Dec 14 00:10:17 2006] [notice] Apache configured -- resuming normal operations [Thu Dec 14 00:10:17 2006] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec) [Thu Dec 14 00:10:17 2006] [notice] Accept mutex: sysvsem (Default: sysvsem) [Thu Dec 14 00:10:26 2006] [error] (12)Cannot allocate memory: fork: Unable to fork new process [Thu Dec 14 00:10:37 2006] [error] (12)Cannot allocate memory: fork: Unable to fork new process [Thu Dec 14 00:10:47 2006] [error] (12)Cannot allocate memory: fork: Unable to fork new process [Thu Dec 14 00:10:57 2006] [error] (12)Cannot allocate memory: fork: Unable to fork new process [Thu Dec 14 00:11:07 2006] [error] (12)Cannot allocate memory: fork: Unable to fork new process [Thu Dec 14 00:11:17 2006] [error] (12)Cannot allocate memory: fork: Unable to fork new process [Thu Dec 14 00:11:27 2006] [error] (12)Cannot allocate memory: fork: Unable to fork new process [Thu Dec 14 00:11:37 2006] [error] (12)Cannot allocate memory: fork: Unable to fork new process [Thu Dec 14 00:11:47 2006] [error] (12)Cannot allocate memory: fork: Unable to fork new process
I was very surprised to see the: "privvmpages 44933 131365 131072 131072 4632"
4632 fail counts!? How do I prevent my VPS from hitting the barrier and how do add a cron to restart MySqld if it's down?
Thanks.
-
12-13-2006, 07:23 PM #2Web Hosting Master
- Join Date
- Mar 2005
- Location
- Labrador, Canada
- Posts
- 988
Originally Posted by Ogg
To prevent your VPS from hitting the barrier you can:
- Configure services to use less RAM, possibly at the expense of performance;
- Upgrade your VPS.
To add a cronjob, edit root's crontab:
[root@vps] crontab -e
There are many references on the web outlining the syntax of what you need to enter there, also you can read the man page -- "man crontab" at the prompt.
-
12-13-2006, 07:30 PM #3WHT Addict
- Join Date
- Aug 2002
- Location
- Canada!
- Posts
- 161
It's not at VPSLINK (at least to my knowledge).
- Configure services to use less RAM, possibly at the expense of performance
- Upgrade your VPS.
-
12-13-2006, 08:01 PM #4Web Hosting Master
- Join Date
- Mar 2005
- Location
- Labrador, Canada
- Posts
- 988
Originally Posted by Ogg
Which services would you suggest? I've already limited apache to 150 connections, maybe that's too high? I've tried to optimize MySQL to the best of my ability as well. Hm.
-
12-13-2006, 08:03 PM #5WHT Addict
- Join Date
- Aug 2002
- Location
- Canada!
- Posts
- 161
Yes, I read through the guide on WHT. I based my optimizations on what I read there but it looks like I might be getting more traffic than my settings can handle.