[
https://issues.apache.org/jira/browse/CLOUDSTACK-1496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sowmya Krishnan closed CLOUDSTACK-1496.
---------------------------------------
Resolution: Fixed
> List API Performance: listAccounts failing with OOME for high values of
> pagesize (>1000 )
> -----------------------------------------------------------------------------------------
>
> Key: CLOUDSTACK-1496
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-1496
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: API
> Affects Versions: 4.1.0
> Environment: CentOS release 6.3
> Reporter: Sowmya Krishnan
> Assignee: Min Chen
> Fix For: 4.1.0
>
>
> listAccounts with higher values of pagesize is resulting in OOME and in
> general, showing low performance for smaller page size values too.
> Configuration for the performance set up is as follows:
> (Using simulator set up)
> (Advanced zone)
> Accounts: 2117
> Hosts: 1986
> Users: 2116
> Virtual machines: 3299
> Server configurations:
> Management Server :
> =================
> 8 proc Intel(R) Xeon(R) CPU E5620 @ 2.40GHz processor
> CentOS release 6.3 (Final)
> Database:
> ========
> 8 proc Intel(R) Xeon(R) CPU E5620 @ 2.40GHz processor
> Red Hat Enterprise Linux Server release 6.2 (Santiago)
> MySQL-server-5.5.21-1.linux2.6.x86_64 (InnoDB engine)
> Following are the results for listAccounts for various pagesize values:
> ======================================================
> (APIs are fired on 8080 as admin from a different client than the MS)
> pagesize=10 : 0m30.944s
> pagesize=50: 1m57.292s
> pagesize=100: 2m59.700s
> pagesize=500: 12m22.807s
> In comparison to the results before API Optimization, for pagesize=100, the
> response was received within 62 seconds before optimization whereas now, the
> result is 149 seconds
> One difference though, is that the performance run before API optimization
> was done on a DB server with much higher configuration (Quad core, 8
> processor). But still, we shouldn't be seeing OOME.
> Following is the extract of the result for listAccounts&listAll=true (# of
> accounts: 2117)
> ...
> <title>Error 500 Java heap space</title> </head> <body><h2>HTTP ERROR
> 500</h2> <p>Problem accessing /client/api. Reason: <pre> Java heap
> space</pre></p><h3>Caused by:</h3><pre>java.lang.OutOfMemoryError: Java heap
> space </pre> <hr /><i><small>Powered by Jetty://</small>
> Maven Settings:
> ============
> [root@centos63 ~]# echo $MAVEN_OPTS
> -Xmx5120m -XX:MaxPermSize=1024m -Xdebug
> -Xrunjdwp:transport=dt_socket,address=8787,server=y,suspend=n
--
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
