[CentOS] x86_64 server OOM problems after update to 5.3

2009-04-13 Thread Rick Barnes
Hello, Over the weekend, I upgraded one of my servers that runs mysql and pdns to 5.3. Previous to the update I have not had an issue form this server. But since, I have had mysql die multiple times from oom-killer. $ uname -a Linux rack2a 2.6.18-128.1.6.el5 #1 SMP Wed Apr 1 09:10:25 EDT 2009

Re: [CentOS] x86_64 server OOM problems after update to 5.3

2009-04-13 Thread nate
Rick Barnes wrote: How do I determine what process is/was chewing up the memory on this server? What should I be looking for to narrow this down? Setup a script to monitor memory usage and alert you when swap usage starts getting high. Or setup a monitor that just runs ps auxw or something and

Re: [CentOS] x86_64 server OOM problems after update to 5.3

2009-04-13 Thread JohnS
On Mon, 2009-04-13 at 10:31 -0400, Rick Barnes wrote: Hello, Over the weekend, I upgraded one of my servers that runs mysql and pdns to 5.3. Previous to the update I have not had an issue form this server. But since, I have had mysql die multiple times from oom-killer. $ uname -a Linux

Re: [CentOS] x86_64 server OOM problems after update to 5.3

2009-04-13 Thread JohnS
On Mon, 2009-04-13 at 10:31 -0400, Rick Barnes wrote: Hello, I have had mysql die multiple times from oom-killer. Thanks, Rick --- In seeing what you do I would be looking at the queries being made. SPROCs, Triggers, Views. Also very import is if that one particular data base is doing

Re: [CentOS] x86_64 server OOM problems after update to 5.3

2009-04-13 Thread Rick Barnes
JohnS wrote: On Mon, 2009-04-13 at 10:31 -0400, Rick Barnes wrote: Hello, I have had mysql die multiple times from oom-killer. Thanks, Rick --- In seeing what you do I would be looking at the queries being made. SPROCs, Triggers, Views. Also very import is if that one particular data

Re: [CentOS] x86_64 server OOM problems after update to 5.3

2009-04-13 Thread Rick Barnes
JohnS wrote: Seeing as you said you upgraded from 5.2 - 5.3 I would be looking at the kernel release notes and the mysql release notes for known problems since you did not have prior problems. I would check out the Cacti and DNS Databases because there more realtime in nature to running on

Re: [CentOS] x86_64 server OOM problems after update to 5.3

2009-04-13 Thread JohnS
On Mon, 2009-04-13 at 15:25 -0400, Rick Barnes wrote: JohnS wrote: Seeing as you said you upgraded from 5.2 - 5.3 I would be looking at the kernel release notes and the mysql release notes for known problems since you did not have prior problems. I would check out the Cacti and DNS

Re: [CentOS] x86_64 server OOM problems after update to 5.3

2009-04-13 Thread JohnS
On Mon, 2009-04-13 at 14:18 -0400, Rick Barnes wrote: This is a real hardware server. It is not doing GIS or mapping of the like, most of the DBs on this are for web sites, mostly form data storage, some CMS DBs for joomla, WP, etc. also some others for cacti and powerdns backends. I