From: Josh Cheek Date: 2010-05-15T07:25:33+09:00 Subject: Re: Memory leak in Rails apps --0016364c7eaf496ad00486955a66 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable On Fri, May 14, 2010 at 10:19 AM, Manivannanj Jeganathan < jmanivannancse@gmail.com> wrote: > We have developed rails reports and deployed in server, report have some > hierarchy levels..... > > Initially we have less volume of data in database table and report is > running with fine performance... > > after few months,reports get very slower, we thought that this could be > because of data increased in database table ( nearly 11 lakhs of records > in table)..... > > Then i created index and report has shown better performance than > old.... > > after 1 year, again reports are showing poor performance..... > So we have decided to monitor memory related issues and used 'top' and > 'free' commands to monitor memory.... > > as per our analysis, > > 1) at start, used memory was 100MB and free memory was 500MB. > > 2) When i continuously used complex report(i visit some hierarchy level > or sub links) ,at first level shows good performance...then i move > forward to next and next level reports the performance get very poor. > > 3) The free memory was reduced to 150MB...used memory was increased to > 400MB..... > > 4) the free memory is not released even after the report shows result... > > So we suggest to release used memory by forcing garbage collection > manually..... > > Kindly tell me how to call garbage collection manually or any other > ideas are also welcome.... > > Thanks.... > -- > Posted via http://www.ruby-forum.com/. > > One of the talks at Ruby Midwest is going to be on Memprof. Here's it's abstract: ----- Memprof: the ruby level memory profiler Aman Gupta & Joe Damato =96 Ever wondered why your ruby script uses so much RAM? Tired of having god restart your rails app every few hours? This talk will introduce memprof, a ruby level memory profiler. We'll demo memprof on a variety of real-world examples, including some popular open source projects. Along the way, we'll learn how the ruby VM manages memory, why garbage collection has such a large impact on ruby's performance and some common ways to reduce the memory impact of your ruby applications. ----- Even if you can't attend the conference, you might check out Memprof anyway= , it sounds as though it might help you identify the cause of your issues so that you can fix the source of the problem. Note: I haven't personally played with it (yet). --0016364c7eaf496ad00486955a66--