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 <[email protected]> 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 <[email protected]> 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 <[email protected]> >> > 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 >> > [email protected] >> > >> > _______________________________________________ >> > Mailing list: >> > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack >> > Post to : [email protected] >> > Unsubscribe : >> > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack >> >> _______________________________________________ >> Mailing list: >> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack >> Post to : [email protected] >> Unsubscribe : >> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack > > > > _______________________________________________ > Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack > Post to : [email protected] > Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack > -- [email protected] [email protected] +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 _______________________________________________ Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack Post to : [email protected] Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
