<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:0in;
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;
font-family:Calibri;
color:windowtext;}
span.EmailStyle18
{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:1.0in 1.0in 1.0in 1.0in;}
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">I would encourage you to use that repo and if there is something worth to be added updated, please do! All suggestions are welcome.<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">Edgar<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 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-family:Calibri;color:black">From: </span>
</b><span style="font-family:Calibri;color:black">Tim Bell <Tim.Bell@cern.ch><br>
<b>Date: </b>Wednesday, June 22, 2016 at 10:53 PM<br>
<b>To: </b>Abel Lopez <alopgeek@gmail.com>, Gilles Mocellin <gilles.mocellin@nuagelibre.org><br>
<b>Cc: </b>"OpenStack-operators@lists.openstack.org" <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>
<div>
<div>
<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://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_openstack_osops-2Dtools-2Dgeneric_tree_master_nova-29&d=CwMGaQ&c=DS6PUFBBr_KiLo7Sjt3ljp5jaW5k2i9ijVXllEdOozc&r=G0XRJfDQsuBvqa_wpWyDAUlSpeMV4W1qfWqBfctlWwQ&m=YTsxdMdPQDeVWL18ZtfPm4l8Ukb65tAIMhgQ9NI5wtQ&s=iqH-TOGPCLIqE7no9W6uOVjn0xGpf-aV9YPh_whjx8Q&e=">
https://github.com/openstack/osops-tools-generic/tree/master/nova)</a></span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri"> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri">Tim</span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:Calibri"> </span><o:p></o:p></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<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 ?</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #B5C4DF 4.5pt;padding:0in 0in 0in 4.0pt;margin-left:3.75pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt" 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:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<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:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<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://urldefense.proofpoint.com/v2/url?u=https-3A__blueprints.launchpad.net_nova_-26-2343-3Bspec_purge-2Ddeleted-2Dinstances-2Dcmd&d=CwMGaQ&c=DS6PUFBBr_KiLo7Sjt3ljp5jaW5k2i9ijVXllEdOozc&r=G0XRJfDQsuBvqa_wpWyDAUlSpeMV4W1qfWqBfctlWwQ&m=YTsxdMdPQDeVWL18ZtfPm4l8Ukb65tAIMhgQ9NI5wtQ&s=NNbrSqzhDJ1ZxMs5D6pZKKrpsFj6PY1ssWnk6ITIQtA&e=" target="_blank">https://blueprints.launchpad.net/nova/+spec/purge-deleted-instances-cmd</a><br>
<a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__blueprints.launchpad.net_cinder_-26-2343-3Bspec_database-2Dpurge&d=CwMGaQ&c=DS6PUFBBr_KiLo7Sjt3ljp5jaW5k2i9ijVXllEdOozc&r=G0XRJfDQsuBvqa_wpWyDAUlSpeMV4W1qfWqBfctlWwQ&m=YTsxdMdPQDeVWL18ZtfPm4l8Ukb65tAIMhgQ9NI5wtQ&s=CeqEqcnBufMXJxtM88hq2RG0qxfrqP6Eq6WofpFhqeM&e=" target="_blank">https://blueprints.launchpad.net/cinder/+spec/database-purge</a><br>
<a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__blueprints.launchpad.net_glance_-26-2343-3Bspec_database-2Dpurge&d=CwMGaQ&c=DS6PUFBBr_KiLo7Sjt3ljp5jaW5k2i9ijVXllEdOozc&r=G0XRJfDQsuBvqa_wpWyDAUlSpeMV4W1qfWqBfctlWwQ&m=YTsxdMdPQDeVWL18ZtfPm4l8Ukb65tAIMhgQ9NI5wtQ&s=iFf934niIjhaYHZLjcSD9-ebCVvpEeIOqljFy9unIfo&e=" 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="https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.openstack.org_cgi-2Dbin_mailman_listinfo_openstack-2Doperators&d=CwMGaQ&c=DS6PUFBBr_KiLo7Sjt3ljp5jaW5k2i9ijVXllEdOozc&r=G0XRJfDQsuBvqa_wpWyDAUlSpeMV4W1qfWqBfctlWwQ&m=YTsxdMdPQDeVWL18ZtfPm4l8Ukb65tAIMhgQ9NI5wtQ&s=O4evdHuvokO4rzSqgxybzMqXAxxQJ88dRb4S3DJd-Xw&e=" 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>
</div>
</div>
</body>
</html>