Re: [xcat-user] Severe performance problem in 2.12

[Long LA Cheng]

Hi Jarrod,

 

Do you encounter some problem with this line?

 

xCAT have two level cache for the site attribute, one is  XCATSITEVALS populated cache at current process ( site cache may inherit from the parent process), the other is the cache at DB process, I think there are not too many SQL queries can reach the DB side during a short time period. In addition, more operation may be updating during discovery, this line just affect the performance of query. Correct me if I am wrong.

 

Thanks.

 

Best Wishes

 

Long Cheng(程龙)

IBM Systems &Technology Group, Development

SOFTWARE ENGINEER

Tel:86-10-82453046

Email:cheng...@cn.ibm.com

Address: 3F, Building 28, Zhong Guan Cun Software Park, No.8, Dong Bei Wang West Road, Hai Dian District, Beijing 100193, PRC

地址：国际商业机器中国(投资)有限公司, 中国系统科技实验室, 北京市海淀区东北旺西譎号中关村软件号ộ层，邮编:100193

 

 

 

----- Original message -----
From: Er Tao Zhao/China/IBM@IBMCN
To: xcat-user@lists.sourceforge.net
Cc: xcat-user@lists.sourceforge.net
Subject: Re: [xcat-user] Severe performance problem in 2.12
Date: Wed, Oct 19, 2016 1:51 PM
 

Hi, Jarrod

 

The answer from Cheng long:

This is a feature request from customer to inherit postscripts from multiple groups, https://github.com/xcat2/xcat-core/issues/115. For the common usage we add this row in site table to indicate which attribute to apply from multiple groups.  

 

Thx!

Best Regards,
-----------------------------------
Zhao Er Tao

IBM China System and Technology Laboratory, Beijing
Tel:(86-10)82450485
Email: erta...@cn.ibm.com
Address: 1/F, 28 Building,ZhongGuanCun Software Park,
No.8 DongBeiWang West Road, Haidian District,
Beijing, 100193, P.R.China

 

 

----- Original message -----
From: Jarrod Johnson <jjohns...@lenovo.com>
To: "xCAT Users Mailing list (xcat-user@lists.sourceforge.net)" <xcat-user@lists.sourceforge.net>
Cc:
Subject: [xcat-user] Severe performance problem in 2.12
Date: Tue, Oct 18, 2016 10:27 PM
 

I haven’t yet dug in to understand the intent, but:

    my $hierarchy_field = xCAT::TableUtils->get_site_attribute("hierarchicalattrs");

 

That line in Table.pm is causing tremendous slowdown, particularly around discovery.  When a process does not have XCATSITEVALS populated, this causes an unmanageable number of SQLQ queries.

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot

_______________________________________________
xCAT-user mailing list
xCAT-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/xcat-user

 

 

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot

_______________________________________________
xCAT-user mailing list
xCAT-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/xcat-user

 

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most 
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
xCAT-user mailing list
xCAT-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/xcat-user