<div dir="ltr">Query OK, 502150 rows affected (32 min 2.77 sec) and nothing has changed, lol.<div><br></div><div>Thank you.</div><div><br></div><div>Regards.</div><div><br></div><div>Guilherme.</div></div><div class="gmail_extra">

<br><br><div class="gmail_quote">2013/9/3 Gangur, Hrushikesh (HP Converged Cloud - R&D - Sunnyvale) <span dir="ltr"><<a href="mailto:hrushikesh.gangur@hp.com" target="_blank">hrushikesh.gangur@hp.com</a>></span><br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">





<div lang="EN-US" link="blue" vlink="purple">
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">I usually run this on my SQL Query to clean up expired tokens:<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">DELETE FROM token WHERE expires <= NOW();<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Unfortunately, this does not help much in improving slow response time of nova list or other APIs, but worth trying it out.<u></u><u></u></span></p>


<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Guilherme Russi [mailto:<a href="mailto:luisguilherme.cr@gmail.com" target="_blank">luisguilherme.cr@gmail.com</a>]
<br>
<b>Sent:</b> Tuesday, September 03, 2013 8:23 AM<br>
<b>To:</b> openstack<br>
<b>Subject:</b> [Openstack] Slow API operations<u></u><u></u></span></p><div><div class="h5">
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">Hello guys,<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"> I'm facing a problem where my APIs' works are too slow, I've been searching through the internet and I saw some people talking about expired keystone tokens, but my point is, how do I find which tokens are still valid and which are expired?
 Those guys were talkning about <span style="font-family:"Verdana","sans-serif"">"keystone-manage token flush" but it will be coming in havana and I'm using grizzly.</span><u></u><u></u></p>


</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif"">Can anybody help me to fix it?</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif"">Regards.</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:"Verdana","sans-serif"">Guilherme.</span><u></u><u></u></p>
</div>
</div>
</div></div></div>
</div>

</blockquote></div><br></div>