cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Wei Zhou (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (CLOUDSTACK-2707) Usage server creates entries very slow for mysql performance degradation
Date Tue, 11 Jun 2013 06:50:20 GMT

     [ https://issues.apache.org/jira/browse/CLOUDSTACK-2707?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Wei Zhou closed CLOUDSTACK-2707.
--------------------------------

    
> Usage server creates entries very slow for mysql performance degradation
> ------------------------------------------------------------------------
>
>                 Key: CLOUDSTACK-2707
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-2707
>             Project: CloudStack
>          Issue Type: Improvement
>      Security Level: Public(Anyone can view this level - this is the default.) 
>            Reporter: Wei Zhou
>            Assignee: Wei Zhou
>
> As we know, the insert performance into a mysql table degrades when the records of table
reaches 1,000,000. It takes more time and more CPU utilization.
> Here is log in usage.log
> 2013-05-27 09:13:24,827 INFO  [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) starting
usage job...
> 2013-05-27 09:13:24,829 INFO  [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) Parsing
usage records between Mon May 27 11:10:05 CEST 2013 and Mon May 27 11:13:24 CEST 2013
> 2013-05-27 09:13:25,534 DEBUG [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) getting
current accounted bytes for... accountId: 2 in zone: 1; abr: 1252; abs: 847
> 2013-05-27 09:13:25,534 DEBUG [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) creating
networkHelperEntry... accountId: 2 in zone: 1; abr: 1252; abs: 847; curABS: 847; curABR: 1252;
ubs: 0; ubr: 0
> 2013-05-27 09:13:26,467 DEBUG [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) getting
current accounted bytes for... accountId: 2 in zone: 1; abr: 16112; abs: 16112
> 2013-05-27 09:13:26,468 DEBUG [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) creating
networkHelperEntry... accountId: 2 in zone: 1; abr: 16112; abs: 16112; curABS: 16112; curABR:
16112; ubs: 0; ubr: 0
> 2013-05-27 09:13:28,220 DEBUG [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) getting
current accounted bytes for... accountId: 2 in zone: 1; abr: 0; abs: 0
> 2013-05-27 09:13:28,220 DEBUG [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) creating
networkHelperEntry... accountId: 2 in zone: 1; abr: 0; abs: 0; curABS: 0; curABR: 0; ubs:
0; ubr: 0
> 2013-05-27 09:13:29,266 DEBUG [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) getting
current accounted bytes for... accountId: 2 in zone: 1; abr: 3648; abs: 3648
> 2013-05-27 09:13:29,266 DEBUG [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) creating
networkHelperEntry... accountId: 2 in zone: 1; abr: 3648; abs: 3648; curABS: 3648; curABR:
3648; ubs: 0; ubr: 0
> 2013-05-27 09:13:30,339 DEBUG [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) getting
current accounted bytes for... accountId: 2 in zone: 1; abr: 32984; abs: 32984
> 2013-05-27 09:13:30,339 DEBUG [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) creating
networkHelperEntry... accountId: 2 in zone: 1; abr: 32984; abs: 32984; curABS: 32984; curABR:
32984; ubs: 0; ubr: 0
> 2013-05-27 09:13:31,830 DEBUG [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) getting
current accounted bytes for... accountId: 2 in zone: 1; abr: 118636; abs: 118940
> ......
> 2013-05-27 09:16:08,285 DEBUG [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) getting
current accounted bytes for... accountId: 2 in zone: 1; abr: 0; abs: 0
> 2013-05-27 09:16:08,285 DEBUG [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) creating
networkHelperEntry... accountId: 2 in zone: 1; abr: 0; abs: 0; curABS: 0; curABR: 0; ubs:
0; ubr: 0
> 2013-05-27 09:16:09,308 DEBUG [cloud.usage.UsageManagerImpl] (Usage-Job-1:null) created
network stats helper entries for 134 accts

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message