[Openstack] Deletion data from db

Antonio Messina antonio.s.messina at gmail.com
Thu Nov 21 07:57:47 UTC 2013


There is also a tool from www.mysql.com called Workbench:
http://www.mysql.com/products/workbench/ There is a free version and a
commercial edition.

.a.

On Mon, Nov 18, 2013 at 3:46 AM, wu jiang <wingwj at gmail.com> wrote:
> Hi Nick,
>
> If you want to see the relations of db structure (like nova), you can use
> Navicat/Navicat Data Modeler (license needed..).
> Access to your db --> select all tables (ctrl+a) --> right click and choose
> "Reverse Tables to Model",
> then you'll get the results like the attachment I posted.
>
> Please Enjoy.
>
> wingwj
>
>
>
> On Mon, Nov 18, 2013 at 1:49 AM, Nick Maslov <azpekt at gmail.com> wrote:
>>
>> Hi,
>>
>> I'm having a question loosely related to your request, Slawek :)
>>
>> Do anyone have docs about all the database tables, their relations and
>> purpose?
>>
>> Thanks a lot!
>>
>> Sent from my iPad
>>
>> > On 15 лист. 2013, at 13:07, Sławek Kapłoński <slawek at kaplonski.pl>
>> > wrote:
>> >
>> > Hello,
>> >
>> > In nova database lot of data like quotas, reservations, security_groups
>> > and other are not phisically removed but are marked as deleted. So for
>> > example after tempest run on such infrastructure there is a lot of entries
>> > marked as deleted. So I' thinking for what all that data is stored in
>> > database and what could be consequences of removing it from database. Is it
>> > stored only for some kind of "history" what was happend or maybe is is
>> > important for some functions? Thanks in advance for any info about that or
>> > for any link to website where it is described :)
>> >
>> > --
>> > Pozdrawiam
>> > Sławek Kapłoński
>> > slawek at kaplonski.pl
>> >
>> > _______________________________________________
>> > Mailing list:
>> > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
>> > Post to     : openstack at lists.openstack.org
>> > Unsubscribe :
>> > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
>>
>> _______________________________________________
>> Mailing list:
>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
>> Post to     : openstack at lists.openstack.org
>> Unsubscribe :
>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
>
>
>
> _______________________________________________
> Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
> Post to     : openstack at lists.openstack.org
> Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
>



-- 
antonio.s.messina at gmail.com
antonio.messina at uzh.ch                     +41 (0)44 635 42 22
GC3: Grid Computing Competence Center      http://www.gc3.uzh.ch/
University of Zurich
Winterthurerstrasse 190
CH-8057 Zurich Switzerland




More information about the Openstack mailing list