Bug 1024813 - [Performance] Search TestRuns without any criteria causes MySQL and Python interpreter occupies 100% CPU time.
Summary: [Performance] Search TestRuns without any criteria causes MySQL and Python in...
Keywords:
Status: VERIFIED
Alias: None
Product: TCMS
Classification: Other
Component: Application
Version: Devel
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
: ---
Assignee: Yuguang Wang
QA Contact: Nobody
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-10-30 13:24 UTC by cqi
Modified: 2023-10-20 16:24 UTC (History)
5 users (show)

Fixed In Version:
Doc Type: Enhancement
Doc Text:
Clone Of:
Environment:
Last Closed:
Embargoed:

Attachments (Terms of Use)

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
Note You need to log in before you can comment on or make changes to this bug.