----- Original Message ----- > From: "Omer Frenkel" <ofren...@redhat.com> > To: "Gilad Chaplik" <gchap...@redhat.com> > Cc: "Xiao-Lei Shi (Bruce, HP Servers-PSC-CQ)" <xiao-lei....@hp.com>, "Roy > Golan" <rgo...@redhat.com>, "Eli Mesika" > <emes...@redhat.com>, "Chuan Liao (Jason Liao, HPservers-Core-OE-PSC)" > <chuan.l...@hp.com>, "Doron Fediuck" > <dfedi...@redhat.com>, "Chegu Vinod" <chegu_vi...@hp.com>, "Shang-Chun Liang > (David Liang, HPservers-Core-OE-PSC)" > <shangchun.li...@hp.com>, "Yaniv Dary" <yd...@redhat.com>, > engine-devel@ovirt.org > Sent: Thursday, April 3, 2014 4:45:49 PM > Subject: Re: Please help us to review our database schema design with NUMA > feature on ovirt > > > > ----- Original Message ----- > > From: "Gilad Chaplik" <gchap...@redhat.com> > > To: "Xiao-Lei Shi (Bruce, HP Servers-PSC-CQ)" <xiao-lei....@hp.com>, "Roy > > Golan" <rgo...@redhat.com>, "Omer Frenkel" > > <ofren...@redhat.com> > > Cc: "Eli Mesika" <emes...@redhat.com>, "Roy Golan" <rgo...@redhat.com>, > > "Chuan Liao (Jason Liao, > > HPservers-Core-OE-PSC)" <chuan.l...@hp.com>, "Doron Fediuck" > > <dfedi...@redhat.com>, "Chegu Vinod" > > <chegu_vi...@hp.com>, "Shang-Chun Liang (David Liang, > > HPservers-Core-OE-PSC)" <shangchun.li...@hp.com>, "Yaniv Dary" > > <yd...@redhat.com>, engine-devel@ovirt.org > > Sent: Monday, March 31, 2014 4:31:17 PM > > Subject: Re: Please help us to review our database schema design with NUMA > > feature on ovirt > > > > adding Roy & Omer. > > > > why CPU topology is in dynamic? > > > > the guideline we (try to) follow today is (i know you can find exceptions to > this, but this is how it suppose to be): > vm/vds static - user configurable information (whatever you have in add/edit) > vm dynamic - information related to a running instance, the is changed in a > somewhat small frequency > vds dynamic - host capabilities, information from the host that doesn't > change while the host is up. > statistics - all the rest, mostly statistics, and other fast changing > information.
IMO it is a little more complicated and the terms static/dynamic does not reflect today the meaning of those terms rather, if engine knows the values by itself , this is considered "static" and if it has to ask the VDSM for the value then this is considered "dynamic". For example "cpu_cores" is a static information but it is stored in vds_dynamic since we get the value from VDSM. I found those terms very confusing and a good candidate for a serious refactoring in future > > > Thanks, > > Gilad. > > > > ----- Original Message ----- > > > From: "Xiao-Lei Shi (Bruce, HP Servers-PSC-CQ)" <xiao-lei....@hp.com> > > > To: "Eli Mesika" <emes...@redhat.com> > > > Cc: "Gilad Chaplik" <gchap...@redhat.com>, "Roy Golan" > > > <rgo...@redhat.com>, > > > "Chuan Liao (Jason Liao, > > > HPservers-Core-OE-PSC)" <chuan.l...@hp.com>, "Doron Fediuck" > > > <dfedi...@redhat.com>, "Chegu Vinod" > > > <chegu_vi...@hp.com>, "Shang-Chun Liang (David Liang, > > > HPservers-Core-OE-PSC)" <shangchun.li...@hp.com>, "Yaniv Dary" > > > <yd...@redhat.com>, engine-devel@ovirt.org > > > Sent: Monday, March 31, 2014 3:20:33 PM > > > Subject: RE: Please help us to review our database schema design with > > > NUMA > > > feature on ovirt > > > > > > Thanks Eli. > > > I will move the vm level NUMA fields to vm_dynamic, and the related > > > database > > > schema will be updated accordingly. > > > > > > Thanks & Best Regards > > > Shi, Xiao-Lei (Bruce) > > > > > > Hewlett-Packard Co., Ltd. > > > HP Servers Core Platform Software China > > > Telephone +86 23 65683093 > > > Mobile +86 18696583447 > > > Email xiao-lei....@hp.com > > > > > > -----Original Message----- > > > From: Eli Mesika [mailto:emes...@redhat.com] > > > Sent: Monday, March 31, 2014 5:49 PM > > > To: Shi, Xiao-Lei (Bruce, HP Servers-PSC-CQ) > > > Cc: Gilad Chaplik; Roy Golan; Liao, Chuan (Jason Liao, > > > HPservers-Core-OE-PSC); Doron Fediuck; Vinod, Chegu; Liang, Shang-Chun > > > (David Liang, HPservers-Core-OE-PSC); Yaniv Dary; engine-devel@ovirt.org > > > Subject: Re: Please help us to review our database schema design with > > > NUMA > > > feature on ovirt > > > > > > > > > > > > ----- Original Message ----- > > > > From: "Xiao-Lei Shi (Bruce, HP Servers-PSC-CQ)" <xiao-lei....@hp.com> > > > > To: "Gilad Chaplik" <gchap...@redhat.com>, "Eli Mesika" > > > > <emes...@redhat.com>, "Roy Golan" <rgo...@redhat.com> > > > > Cc: "Chuan Liao (Jason Liao, HPservers-Core-OE-PSC)" > > > > <chuan.l...@hp.com>, "Doron Fediuck" <dfedi...@redhat.com>, "Chegu > > > > Vinod" > > > > <chegu_vi...@hp.com>, "Shang-Chun Liang (David Liang, > > > > HPservers-Core-OE-PSC)" > > > > <shangchun.li...@hp.com>, "Yaniv Dary" <yd...@redhat.com>, > > > > engine-devel@ovirt.org > > > > Sent: Monday, March 31, 2014 12:38:04 PM > > > > Subject: RE: Please help us to review our database schema design with > > > > NUMA feature on ovirt > > > > > > > > We put host level NUMA fields in vds_dynamic because these information > > > > are from host itself, and NUMA topology may be changed if the host's > > > > hardware make a change. NUMA information are similar to the host's cpu > > > > topology information like cpu_cores and cpu_sockets which are in > > > > vds_dynamic, we refer to this. > > > > VM level NUMA fields are configured by user, and actually we > > > > originally think they should be in vm_dynamic. But we found that the > > > > field of another feature cpuPin which is similar as NUMA feature is in > > > > vm_static, so we put vm NUMA fields in vm_static. > > > > Do you think we need to put VM level NUMA fields in vm_dynamic? > > > > > > I think that in this case we should fix cpuPin to be in vm_dynamic and > > > put > > > after that the other NUMA fields in vm_dynamic as well > > > > > > > > > > > Thanks & Best Regards > > > > Shi, Xiao-Lei (Bruce) > > > > > > > > Hewlett-Packard Co., Ltd. > > > > HP Servers Core Platform Software China Telephone +86 23 65683093 > > > > Mobile +86 18696583447 Email xiao-lei....@hp.com > > > > > > > > > > > > -----Original Message----- > > > > From: Gilad Chaplik [mailto:gchap...@redhat.com] > > > > Sent: Monday, March 31, 2014 5:22 PM > > > > To: Eli Mesika; Roy Golan > > > > Cc: Shi, Xiao-Lei (Bruce, HP Servers-PSC-CQ); Liao, Chuan (Jason Liao, > > > > HPservers-Core-OE-PSC); Doron Fediuck; Vinod, Chegu; Liang, Shang-Chun > > > > (David Liang, HPservers-Core-OE-PSC); Yaniv Dary; > > > > engine-devel@ovirt.org > > > > Subject: Re: Please help us to review our database schema design with > > > > NUMA > > > > feature on ovirt > > > > > > > > +1 > > > > > > > > IMO: vds data should reside in static > > > > VM need to think about it. > > > > > > > > Roy? > > > > > > > > Thanks, > > > > Gilad. > > > > > > > > > > > > ----- Original Message ----- > > > > > From: "Eli Mesika" <emes...@redhat.com> > > > > > To: "Xiao-Lei Shi (Bruce, HP Servers-PSC-CQ)" <xiao-lei....@hp.com> > > > > > Cc: "Chuan Liao (Jason Liao, HPservers-Core-OE-PSC)" > > > > > <chuan.l...@hp.com>, > > > > > "Doron Fediuck" <dfedi...@redhat.com>, > > > > > "Gilad Chaplik" <gchap...@redhat.com>, "Chegu Vinod" > > > > > <chegu_vi...@hp.com>, > > > > > "Shang-Chun Liang (David Liang, > > > > > HPservers-Core-OE-PSC)" <shangchun.li...@hp.com>, "Yaniv Dary" > > > > > <yd...@redhat.com>, engine-devel@ovirt.org > > > > > Sent: Monday, March 31, 2014 12:12:50 PM > > > > > Subject: Re: Please help us to review our database schema design with > > > > > NUMA > > > > > feature on ovirt > > > > > > > > > > > > > > > > > > > > ----- Original Message ----- > > > > > > From: "Xiao-Lei Shi (Bruce, HP Servers-PSC-CQ)" > > > > > > <xiao-lei....@hp.com> > > > > > > To: "Eli Mesika" <emes...@redhat.com> > > > > > > Cc: "Chuan Liao (Jason Liao, HPservers-Core-OE-PSC)" > > > > > > <chuan.l...@hp.com>, > > > > > > "Doron Fediuck" <dfedi...@redhat.com>, > > > > > > "Gilad Chaplik" <gchap...@redhat.com>, "Chegu Vinod" > > > > > > <chegu_vi...@hp.com>, > > > > > > "Shang-Chun Liang (David Liang, > > > > > > HPservers-Core-OE-PSC)" <shangchun.li...@hp.com>, "Yaniv Dary" > > > > > > <yd...@redhat.com>, engine-devel@ovirt.org > > > > > > Sent: Monday, March 31, 2014 8:56:20 AM > > > > > > Subject: RE: Please help us to review our database schema design > > > > > > with > > > > > > NUMA > > > > > > feature on ovirt > > > > > > > > > > > > Include the devel group. > > > > > > Thanks Eli for the quick responses for our first design and sorry > > > > > > for > > > > > > the > > > > > > nag. > > > > > > We appreciate any of the comments for our database design and will > > > > > > follow > > > > > > the > > > > > > design to do the implementation if no more comments. > > > > > > http://www.ovirt.org/Features/Detailed_NUMA_and_Virtual_NUMA > > > > > > > > > > Seems OK for me except an unanswered question I had asked in my first > > > > > review > > > > > : > > > > > > > > > > Why in the Host level NUMA fields are added to vds_dynamic while in > > > > > the > > > > > VM > > > > > level it is added to vm_static ??? > > > > > I would expect it to be in both on static or dynamic , can you please > > > > > explain > > > > > ? Thanks > > > > > > > > > > > > > > > > > Thanks & Best Regards > > > > > > Shi, Xiao-Lei (Bruce) > > > > > > > > > > > > Hewlett-Packard Co., Ltd. > > > > > > HP Servers Core Platform Software China > > > > > > Telephone +86 23 65683093 > > > > > > Mobile +86 18696583447 > > > > > > Email xiao-lei....@hp.com > > > > > > > > > > > > -----Original Message----- > > > > > > From: Shi, Xiao-Lei (Bruce, HP Servers-PSC-CQ) > > > > > > Sent: Friday, March 28, 2014 1:30 PM > > > > > > To: 'Eli Mesika' > > > > > > Cc: Liao, Chuan (Jason Liao, HPservers-Core-OE-PSC); Doron Fediuck; > > > > > > Gilad > > > > > > Chaplik; Vinod, Chegu; Liang, Shang-Chun (David Liang, > > > > > > HPservers-Core-OE-PSC); Yaniv Dary > > > > > > Subject: RE: Please help us to review our database schema design > > > > > > with > > > > > > NUMA > > > > > > feature on ovirt > > > > > > > > > > > > Hi Eli, > > > > > > > > > > > > After the UX design meeting, we did some modification for the > > > > > > database > > > > > > schema, and merged some update according to your last review > > > > > > comments. > > > > > > Now the document has been posted on ovirt wikipage, could you help > > > > > > to > > > > > > review > > > > > > the database design again: > > > > > > http://www.ovirt.org/Features/Detailed_NUMA_and_Virtual_NUMA > > > > > > > > > > > > > > > > > > Thanks & Best Regards > > > > > > Shi, Xiao-Lei (Bruce) > > > > > > > > > > > > Hewlett-Packard Co., Ltd. > > > > > > HP Servers Core Platform Software China Telephone +86 23 65683093 > > > > > > Mobile > > > > > > +86 > > > > > > 18696583447 Email xiao-lei....@hp.com > > > > > > > > > > > > > > > > > > -----Original Message----- > > > > > > From: Eli Mesika [mailto:emes...@redhat.com] > > > > > > Sent: Monday, March 24, 2014 6:24 PM > > > > > > To: Shi, Xiao-Lei (Bruce, HP Servers-PSC-CQ) > > > > > > Cc: Liao, Chuan (Jason Liao, HPservers-Core-OE-PSC); Doron Fediuck; > > > > > > Gilad > > > > > > Chaplik; Vinod, Chegu; Liang, Shang-Chun (David Liang, > > > > > > HPservers-Core-OE-PSC); Yaniv Dary > > > > > > Subject: Re: Please help us to review our database schema design > > > > > > with > > > > > > NUMA > > > > > > feature on ovirt > > > > > > > > > > > > > > > > > > > > > > > > ----- Original Message ----- > > > > > > > From: "Xiao-Lei Shi (Bruce, HP Servers-PSC-CQ)" > > > > > > > <xiao-lei....@hp.com> > > > > > > > To: "Eli Mesika" <emes...@redhat.com>, "Chuan Liao (Jason Liao, > > > > > > > HPservers-Core-OE-PSC)" <chuan.l...@hp.com> > > > > > > > Cc: "Doron Fediuck" <dfedi...@redhat.com>, "Gilad Chaplik" > > > > > > > <gchap...@redhat.com>, "Chegu Vinod" <chegu_vi...@hp.com>, > > > > > > > "Shang-Chun > > > > > > > Liang (David Liang, HPservers-Core-OE-PSC)" > > > > > > > <shangchun.li...@hp.com> > > > > > > > Sent: Monday, March 24, 2014 11:23:39 AM > > > > > > > Subject: RE: Please help us to review our database schema design > > > > > > > with > > > > > > > NUMA feature on ovirt > > > > > > > > > > > > > > Hi Eli, > > > > > > > > > > > > > > Thanks for your comments. > > > > > > > I have updated the document according to your comments except the > > > > > > > below > > > > > > > one: > > > > > > > Missing from here are 2 issues: > > > > > > > > > > > > > > 1) Impact on the search engine, which new columns are search-able > > > > > > > and > > > > > > > which changes are planned in the search engine code to enable > > > > > > > that > > > > > > > > > > > > > > 2) Impact on engine-reports, are those changed planned to be > > > > > > > exposed > > > > > > > to the engine data warehouse and required new/modified reports? > > > > > > > > > > > > > > Could you tell us more detailed information about the modules you > > > > > > > mentioned above? I mean "search engine" and "engine-reports". I > > > > > > > think > > > > > > > we missed these two parts in our previous investigation. > > > > > > > I just find org.ovirt.engine.core.bll.SearchQuery, is that the > > > > > > > right > > > > > > > object for search engine? > > > > > > > > > > > > Yes, actually when you are opening the admin UI, there are TABs for > > > > > > each > > > > > > entity , i.e. Data Center, Cluster, Host etc. > > > > > > In each, you can see a text-box in which you can search for by > > > > > > writing > > > > > > a > > > > > > search expression My question is > > > > > > 1) What is the impact of your work on the search on the Fost and > > > > > > VM > > > > > > TABs > > > > > > a) Are there any fields that are supported now in the search > > > > > > expression > > > > > > and should pop-up when you write the expression by the > > > > > > auto-completion > > > > > > mechanism ? > > > > > > b) Are there any added columns displayed in the result of > > > > > > such > > > > > > a > > > > > > search > > > > > > in the grid ? > > > > > > > > > > > > > How about the engine-reports, could you give us some hints, like > > > > > > > the > > > > > > > code location and any more detailed information that we can start > > > > > > > more > > > > > > > investigation? > > > > > > > > > > > > CCing Yaniv D who is in charge of the reports/dwh module Yaniv, any > > > > > > planned > > > > > > work for adding Numa features to Host/VM in the reports side ? > > > > > > > > > > > > Thanks > > > > > > > > > > > > > > > > > > > > Thanks & Best Regards > > > > > > > Shi, Xiao-Lei (Bruce) > > > > > > > > > > > > > > Hewlett-Packard Co., Ltd. > > > > > > > HP Servers Core Platform Software China Telephone +86 23 65683093 > > > > > > > Mobile +86 18696583447 Email xiao-lei....@hp.com > > > > > > > > > > > > > > -----Original Message----- > > > > > > > From: Eli Mesika [mailto:emes...@redhat.com] > > > > > > > Sent: Sunday, March 23, 2014 4:44 PM > > > > > > > To: Liao, Chuan (Jason Liao, HPservers-Core-OE-PSC) > > > > > > > Cc: Doron Fediuck; Gilad Chaplik; Vinod, Chegu; Liang, Shang-Chun > > > > > > > (David Liang, HPservers-Core-OE-PSC); Shi, Xiao-Lei (Bruce, HP > > > > > > > Servers-PSC-CQ) > > > > > > > Subject: Re: Please help us to review our database schema design > > > > > > > with > > > > > > > NUMA feature on ovirt > > > > > > > > > > > > > > > > > > > > > > > > > > > > ----- Original Message ----- > > > > > > > > From: "Chuan Liao (Jason Liao, HPservers-Core-OE-PSC)" > > > > > > > > <chuan.l...@hp.com> > > > > > > > > To: emes...@redhat.com > > > > > > > > Cc: "Doron Fediuck" <dfedi...@redhat.com>, "Gilad Chaplik" > > > > > > > > <gchap...@redhat.com>, "Chegu Vinod" <chegu_vi...@hp.com>, > > > > > > > > "Shang-Chun Liang (David Liang, HPservers-Core-OE-PSC)" > > > > > > > > <shangchun.li...@hp.com>, "Xiao-Lei Shi (Bruce, HP > > > > > > > > Servers-PSC-CQ)" > > > > > > > > <xiao-lei....@hp.com> > > > > > > > > Sent: Friday, March 21, 2014 10:42:33 AM > > > > > > > > Subject: Please help us to review our database schema design > > > > > > > > with > > > > > > > > NUMA feature on ovirt > > > > > > > > > > > > > > > > Hi Eli, > > > > > > > > > > > > > > > > Please help us to review our database schema design with NUMA > > > > > > > > feature on ovirt > > > > > > > > https://docs.google.com/document/d/1-wdDkm6EDbwyoCIRPPcmbGWAcyQo_IST > > > > > > > > Y8 > > > > > > > > ykDr0I6VY/edit?usp=sharing > > > > > > > > > > > > > > > > Feel free to take comments on document at anywhere > > > > > > > > > > > > > > Done, had commented on the document. > > > > > > > Eli > > > > > > > > > > > > > > > > > > > > > > > Especially, 5.4 The used interface between engine core and > > > > > > > > database(schema) > > > > > > > > > > > > > > > > Your approve and your comments with this section will be much > > > > > > > > more > > > > > > > > appreciate for us. > > > > > > > > > > > > > > > > Best Regards, > > > > > > > > Jason Liao > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > _______________________________________________ Engine-devel mailing list Engine-devel@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-devel