I already attached the list.<div><br></div><div>Attaching one more time &amp; thanks for the interest.</div><div><br></div><div>Cheers<br><br><div class="gmail_quote">On Wed, Sep 5, 2012 at 11:44 AM, Manuel Arostegui <span dir="ltr">&lt;<a href="mailto:manuel@tuenti.com" target="_blank">manuel@tuenti.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br><br><div class="gmail_quote"><div class="im">2012/9/5 Adarsh Sharma <span dir="ltr">&lt;<a href="mailto:eddy.adarsh@gmail.com" target="_blank">eddy.adarsh@gmail.com</a>&gt;</span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">

Actually that query is not my concern :<div><br></div><div>i have a query that is taking so much time :</div><div>Slow Log Output :</div><div><div># Overall: 195 total, 16 unique, 0.00 QPS, 0.31x concurrency _____________</div>



<div># Time range: 2012-09-01 14:30:01 to 2012-09-04 14:13:46</div><div># Attribute          total     min     max     avg     95%  stddev  median</div><div># ============     ======= ======= ======= ======= ======= ======= =======</div>



<div># Exec time         80887s   192us   2520s    415s   1732s    612s     80s</div><div># Lock time           13ms       0   133us    68us   103us    23us    69us</div><div># Rows sent        430.89k       0  17.58k   2.21k  12.50k   3.96k   49.17</div>



<div># Rows examine      32.30M       0 466.46k 169.63k 440.37k 186.02k 117.95k</div><div># Query size        65.45k       6     577  343.70  563.87  171.06  246.02</div></div><div><br></div><div>In the logs output :</div>



<div><div># Query_time: 488.031783  Lock_time: 0.000041 Rows_sent: 50  Rows_examined: 471150</div><div>SET timestamp=1346655789;</div><div>SELECT <a href="http://t0.id" target="_blank">t0.id</a>, t0.app_name, t0.status, t0.run, t0.user_name, t0.group_name, t0.created_time, t0.start_time, t0.last_modified_time, t0.end_time, t0.external_id FROM WF_1 t0 WHERE t0.bean_type = &#39;Workflow&#39; ORDER BY t0.created_time DESC LIMIT 0, 50;</div>



</div><div><br></div><div>The table is near about 30 GB and growing day by day. </div></blockquote><div><br></div></div><div>Just out curiosity, is that table too fragmented? 471k rows are quite a lot, but 488 of query time is insane. Seems you&#39;re reading from disk too much!</div>
<div class="im">

<div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><br></div><div>Attaching the table definition &amp; indexes output. I have a index on bean type column but cann&#39;t understand why it </div>



<div>examined the all rows of table.</div></blockquote><div><br></div></div><div>Where&#39;s the table&#39;s schema so we can give it a try?</div><div><br></div><div>Manu</div></div>
</blockquote></div><br></div>