Agreed on 5.5. Debating Pecona. I did attach the cnf. I played with the settings using the tuner and modified them accordingly. Also tried percona&#39;s config tool output. When adding all the variables simultaneously, mysql didn&#39;t restart. So I added them one at a time. This worked better but was a slow process. There has to be a better way?<div>

<div><br><div class="gmail_quote">On Fri, Oct 12, 2012 at 4:08 PM, Eric Cope <span dir="ltr">&lt;<a href="mailto:eric.cope@gmail.com" target="_blank">eric.cope@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">


<div bgcolor="#FFFFFF"><div>Upgrading to 5.5 will help, as well has going to Percona. Did you post your my.cnf file? Did you modify it from what I sent?</div><div><br></div><div>Eric</div><div><div><div><br>On Oct 12, 2012, at 4:06 PM, Vimal Shah &lt;<a href="mailto:vimals@sokikom.com" target="_blank">vimals@sokikom.com</a>&gt; wrote:<br>


<br></div><div></div><blockquote type="cite"><div>Though I attached this as well.. hopefully I took out the important things..<br><br><div class="gmail_quote">On Fri, Oct 12, 2012 at 3:59 PM, Vimal Shah <span dir="ltr">&lt;<a href="mailto:vimals@sokikom.com" target="_blank">vimals@sokikom.com</a>&gt;</span> wrote:<br>




<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>How can I tell this? I ran the following:</div><div><br></div><div># <font face="courier new, monospace">echo &#39;\s&#39; | mysql</font>  </div>




<div>--------------</div><div>mysql  Ver 14.14 Distrib 5.1.63, for debian-linux-gnu (x86_64) using readline 6.1</div>
<div><br></div><div>Connection id:          XX</div><div>Current database:</div><div>Current user:           XX</div><div>SSL:                    Not in use</div><div>Current pager:          stdout</div><div>Using outfile:          &#39;&#39;</div>





<div>Using delimiter:        ;</div><div>Server version:         5.1.63-0ubuntu0.10.04.1-log (Ubuntu)</div><div>Protocol version:       10</div><div>Connection:             Localhost via UNIX socket</div><div>Server characterset:    latin1</div>





<div>Db     characterset:    latin1</div><div>Client characterset:    latin1</div><div>Conn.  characterset:    latin1</div><div>UNIX socket:            XXX</div><div>Uptime:                 1 hour 12 min 18 sec</div><div>





<br></div><div>Threads: 1  Questions: 200  Slow queries: 14  Opens: 615  Flush tables: 1  Open tables: 152  Queries per second avg: 0.46</div><div><div><div><br></div><br><div class="gmail_quote">

On Fri, Oct 12, 2012 at 3:53 PM, Jeff Wolkove <span dir="ltr">&lt;<a href="mailto:wolkove@biz-link.com" target="_blank">wolkove@biz-link.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Can&#39;t tell much from that. Sure it&#39;s a 64 bit build?<span><font color="#888888"><br><br>Jeff Wolkove<br>
<br></font></span><div><div>----- Reply message -----<br>From: &quot;Vimal Shah&quot; &lt;<a href="mailto:vimals@sokikom.com" target="_blank">vimals@sokikom.com</a>&gt;<br>To: &lt;<a href="mailto:azphp@list.azphp.org" target="_blank">azphp@list.azphp.org</a>&gt;<br>





</div><div>Cc: &quot;Main PLUG discussion list&quot; &lt;<a href="mailto:plug-discuss@lists.plug.phoenix.az.us" target="_blank">plug-discuss@lists.plug.phoenix.az.us</a>&gt;<br>Subject: [AzPHP] Tuning MySQL DB server<br>





</div><div><div>Date: Fri, Oct 12, 2012 3:49 pm<br><br></div></div></div><div><div><br>Server version: 5.1.63-0ubuntu0.10.04.1-log (Ubuntu)<div><br><div class="gmail_quote">On Fri, Oct 12, 2012 at 3:22 PM, Jeff Wolkove <span dir="ltr">&lt;<a href="mailto:wolkove@biz-link.com" target="_blank">wolkove@biz-link.com</a>&gt;</span> wrote:<br>








<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">What build &amp; version of mySQL are you running now? How much memory is set aside for cache, etc? It may help to post your my.cnf (edited for privacy)<br>








<br>Jeff Wolkove<div><br><br><div>----- Reply message -----<br>From: &quot;Vimal Shah&quot; &lt;<a href="mailto:vimals@sokikom.com" target="_blank">vimals@sokikom.com</a>&gt;<br>To: &lt;<a href="mailto:azphp@list.azphp.org" target="_blank">azphp@list.azphp.org</a>&gt;, &quot;	Main PLUG discussion list&quot; &lt;<a href="mailto:plug-discuss@lists.plug.phoenix.az.us" target="_blank">plug-discuss@lists.plug.phoenix.az.us</a>&gt;<br>








Subject: [AzPHP] Tuning MySQL DB server<br>Date: Fri, Oct 12, 2012 1:44 pm<br><br></div><br>Hello all,<div><br></div><div>I recently had many teachers and students logging into my site, this is a good thing. The server infrastructure (Linode VPS = 1 load balancer =&gt; 2 webservers and 1 database (DB) server) started to show CPUs that were railing at peaks times on the Munin graphs. This was not so good. The bandaid (which I need to fix) was to add more servers, I now have 5 webservers each have 2GB of RAM and have 2.2.7 GHz CPU (4 of them on each box). This has to be overkill..  Later, realized that MySQL&#39;s system variables were not optimized for the DB server. Ran <a href="https://tools.percona.com/" target="_blank">Percona&#39;s configuration tool</a> along with the <a href="https://github.com/rackerhacker/MySQLTuner-perl" target="_blank">mysqltunner perl script</a>.  This led to the discovery that 32-bit version of Ubuntu will not allow MySQL to use any more that 2G
 B.</div>







<div><br></div></div><div>NEW DB server = After upgrading the DB server to 8GB and along with going to 64-bit Ubuntu 10.04, I am <b>still unable to get to the box to use all the memory</b>. The process I&#39;ve been using is (1) use apache bench or jmeter to fling large connections (and long queries) at the DB server (2) run the tuner script to see it&#39;s recommendations to the system variables (2) update the variables, restart mysql and start over..</div>








<div><div>

<div><br></div><div>This has led to unsatisfactory results. I know that fixing the slow queries (which is in process) is a place to start, but I feel that the DB server should be using more RAM. Can someone point out the flaws in my process or maybe even suggest a better way to do this?</div>










<div><br></div><div>Thank you very much for you time.</div><div><br></div><div>First day DBA,</div><div>-Vimal<br><div></div><br>
</div><div>PS Thanks Eric C., for starting me down the right direction.</div>

</div></div><br>_______________________________________________<br>
azPHP mailing list<br>
<a href="mailto:azPHP@list.azphp.org" target="_blank">azPHP@list.azphp.org</a><br>
<a href="http://list.azphp.org/mailman/listinfo/azphp_list.azphp.org" target="_blank">http://list.azphp.org/mailman/listinfo/azphp_list.azphp.org</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><font size="3"><div style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px"><font face="arial, helvetica, sans-serif">Vimal (rhymes with Kimmel) Shah</font></div>








<div style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px"><span style="font-family:arial,helvetica,sans-serif;font-size:13px">VP of Engineering</span></div><span style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px"><font face="arial, helvetica, sans-serif">Sokikom<br>








Mobile: <a href="tel:%28480%29%20752-9269" value="+14807529269" target="_blank">(480) 752-9269</a><br>Email:<font color="#500050">   </font><a href="mailto:vimals@sokikom.com" style="color:rgb(42,93,176)" target="_blank">vimals@sokikom.com</a></font></span><div style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px">








<font face="arial, helvetica, sans-serif">Web:<font color="#500050">    </font><font color="#3333FF" style="color:rgb(42,93,176)"><a href="http://www.sokikom.com/" style="color:rgb(42,93,176)" target="_blank">www.sokikom.com</a></font></font></div>








<div><font face="arial, helvetica, sans-serif"><br></font></div></font><div><div style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px">Follow us: <a href="http://www.twitter.com/sokikom" style="color:rgb(42,93,176)" target="_blank">twitter.com/sokikom</a></div>








<div style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px">Like us: <a href="http://www.facebook.com/sokikom" style="color:rgb(42,93,176)" target="_blank">facebook.com/sokikom</a></div></div><br>
</div>

</div></div><br>_______________________________________________<br>
azPHP mailing list<br>
<a href="mailto:azPHP@list.azphp.org" target="_blank">azPHP@list.azphp.org</a><br>
<a href="http://list.azphp.org/mailman/listinfo/azphp_list.azphp.org" target="_blank">http://list.azphp.org/mailman/listinfo/azphp_list.azphp.org</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><font size="3"><div style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px"><font face="arial, helvetica, sans-serif">Vimal (rhymes with Kimmel) Shah</font></div>





<div style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px"><span style="font-family:arial,helvetica,sans-serif;font-size:13px">VP of Engineering</span></div><span style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px"><font face="arial, helvetica, sans-serif">Sokikom<br>





Mobile: <a href="tel:%28480%29%20752-9269" value="+14807529269" target="_blank">(480) 752-9269</a><br>Email:<font color="#500050">   </font><a href="mailto:vimals@sokikom.com" style="color:rgb(42,93,176)" target="_blank">vimals@sokikom.com</a></font></span><div style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px">





<font face="arial, helvetica, sans-serif">Web:<font color="#500050">    </font><font color="#3333FF" style="color:rgb(42,93,176)"><a href="http://www.sokikom.com/" style="color:rgb(42,93,176)" target="_blank">www.sokikom.com</a></font></font></div>





<div><font face="arial, helvetica, sans-serif"><br></font></div></font><div><div style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px">Follow us: <a href="http://www.twitter.com/sokikom" style="color:rgb(42,93,176)" target="_blank">twitter.com/sokikom</a></div>





<div style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px">Like us: <a href="http://www.facebook.com/sokikom" style="color:rgb(42,93,176)" target="_blank">facebook.com/sokikom</a></div></div><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><font size="3"><div style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px"><font face="arial, helvetica, sans-serif">Vimal (rhymes with Kimmel) Shah</font></div>




<div style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px"><span style="font-family:arial,helvetica,sans-serif;font-size:13px">VP of Engineering</span></div><span style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px"><font face="arial, helvetica, sans-serif">Sokikom<br>




Mobile: <a href="tel:%28480%29%20752-9269" value="+14807529269" target="_blank">(480) 752-9269</a><br>Email:<font color="#500050">   </font><a href="mailto:vimals@sokikom.com" style="color:rgb(42,93,176)" target="_blank">vimals@sokikom.com</a></font></span><div style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px">




<font face="arial, helvetica, sans-serif">Web:<font color="#500050">    </font><font color="#3333FF" style="color:rgb(42,93,176)"><a href="http://www.sokikom.com/" style="color:rgb(42,93,176)" target="_blank">www.sokikom.com</a></font></font></div>




<div><font face="arial, helvetica, sans-serif"><br></font></div></font><div><div style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px">Follow us: <a href="http://www.twitter.com/sokikom" style="color:rgb(42,93,176)" target="_blank">twitter.com/sokikom</a></div>




<div style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px">Like us: <a href="http://www.facebook.com/sokikom" style="color:rgb(42,93,176)" target="_blank">facebook.com/sokikom</a></div></div><br>
</div></blockquote></div></div><blockquote type="cite"><div>&lt;my.cnf&gt;</div></blockquote><div><blockquote type="cite"><div><span>---------------------------------------------------</span><br><span>PLUG-discuss mailing list - <a href="mailto:PLUG-discuss@lists.plug.phoenix.az.us" target="_blank">PLUG-discuss@lists.plug.phoenix.az.us</a></span><br>


<span>To subscribe, unsubscribe, or to change your mail settings:</span><br><span><a href="http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss" target="_blank">http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss</a></span></div>


</blockquote></div></div><br>---------------------------------------------------<br>
PLUG-discuss mailing list - <a href="mailto:PLUG-discuss@lists.plug.phoenix.az.us" target="_blank">PLUG-discuss@lists.plug.phoenix.az.us</a><br>
To subscribe, unsubscribe, or to change your mail settings:<br>
<a href="http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss" target="_blank">http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br><font size="3"><div style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px">


<font face="arial, helvetica, sans-serif">Vimal (rhymes with Kimmel) Shah</font></div><div style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px"><span style="font-family:arial,helvetica,sans-serif;font-size:13px">VP of Engineering</span></div>


<span style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px"><font face="arial, helvetica, sans-serif">Sokikom<br>Mobile: <a href="tel:%28480%29%20752-9269" value="+14807529269" target="_blank">(480) 752-9269</a><br>

Email:<font color="#500050">   </font><a href="mailto:vimals@sokikom.com" style="color:rgb(42,93,176)" target="_blank">vimals@sokikom.com</a></font></span><div style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px">


<font face="arial, helvetica, sans-serif">Web:<font color="#500050">    </font><font color="#3333FF" style="color:rgb(42,93,176)"><a href="http://www.sokikom.com/" style="color:rgb(42,93,176)" target="_blank">www.sokikom.com</a></font></font></div>


<div><font face="arial, helvetica, sans-serif"><br></font></div></font><div><div style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px">Follow us: <a href="http://www.twitter.com/sokikom" style="color:rgb(42,93,176)" target="_blank">twitter.com/sokikom</a></div>


<div style="border-collapse:collapse;font-family:arial,sans-serif;font-size:13px">Like us: <a href="http://www.facebook.com/sokikom" style="color:rgb(42,93,176)" target="_blank">facebook.com/sokikom</a></div></div><br>
</div></div>