[ https://issues.apache.org/jira/browse/CLOUDSTACK-1496?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13592377#comment-13592377 ]
Min Chen commented on CLOUDSTACK-1496: -------------------------------------- Is this run using the build with Kelven's MS memory fix or not? > 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