Bug 1024813

Summary:	[Performance] Search TestRuns without any criteria causes MySQL and Python interpreter occupies 100% CPU time.
Product:	[Other] TCMS	Reporter:	cqi
Component:	Application	Assignee:	Yuguang Wang <yuwang>
Status:	VERIFIED ---	QA Contact:	Nobody <nobody>
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	Devel	CC:	cqi, junzhang, jzhao, ryang, vchen, zxiong
Target Milestone:	---	Keywords:	Improvement, Performance
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Enhancement
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:		Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:

Description cqi 2013-10-30 13:24:08 UTC

Same situation with Bug 1018021

Without any criterias, query TestRuns should not occupy 100% CPU time to handle this. This will affect normal operations coming from other users seriously.

Comment 1 yangqiu 2014-09-29 07:34:06 UTC

the average response time for search runs is 8.26s
performance test report:
https://docs.engineering.redhat.com/x/IpC0AQ