<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Title" content="">
<meta name="Keywords" content="">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:Calibri;
color:windowtext;}
span.msoIns
{mso-style-type:export-only;
mso-style-name:"";
text-decoration:underline;
color:teal;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:595.0pt 842.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body bgcolor="white" lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri">There are also some tools in the OSOps repository (Nova for example has
<a href="https://github.com/openstack/osops-tools-generic/tree/master/nova)">https://github.com/openstack/osops-tools-generic/tree/master/nova)</a><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri">Tim<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri"><o:p> </o:p></span></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-family:Calibri;color:black">From: </span>
</b><span style="font-family:Calibri;color:black">Abel Lopez <alopgeek@gmail.com><br>
<b>Date: </b>Thursday 23 June 2016 at 00:03<br>
<b>To: </b>Gilles Mocellin <gilles.mocellin@nuagelibre.org><br>
<b>Cc: </b>openstack-operators <openstack-operators@lists.openstack.org><br>
<b>Subject: </b>Re: [Openstack-operators] How do you handle purge of database tables ?<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<blockquote style="border:none;border-left:solid #B5C4DF 4.5pt;padding:0cm 0cm 0cm 4.0pt;margin-left:3.75pt;margin-right:0cm" id="MAC_OUTLOOK_ATTRIBUTION_BLOCKQUOTE">
<div>
<div>
<div>
<p class="MsoNormal">Some projects (e.g. cinder) have tools.. <o:p></o:p></p>
<div>
<p class="MsoNormal">`cinder-manage db-purge` or maybe it's "db purge" or something along those lines...<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">It was around Kilo when that got added.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Otherwise, in the past, I've done<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">mysql backup, then a massive table by table purge of "deleted=1" rows.<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Wed, Jun 22, 2016 at 2:39 PM, Gilles Mocellin <<a href="mailto:gilles.mocellin@nuagelibre.org" target="_blank">gilles.mocellin@nuagelibre.org</a>> wrote:<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<p class="MsoNormal">Le 22/06/2016 à 23:26, Gilles Mocellin a écrit :<o:p></o:p></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0cm 0cm 0cm 6.0pt;margin-left:4.8pt;margin-right:0cm">
<p class="MsoNormal" style="margin-bottom:12.0pt">Hello,<br>
<br>
While digging in nova's database, I found that many objects ar not really deleted, but instead just marked deleted.<br>
In fact, it's a general behavior in other projects (cinder, glance...).<br>
<br>
I understand that. It can be handy.<br>
<br>
But, is there a way to handle regular purging of theses elements inside OpenStack configuration ?<br>
<br>
Or do we, operators, have to create batchs to purge all that ?<o:p></o:p></p>
</blockquote>
<p class="MsoNormal"><br>
I've found some blueprints indicating that there nothing for now, inside OpenStack :<br>
<br>
<a href="https://blueprints.launchpad.net/nova/+spec/purge-deleted-instances-cmd" target="_blank">https://blueprints.launchpad.net/nova/+spec/purge-deleted-instances-cmd</a><br>
<a href="https://blueprints.launchpad.net/cinder/+spec/database-purge" target="_blank">https://blueprints.launchpad.net/cinder/+spec/database-purge</a><br>
<a href="https://blueprints.launchpad.net/glance/+spec/database-purge" target="_blank">https://blueprints.launchpad.net/glance/+spec/database-purge</a>
<o:p></o:p></p>
<div>
<div>
<p class="MsoNormal"><br>
<br>
<br>
_______________________________________________<br>
OpenStack-operators mailing list<br>
<a href="mailto:OpenStack-operators@lists.openstack.org" target="_blank">OpenStack-operators@lists.openstack.org</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators</a><o:p></o:p></p>
</div>
</div>
</blockquote>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
</div>
</blockquote>
</div>
</body>
</html>