From sanjal at redhat.com Thu Mar 7 00:30:33 2013 Content-Type: multipart/mixed; boundary="===============8116892272215887610==" MIME-Version: 1.0 From: Shireesh Anjal To: users at ovirt.org Subject: Re: [Users] databases naming way is so confusing Date: Thu, 07 Mar 2013 11:00:26 +0530 Message-ID: <513825F2.6000508@redhat.com> In-Reply-To: 6ac02f2d.4560.13d42c4bba3.Coremail.bigclouds@163.com --===============8116892272215887610== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable This is a multi-part message in MIME format. --------------030907040900080302010300 Content-Type: text/plain; charset=3DISO-8859-1; format=3Dflowed Content-Transfer-Encoding: 7bit On 03/07/2013 08:23 AM, bigclouds wrote: > hi, today i look into the databases,i find the way of naming of = > tables is so confusing. > like vds_group=3D=3Dcluster,storage_pool=3D=3Ddatacenter,........ > i think it is better straightforward. I agree :) I believe it's more of a 'legacy' issue. > > now i have not found which table is HOST. The view VDS should provide most details of a HOST. The underlying = tables are VDS_STATIC, VDS_DYNAMIC and VDS_STATISTICS Once you get that VDS is HOST, VDS_GROUP suddenly starts making sense :) > > i appreciate your hard work,but i hope my suggest is meaningful. > > thanks > > > > > _______________________________________________ > Users mailing list > Users(a)ovirt.org > http://lists.ovirt.org/mailman/listinfo/users --------------030907040900080302010300 Content-Type: text/html; charset=3DISO-8859-1 Content-Transfer-Encoding: 7bit

On 03/07/2013 08:23 AM, bigclouds wrote:

hi, today i look into the databases,i find the way of naming of tables is so confusing.
like vds_group=3D=3Dcluster,storage_pool=3D=3Ddatacenter,.....= ...

i think it is better straightforward.

I agree :)
I believe it's more of a 'legacy' issue.

now i have not found which table is HOST.

The view VDS should provide most details of a HOST. The underlying tables are VDS_STATIC, VDS_DYNAMIC and VDS_STATISTICS
Once you get that VDS is HOST, VDS_GROUP suddenly starts making sense :)

i appreciate your hard work,but i hope my suggest is meaningful.

thanks

_______________________________________________ Users mailing list Use= rs(a)ovirt.org http://lists.ovirt.org/mailman/listinfo/users

--------------030907040900080302010300-- --===============8116892272215887610== Content-Type: multipart/alternative MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="attachment.bin" VGhpcyBpcyBhIG11bHRpLXBhcnQgbWVzc2FnZSBpbiBNSU1FIGZvcm1hdC4KLS0tLS0tLS0tLS0t LS0wMzA5MDcwNDA5MDAwODAzMDIwMTAzMDAKQ29udGVudC1UeXBlOiB0ZXh0L3BsYWluOyBjaGFy c2V0PUlTTy04ODU5LTE7IGZvcm1hdD1mbG93ZWQKQ29udGVudC1UcmFuc2Zlci1FbmNvZGluZzog N2JpdAoKT24gMDMvMDcvMjAxMyAwODoyMyBBTSwgYmlnY2xvdWRzIHdyb3RlOgo+IGhpLCB0b2Rh eSBpIGxvb2sgaW50byB0aGUgZGF0YWJhc2VzLGkgZmluZCB0aGUgd2F5IG9mIG5hbWluZyAgb2Yg Cj4gdGFibGVzIGlzIHNvIGNvbmZ1c2luZy4KPiBsaWtlIHZkc19ncm91cD09Y2x1c3RlcixzdG9y YWdlX3Bvb2w9PWRhdGFjZW50ZXIsLi4uLi4uLi4KPiBpIHRoaW5rIGl0IGlzIGJldHRlciBzdHJh aWdodGZvcndhcmQuCgpJIGFncmVlIDopCkkgYmVsaWV2ZSBpdCdzIG1vcmUgb2YgYSAnbGVnYWN5 JyBpc3N1ZS4KCj4KPiBub3cgaSBoYXZlIG5vdCBmb3VuZCB3aGljaCB0YWJsZSBpcyBIT1NULgoK VGhlIHZpZXcgVkRTIHNob3VsZCBwcm92aWRlIG1vc3QgZGV0YWlscyBvZiBhIEhPU1QuIFRoZSB1 bmRlcmx5aW5nIAp0YWJsZXMgYXJlIFZEU19TVEFUSUMsIFZEU19EWU5BTUlDIGFuZCBWRFNfU1RB VElTVElDUwpPbmNlIHlvdSBnZXQgdGhhdCBWRFMgaXMgSE9TVCwgVkRTX0dST1VQIHN1ZGRlbmx5 IHN0YXJ0cyBtYWtpbmcgc2Vuc2UgOikKCj4KPiBpIGFwcHJlY2lhdGUgeW91ciBoYXJkIHdvcmss YnV0IGkgaG9wZSBteSBzdWdnZXN0IGlzIG1lYW5pbmdmdWwuCj4KPiB0aGFua3MKPgo+Cj4KPgo+ IF9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fCj4gVXNlcnMg bWFpbGluZyBsaXN0Cj4gVXNlcnNAb3ZpcnQub3JnCj4gaHR0cDovL2xpc3RzLm92aXJ0Lm9yZy9t YWlsbWFuL2xpc3RpbmZvL3VzZXJzCgoKLS0tLS0tLS0tLS0tLS0wMzA5MDcwNDA5MDAwODAzMDIw MTAzMDAKQ29udGVudC1UeXBlOiB0ZXh0L2h0bWw7IGNoYXJzZXQ9SVNPLTg4NTktMQpDb250ZW50 LVRyYW5zZmVyLUVuY29kaW5nOiA3Yml0Cgo8aHRtbD4KICA8aGVhZD4KICAgIDxtZXRhIGNvbnRl bnQ9InRleHQvaHRtbDsgY2hhcnNldD1JU08tODg1OS0xIgogICAgICBodHRwLWVxdWl2PSJDb250 ZW50LVR5cGUiPgogIDwvaGVhZD4KICA8Ym9keSBiZ2NvbG9yPSIjRkZGRkZGIiB0ZXh0PSIjMDAw MDAwIj4KICAgIDxkaXYgY2xhc3M9Im1vei1jaXRlLXByZWZpeCI+T24gMDMvMDcvMjAxMyAwODoy MyBBTSwgYmlnY2xvdWRzCiAgICAgIHdyb3RlOjxicj4KICAgIDwvZGl2PgogICAgPGJsb2NrcXVv dGUKICAgICAgY2l0ZT0ibWlkOjZhYzAyZjJkLjQ1NjAuMTNkNDJjNGJiYTMuQ29yZW1haWwuYmln Y2xvdWRzQDE2My5jb20iCiAgICAgIHR5cGU9ImNpdGUiPgogICAgICA8ZGl2CiAgICAgICAgc3R5 bGU9ImxpbmUtaGVpZ2h0OjEuNztjb2xvcjojMDAwMDAwO2ZvbnQtc2l6ZToxNHB4O2ZvbnQtZmFt aWx5OmFyaWFsIj5oaSwKICAgICAgICB0b2RheSBpIGxvb2sgaW50byB0aGUgZGF0YWJhc2VzLGkg ZmluZCB0aGUgd2F5IG9mIG5hbWluZyAmbmJzcDtvZgogICAgICAgIHRhYmxlcyBpcyBzbyBjb25m dXNpbmcuCiAgICAgICAgPGRpdj5saWtlIHZkc19ncm91cD09Y2x1c3RlcixzdG9yYWdlX3Bvb2w9 PWRhdGFjZW50ZXIsLi4uLi4uLi48L2Rpdj4KICAgICAgICA8ZGl2PmkgdGhpbmsgaXQgaXMgYmV0 dGVyIHN0cmFpZ2h0Zm9yd2FyZC48L2Rpdj4KICAgICAgPC9kaXY+CiAgICA8L2Jsb2NrcXVvdGU+ CiAgICA8YnI+CiAgICBJIGFncmVlIDopPGJyPgogICAgSSBiZWxpZXZlIGl0J3MgbW9yZSBvZiBh ICdsZWdhY3knIGlzc3VlLjxicj4KICAgIDxicj4KICAgIDxibG9ja3F1b3RlCiAgICAgIGNpdGU9 Im1pZDo2YWMwMmYyZC40NTYwLjEzZDQyYzRiYmEzLkNvcmVtYWlsLmJpZ2Nsb3Vkc0AxNjMuY29t IgogICAgICB0eXBlPSJjaXRlIj4KICAgICAgPGRpdgogICAgICAgIHN0eWxlPSJsaW5lLWhlaWdo dDoxLjc7Y29sb3I6IzAwMDAwMDtmb250LXNpemU6MTRweDtmb250LWZhbWlseTphcmlhbCI+CiAg ICAgICAgPGRpdj48YnI+CiAgICAgICAgPC9kaXY+CiAgICAgICAgPGRpdj5ub3cgaSBoYXZlIG5v dCBmb3VuZCB3aGljaCB0YWJsZSBpcyBIT1NULjwvZGl2PgogICAgICA8L2Rpdj4KICAgIDwvYmxv Y2txdW90ZT4KICAgIDxicj4KICAgIFRoZSB2aWV3IFZEUyBzaG91bGQgcHJvdmlkZSBtb3N0IGRl dGFpbHMgb2YgYSBIT1NULiBUaGUgdW5kZXJseWluZwogICAgdGFibGVzIGFyZSBWRFNfU1RBVElD LCBWRFNfRFlOQU1JQyBhbmQgVkRTX1NUQVRJU1RJQ1M8YnI+CiAgICBPbmNlIHlvdSBnZXQgdGhh dCBWRFMgaXMgSE9TVCwgVkRTX0dST1VQIHN1ZGRlbmx5IHN0YXJ0cyBtYWtpbmcKICAgIHNlbnNl IDopPGJyPgogICAgPGJyPgogICAgPGJsb2NrcXVvdGUKICAgICAgY2l0ZT0ibWlkOjZhYzAyZjJk LjQ1NjAuMTNkNDJjNGJiYTMuQ29yZW1haWwuYmlnY2xvdWRzQDE2My5jb20iCiAgICAgIHR5cGU9 ImNpdGUiPgogICAgICA8ZGl2CiAgICAgICAgc3R5bGU9ImxpbmUtaGVpZ2h0OjEuNztjb2xvcjoj MDAwMDAwO2ZvbnQtc2l6ZToxNHB4O2ZvbnQtZmFtaWx5OmFyaWFsIj4KICAgICAgICA8ZGl2Pjxi cj4KICAgICAgICA8L2Rpdj4KICAgICAgICA8ZGl2PmkgYXBwcmVjaWF0ZSB5b3VyIGhhcmQgd29y ayxidXQgaSBob3BlIG15IHN1Z2dlc3QgaXMKICAgICAgICAgIG1lYW5pbmdmdWwuPC9kaXY+CiAg ICAgICAgPGRpdj48YnI+CiAgICAgICAgPC9kaXY+CiAgICAgICAgPGRpdj50aGFua3M8L2Rpdj4K ICAgICAgPC9kaXY+CiAgICAgIDxicj4KICAgICAgPGJyPgogICAgICA8c3BhbiB0aXRsZT0ibmV0 ZWFzZWZvb3RlciI+PHNwYW4gaWQ9Im5ldGVhc2VfbWFpbF9mb290ZXIiPjwvc3Bhbj48L3NwYW4+ CiAgICAgIDxicj4KICAgICAgPGZpZWxkc2V0IGNsYXNzPSJtaW1lQXR0YWNobWVudEhlYWRlciI+ PC9maWVsZHNldD4KICAgICAgPGJyPgogICAgICA8cHJlIHdyYXA9IiI+X19fX19fX19fX19fX19f X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KVXNlcnMgbWFpbGluZyBsaXN0CjxhIGNs YXNzPSJtb3otdHh0LWxpbmstYWJicmV2aWF0ZWQiIGhyZWY9Im1haWx0bzpVc2Vyc0BvdmlydC5v cmciPlVzZXJzQG92aXJ0Lm9yZzwvYT4KPGEgY2xhc3M9Im1vei10eHQtbGluay1mcmVldGV4dCIg aHJlZj0iaHR0cDovL2xpc3RzLm92aXJ0Lm9yZy9tYWlsbWFuL2xpc3RpbmZvL3VzZXJzIj5odHRw Oi8vbGlzdHMub3ZpcnQub3JnL21haWxtYW4vbGlzdGluZm8vdXNlcnM8L2E+CjwvcHJlPgogICAg PC9ibG9ja3F1b3RlPgogICAgPGJyPgogIDwvYm9keT4KPC9odG1sPgoKLS0tLS0tLS0tLS0tLS0w MzA5MDcwNDA5MDAwODAzMDIwMTAzMDAtLQo= --===============8116892272215887610==--