Created attachment 822739 [details]
MySQL Server CPU used%

Description of problem:
TCMS Reporting(Overall, Custom,Testing Report) respond slowly and cause MySQL server high CPU usage

Version-Release number of selected component (if applicable):
V3.8.4

How reproducible:


Steps to Reproduce:

Set 1 virtual user, run 10 times to get the average processing time. Detail user scenarios:

1. From “REPORTING” menu, Click the “Product Name”
2. Click “Versions” to view the report sorted on product version
3. Click “Builds” to view the report sorted on product builds
4. Click “Component” to view the report
5. From the “REPORTING” tab, click “Custom”.
6. Enter the search details, click “Search”.
7. Click a record from the result
8. From the “REPORTING” tab, click “Testing Report”.
9. Select the product from the drop down box and either 1 or a range of versions,click “Generate Report”.
10. Select the product from the drop down box and either 1 or a range of versions,select "By Plan & Build",click “Generate Report”.


Actual results:
Page Name	                Page Elapsed Time(ms)  
--------------------------      --------------------
OR_Version	                47917
OR_ProductName	                22833
CR_Detail	                31919
TR_GenerateReport(byTester)	34004
TR_GenerateReport(byplan)	16248

Expected results:
less than 15 seconds

Additional info:
Test env:
Server	Function	OS	CPU	Memory	Software
dhcp-8-146.nay.redhat.com	DB Server	Red Hat Enterprise Linux Server release 6.3	1 CPU (4 Cores)	4G	MySQL 5.1.67
tcms-test.app.eng.nay.redhat.com	Web Server	Red Hat Enterprise Linux Server release 5.1	2VCPU	2GB	"Apache Http Server 2.2
Nitrate 3.8.5"
dhcp-8-145.nay.redhat.com	JMeter load generator	Red Hat Enterprise Linux Server release 6.3	1 CPU (8 Cores)	8G	JMeter 2.9