<div> <font face="Arial, Helvetica, sans-serif">Switching to NGINX indeed fixed much of the problems. But mysql gem continues to evade no matter what kind of config I use. <br>
But SQL has been tuned up, major bugs have been tuned.<br>
<br>
Much better now. Will post later with detailed analysis of the problem and solutions<br>
<br>
regards<br>
<br>
Mohammed. A<br>
</font></div>
<div> <br>
</div>
<div> <br>
</div>
-----Original Message-----<br>
From: Piyush Ranjan <piyush.pr@gmail.com><br>
To: mongrel-users@rubyforge.org<br>
Sent: Wed, 27 Feb 2008 1:50 pm<br>
Subject: Re: [Mongrel] problems with Mongrel + Pound<br>
<br>
<div id="AOLMsgPart_3_88fbf087-2c5e-4099-b7e1-c27b66bad634">
To install mysql gem you need to specify the mysql_config path(if it is not installed then into mysql dev or devel package)<br>
To install sudo gem install mysql -- --with-mysql-config=<path-to-mysql_config like on my ubuntu it is /usr/bin/mysql_config><br>
<br>
<br>
And your problems are similar(not same) I used to encounter. I had these problems with my mongrel handler when it used to write to database in asynchronous queries by the users. Log file used to scream connection lost to mysql. After spending a few days trying to boost up my mysql server I did the gem install and since then it has handled 100K + queries (the mongrel handler part of the app)each day without any problem whatsoever. <br>
<br>
Also switch to apache/ngnix if you can. Pound could also be the trouble maker though I am not very sure about this comment.<br>
<br>
<div class="gmail_quote">On Wed, Feb 27, 2008 at 1:29 PM, Dave Cheney <<a href="mailto:dave@cheney.net">dave@cheney.net</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div style="">I hacked our vendor tree to explode on startup if the mysql gem could not be found. IMHO this should be the default behavior, the built in mysql adapter is crap and its silent use is a ticking time bomb
<div>
<br>
</div>
<div>Cheers</div>
<div><br>
</div>
<font color="#888888">
<div>Dave</div>
</font>
<div class="Ih2E3d">
<div><br>
</div>
<div>
<div>
<div>On 27/02/2008, at 6:42 PM, <a href="mailto:mohammed.a@aol.in">mohammed.a@aol.in</a> wrote:</div>
<br>
<blockquote type="cite"><span style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Arial; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;">Thank you for the replies.<br>
<br>
Here's what I found - mysql gem was not installed and that maybe a core source of problems as suggested by Zed. We've had too many problems when we tried to install this, and found that none of the solutions that are mentioned really work. We will try to install this gem again.<span> </span></span></blockquote>
</div>
<br>
</div>
</div>
</div>
<br>
_______________________________________________<br>
Mongrel-users mailing list<br>
<a href="mailto:Mongrel-users@rubyforge.org">Mongrel-users@rubyforge.org</a><br>
<a target="_blank" href="http://rubyforge.org/mailman/listinfo/mongrel-users">http://rubyforge.org/mailman/listinfo/mongrel-users</a><br>
</blockquote></div>
<br>
</div>
<!-- end of AOLMsgPart_3_88fbf087-2c5e-4099-b7e1-c27b66bad634 -->
<div id="AOLMsgPart_4_88fbf087-2c5e-4099-b7e1-c27b66bad634" style="margin: 0px; font-family: Tahoma,Verdana,Arial,Sans-Serif; font-size: 12px; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);">
<pre style="font-size: 9pt;"><tt>_______________________________________________<br>
Mongrel-users mailing list<br>
<a href="mailto:Mongrel-users@rubyforge.org">Mongrel-users@rubyforge.org</a><br>
<a href="http://rubyforge.org/mailman/listinfo/mongrel-users" target="_blank">http://rubyforge.org/mailman/listinfo/mongrel-users</a>
</tt></pre>
</div>
<!-- end of AOLMsgPart_4_88fbf087-2c5e-4099-b7e1-c27b66bad634 -->
<div class="AOLPromoFooter">
<hr style="margin-top:10px;" />
You are invited to Get a Free AOL Email ID. <a href="http://webmail.aol.in" target="_blank">Click here.</a><br />
</div>