Bug 1018021

Summary: [Performance] Search TestPlan without any criteria causes MySQL occurpies nearly 100% CPU time.
Product: [Other] TCMS Reporter: cqi
Component: ApplicationAssignee: cqi
Status: VERIFIED --- QA Contact: Nobody <nobody>
Severity: medium Docs Contact:
Priority: medium    
Version: DevelCC: cqi, junzhang, ryang, vchen, zxiong
Target Milestone: ---Keywords: Performance, Task
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: 3.8.5 Doc Type: Bug Fix
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-11 02:40:42 UTC
Description of problem:

We can imagine once someone sends this kind of query, TCMS will slow down seriously and cannot serve to other users normally.