http://git-wip-us.apache.org/repos/asf/incubator-geode/blob/86850fec/pulse/src/test/java/com/vmware/gemfire/tools/pulse/tests/Server.java ---------------------------------------------------------------------- diff --git a/pulse/src/test/java/com/vmware/gemfire/tools/pulse/tests/Server.java b/pulse/src/test/java/com/vmware/gemfire/tools/pulse/tests/Server.java index 42373c9..02f6be2 100644 --- a/pulse/src/test/java/com/vmware/gemfire/tools/pulse/tests/Server.java +++ b/pulse/src/test/java/com/vmware/gemfire/tools/pulse/tests/Server.java @@ -7,6 +7,8 @@ */ package com.vmware.gemfire.tools.pulse.tests; +import com.vmware.gemfire.tools.pulse.internal.data.PulseConstants; + import java.io.IOException; import java.net.Inet4Address; import java.net.Inet6Address; @@ -110,24 +112,6 @@ public class Server { } } - // Add GemFireXD Cluster - String[] gemFireXDClusters = getArrayProperty(props, "gemfirexdclusters"); - for (String xdCluster : gemFireXDClusters) { - try { - addGemFireXDClusterMbean(xdCluster); - } catch (InstanceAlreadyExistsException e) { - e.printStackTrace(); - } catch (MBeanRegistrationException e) { - e.printStackTrace(); - } catch (NotCompliantMBeanException e) { - e.printStackTrace(); - } catch (MalformedObjectNameException e) { - e.printStackTrace(); - } catch (NullPointerException e) { - e.printStackTrace(); - } - } - // Add members String[] members = getArrayProperty(props, "members"); for (String m : members) { @@ -146,24 +130,6 @@ public class Server { } } - // Add GemFireXD members - String[] gemfirexdmember = getArrayProperty(props, "gemfirexdmembers"); - for (String xdm : gemfirexdmember) { - try { - addGemFireXDMemberMBean(xdm); - } catch (InstanceAlreadyExistsException e) { - e.printStackTrace(); - } catch (MBeanRegistrationException e) { - e.printStackTrace(); - } catch (NotCompliantMBeanException e) { - e.printStackTrace(); - } catch (MalformedObjectNameException e) { - e.printStackTrace(); - } catch (NullPointerException e) { - e.printStackTrace(); - } - } - // Add regions String[] regions = getArrayProperty(props, "regions"); for (String reg : regions) { @@ -181,45 +147,6 @@ public class Server { e.printStackTrace(); } } - - // Add GemFireXD Aggregate Tables - String[] aggTables = getArrayProperty(props, "tables"); - for (String aggTable : aggTables) { - try { - addGemFireXDAggregateTableMBean(aggTable); - } catch (InstanceAlreadyExistsException e) { - e.printStackTrace(); - } catch (MBeanRegistrationException e) { - e.printStackTrace(); - } catch (NotCompliantMBeanException e) { - e.printStackTrace(); - } catch (MalformedObjectNameException e) { - e.printStackTrace(); - } catch (NullPointerException e) { - e.printStackTrace(); - } - } - - // Add aggregate queries - System.out.println("loading aggregate queries mbeans ..."); - String[] aggregatequeries = getArrayProperty(props, "aggregatequeries"); - for (String aggregateq : aggregatequeries) { - try { - System.out.println("adding mbean .. " + aggregateq); - addAggregateQueryMBean(aggregateq); - } catch (InstanceAlreadyExistsException e) { - e.printStackTrace(); - } catch (MBeanRegistrationException e) { - e.printStackTrace(); - } catch (NotCompliantMBeanException e) { - e.printStackTrace(); - } catch (MalformedObjectNameException e) { - e.printStackTrace(); - } catch (NullPointerException e) { - e.printStackTrace(); - } - } - System.out.println("Finished registering # mbeans .. " + aggregatequeries.length); } private void addMemberMBean(String m) throws InstanceAlreadyExistsException, @@ -245,27 +172,14 @@ public class Server { NullPointerException { Region regionObject = new Region(reg); mbs.registerMBean(regionObject, new ObjectName(Region.OBJECT_NAME + ",name=/" + reg)); - System.out.println("Region Full path : " + regionObject.getFullPath()); for (String member : regionObject.getMembers()) { - System.out.println("Adding Region on Member MBean for Region: " + reg + ", Member: " + member); - RegionOnMember regionOnMemberObject = new RegionOnMember(regionObject.getFullPath()); + RegionOnMember regionOnMemberObject = new RegionOnMember(regionObject.getFullPath(), member); mbs.registerMBean(regionOnMemberObject, new ObjectName( - "GemFire:service=Region,name=/"+ regionObject.getFullPath() + ",type=Member,member=" + member)); - System.out.println("Region on member properties retrieved : entryCount=" + regionOnMemberObject.getEntryCount() +",entrySize=" - + regionOnMemberObject.getEntrySize() + ",localMaxMemory=" +regionOnMemberObject.getLocalMaxMemory()); + PulseConstants.OBJECT_NAME_REGION_ON_MEMBER_REGION + regionObject.getFullPath() + PulseConstants.OBJECT_NAME_REGION_ON_MEMBER_MEMBER + member)); } } - // For GemFire XD - private void addGemFireXDAggregateTableMBean(String aggTable) - throws InstanceAlreadyExistsException, MBeanRegistrationException, - NotCompliantMBeanException, MalformedObjectNameException, - NullPointerException { - GemFireXDAggregateTable tableObject = new GemFireXDAggregateTable(aggTable); - mbs.registerMBean(tableObject, new ObjectName(GemFireXDAggregateTable.OBJECT_NAME + aggTable)); - } - private void addServerMBean(String server) throws InstanceAlreadyExistsException, MBeanRegistrationException, NotCompliantMBeanException, MalformedObjectNameException, @@ -274,26 +188,6 @@ public class Server { mbs.registerMBean(so, new ObjectName(ServerObject.OBJECT_NAME)); } - // For GemFire XD - private void addGemFireXDClusterMbean(String cluster) - throws InstanceAlreadyExistsException, MBeanRegistrationException, - NotCompliantMBeanException, MalformedObjectNameException, - NullPointerException { - GemFireXDCluster xdco = new GemFireXDCluster(cluster); - mbs.registerMBean(xdco, new ObjectName(GemFireXDCluster.OBJECT_NAME)); - } - - private void addAggregateQueryMBean(String aggregateq) - throws InstanceAlreadyExistsException, MBeanRegistrationException, - NotCompliantMBeanException, MalformedObjectNameException, - NullPointerException { - AggregateStatement aggregatestatement = new AggregateStatement(aggregateq); - System.out.println("created statement mbean ..." + aggregatestatement + ", query defn = " + ObjectName.quote(aggregatestatement.getQueryDefinition())); - System.out.println("qnRespDeSerTime ...qnRespDeSerTime = " + aggregatestatement.getQNRespDeSerTime()); - Object returnObj = mbs.registerMBean(aggregatestatement, new ObjectName(AggregateStatementMBean.OBJECT_NAME + ",name=" + ObjectName.quote(aggregatestatement.getQueryDefinition()))); - System.out.println("registered mbean ..." + returnObj ); - } - private String[] getArrayProperty(JMXProperties props, String propName) { String propVal = props.getProperty(propName, ""); return propVal.split(" "); @@ -302,7 +196,7 @@ public class Server { private void unregisterAll() { Set<ObjectName> thisSet = mbs.queryNames(null, null); for (ObjectName objectName : thisSet) { - System.out.println("Removing ..." + objectName.getCanonicalName()); +// System.out.println("Removing ..." + objectName.getCanonicalName()); /*try { mbs.unregisterMBean(objectName);
http://git-wip-us.apache.org/repos/asf/incubator-geode/blob/86850fec/pulse/src/test/resources/test.properties ---------------------------------------------------------------------- diff --git a/pulse/src/test/resources/test.properties b/pulse/src/test/resources/test.properties index 42f9792..60d3c3f 100644 --- a/pulse/src/test/resources/test.properties +++ b/pulse/src/test/resources/test.properties @@ -38,7 +38,7 @@ gemfirexd.C1.ProcedureCallsInProgress=13 gemfirexd.C1.NetworkServerClientConnectionStats=13,1,5,4 member.M1.manager=true -member.M1.totalRegionCount=2 +member.M1.totalRegionCount=3 member.M1.locator=false member.M1.totalDiskUsage=199302 member.M1.server=false @@ -72,7 +72,7 @@ gemfirexdmember.M1.DataStore=true gemfirexdmember.M1.NetworkServerClientConnectionStats=10,3,5,2 member.M2.manager=false -member.M2.totalRegionCount=2 +member.M2.totalRegionCount=3 member.M2.locator=true member.M2.totalDiskUsage=199302 member.M2.server=false @@ -168,35 +168,41 @@ region.R1.diskUsage=200200 region.R1.listRegionAttributes=comp-Codec,true,true,local,TestDiskStoreLcl,false -regionOnMember./R1.fullPath=/R1 -regionOnMember./R1.memberName=M1 -regionOnMember./R1.entrySize=21 -regionOnMember./R1.entryCount=26 -regionOnMember./R1.getsRate=10.50 -regionOnMember./R1.putsRate=20.33 -regionOnMember./R1.diskGetsRate=23.44 -regionOnMember./R1.diskPutsRate=30.22 -regionOnMember./R1.localMaxMemory=0 - -regionOnMember./R1.fullPath=/R1 -regionOnMember./R1.memberName=M2 -regionOnMember./R1.entrySize=215 -regionOnMember./R1.entryCount=30 -regionOnMember./R1.getsRate=15.50 -regionOnMember./R1.putsRate=25.33 -regionOnMember./R1.diskGetsRate=33.44 -regionOnMember./R1.diskPutsRate=55.22 -regionOnMember./R1.localMaxMemory=10 - -regionOnMember./R1.fullPath=/R1 -regionOnMember./R1.memberName=M3 -regionOnMember./R1.entrySize=28 -regionOnMember./R1.entryCount=70 -regionOnMember./R1.getsRate=19.50 -regionOnMember./R1.putsRate=21.33 -regionOnMember./R1.diskGetsRate=20.44 -regionOnMember./R1.diskPutsRate=32.22 -regionOnMember./R1.localMaxMemory=0 +regionOnMember./R1.M1.fullPath=/R1 +regionOnMember./R1.M1.memberName=M1 +regionOnMember./R1.M1.name=/R1 +regionOnMember./R1.M1.regionType=PERSISTENT +regionOnMember./R1.M1.entrySize=21 +regionOnMember./R1.M1.entryCount=26 +regionOnMember./R1.M1.getsRate=10.50 +regionOnMember./R1.M1.putsRate=20.33 +regionOnMember./R1.M1.diskGetsRate=23.44 +regionOnMember./R1.M1.diskPutsRate=30.22 +regionOnMember./R1.M1.localMaxMemory=0 + +regionOnMember./R1.M2.fullPath=/R1 +regionOnMember./R1.M2.memberName=M2 +regionOnMember./R1.M2.name=/R1 +regionOnMember./R1.M2.regionType=PERSISTENT +regionOnMember./R1.M2.entrySize=215 +regionOnMember./R1.M2.entryCount=30 +regionOnMember./R1.M2.getsRate=15.50 +regionOnMember./R1.M2.putsRate=25.33 +regionOnMember./R1.M2.diskGetsRate=33.44 +regionOnMember./R1.M2.diskPutsRate=55.22 +regionOnMember./R1.M2.localMaxMemory=10 + +regionOnMember./R1.M3.fullPath=/R1 +regionOnMember./R1.M3.memberName=M3 +regionOnMember./R1.M3.name=/R1 +regionOnMember./R1.M3.regionType=PERSISTENT +regionOnMember./R1.M3.entrySize=28 +regionOnMember./R1.M3.entryCount=70 +regionOnMember./R1.M3.getsRate=19.50 +regionOnMember./R1.M3.putsRate=21.33 +regionOnMember./R1.M3.diskGetsRate=20.44 +regionOnMember./R1.M3.diskPutsRate=32.22 +regionOnMember./R1.M3.localMaxMemory=0 table.R2.EntrySize=4321 @@ -227,25 +233,29 @@ region.R2.diskUsage=200200 # String scope, String diskStoreName, boolean diskSynchronous region.R2.listRegionAttributes=comp-Codec,true,false,global,TestDiskStoreGbl,true -regionOnMember./R2.fullPath=/R2 -regionOnMember./R2.memberName=M1 -regionOnMember./R2.entrySize=21 -regionOnMember./R2.entryCount=26 -regionOnMember./R2.getsRate=10.50 -regionOnMember./R2.putsRate=20.33 -regionOnMember./R2.diskGetsRate=23.44 -regionOnMember./R2.diskPutsRate=30.22 -regionOnMember./R2.localMaxMemory=0 - -regionOnMember./R2.fullPath=/R2 -regionOnMember./R2.memberName=M2 -regionOnMember./R2.entrySize=215 -regionOnMember./R2.entryCount=30 -regionOnMember./R2.getsRate=15.50 -regionOnMember./R2.putsRate=25.33 -regionOnMember./R2.diskGetsRate=33.44 -regionOnMember./R2.diskPutsRate=55.22 -regionOnMember./R2.localMaxMemory=10 +regionOnMember./R2.M1.fullPath=/R2 +regionOnMember./R2.M1.memberName=M1 +regionOnMember./R2.M1.name=/R2 +regionOnMember./R2.M1.regionType=REPLICATED +regionOnMember./R2.M1.entrySize=21 +regionOnMember./R2.M1.entryCount=26 +regionOnMember./R2.M1.getsRate=10.50 +regionOnMember./R2.M1.putsRate=20.33 +regionOnMember./R2.M1.diskGetsRate=23.44 +regionOnMember./R2.M1.diskPutsRate=30.22 +regionOnMember./R2.M1.localMaxMemory=0 + +regionOnMember./R2.M2.fullPath=/R2 +regionOnMember./R2.M2.memberName=M2 +regionOnMember./R2.M2.name=/R2 +regionOnMember./R2.M2.regionType=REPLICATED +regionOnMember./R2.M2.entrySize=215 +regionOnMember./R2.M2.entryCount=30 +regionOnMember./R2.M2.getsRate=15.50 +regionOnMember./R2.M2.putsRate=25.33 +regionOnMember./R2.M2.diskGetsRate=33.44 +regionOnMember./R2.M2.diskPutsRate=55.22 +regionOnMember./R2.M2.localMaxMemory=10 region.R3.members=M1 M2 region.R3.fullPath=/R3 @@ -272,572 +282,26 @@ region.R3.diskUsage=200200 # String scope, String diskStoreName, boolean diskSynchronous region.R3.listRegionAttributes=comp-Codec,true,true,local,TestDiskStoreLcl,false -regionOnMember./R3.fullPath=/R3 -regionOnMember./R3.memberName=M1 -regionOnMember./R3.entrySize=21 -regionOnMember./R3.entryCount=26 -regionOnMember./R3.getsRate=10.50 -regionOnMember./R3.putsRate=20.33 -regionOnMember./R3.diskGetsRate=23.44 -regionOnMember./R3.diskPutsRate=30.22 -regionOnMember./R3.localMaxMemory=20 - -regionOnMember./R3.fullPath=/R3 -regionOnMember./R3.memberName=M2 -regionOnMember./R3.entrySize=215 -regionOnMember./R3.entryCount=30 -regionOnMember./R3.getsRate=18.6 -regionOnMember./R3.putsRate=45.33 -regionOnMember./R3.diskGetsRate=38.44 -regionOnMember./R3.diskPutsRate=50.22 -regionOnMember./R3.localMaxMemory=10 - -aggregatestatement.Q1.name=Q1 -aggregatestatement.Q1.queryDefinition=select * from clients; -aggregatestatement.Q1.numTimesCompiled=10 -aggregatestatement.Q1.numExecution=25 -aggregatestatement.Q1.numExecutionsInProgress=2 -aggregatestatement.Q1.numTimesGlobalIndexLookup=1 -aggregatestatement.Q1.numRowsModified=100 -aggregatestatement.Q1.parseTime=600 -aggregatestatement.Q1.bindTime=250 -aggregatestatement.Q1.optimizeTime=590 -aggregatestatement.Q1.routingInfoTime=100 -aggregatestatement.Q1.generateTime=380 -aggregatestatement.Q1.totalCompilationTime=400 -aggregatestatement.Q1.executionTime=20 -aggregatestatement.Q1.projectionTime=80 -aggregatestatement.Q1.totalExecutionTime=3000 -aggregatestatement.Q1.rowsModificationTime=1200 -aggregatestatement.Q1.qnNumRowsSeen=230 -aggregatestatement.Q1.qnMsgSendTime=370 -aggregatestatement.Q1.qnMsgSerTime=540 -aggregatestatement.Q1.qnRespDeSerTime=450 - -aggregatestatement.Q2.name=Q2 -aggregatestatement.Q2.queryDefinition=select member name, member type from members where cluster id = id; -aggregatestatement.Q2.numTimesCompiled=24 -aggregatestatement.Q2.numExecution=30 -aggregatestatement.Q2.numExecutionsInProgress=1 -aggregatestatement.Q2.numTimesGlobalIndexLookup=2 -aggregatestatement.Q2.numRowsModified=120 -aggregatestatement.Q2.parseTime=700 -aggregatestatement.Q2.bindTime=260 -aggregatestatement.Q2.optimizeTime=580 -aggregatestatement.Q2.routingInfoTime=110 -aggregatestatement.Q2.generateTime=370 -aggregatestatement.Q2.totalCompilationTime=410 -aggregatestatement.Q2.executionTime=20 -aggregatestatement.Q2.projectionTime=80 -aggregatestatement.Q2.totalExecutionTime=3000 -aggregatestatement.Q2.rowsModificationTime=1100 -aggregatestatement.Q2.qnNumRowsSeen=700 -aggregatestatement.Q2.qnMsgSendTime=380 -aggregatestatement.Q2.qnMsgSerTime=530 -aggregatestatement.Q2.qnRespDeSerTime=450 - -aggregatestatement.Q3.name=Q3 -aggregatestatement.Q3.queryDefinition=select region name, member name from regions where entrycount = 20; -aggregatestatement.Q3.numTimesCompiled=13 -aggregatestatement.Q3.numExecution=12 -aggregatestatement.Q3.numExecutionsInProgress=6 -aggregatestatement.Q3.numTimesGlobalIndexLookup=3 -aggregatestatement.Q3.numRowsModified=110 -aggregatestatement.Q3.parseTime=800 -aggregatestatement.Q3.bindTime=270 -aggregatestatement.Q3.optimizeTime=570 -aggregatestatement.Q3.routingInfoTime=120 -aggregatestatement.Q3.generateTime=370 -aggregatestatement.Q3.totalCompilationTime=450 -aggregatestatement.Q3.executionTime=20 -aggregatestatement.Q3.projectionTime=80 -aggregatestatement.Q3.totalExecutionTime=3500 -aggregatestatement.Q3.rowsModificationTime=1300 -aggregatestatement.Q3.qnNumRowsSeen=3000 -aggregatestatement.Q3.qnMsgSendTime=350 -aggregatestatement.Q3.qnMsgSerTime=520 -aggregatestatement.Q3.qnRespDeSerTime=-89 - -aggregatestatement.Q4.name=Q4 -aggregatestatement.Q4.queryDefinition=select * from members -aggregatestatement.Q4.numTimesCompiled=70 -aggregatestatement.Q4.numExecution=60 -aggregatestatement.Q4.numExecutionsInProgress=0 -aggregatestatement.Q4.numTimesGlobalIndexLookup=4 -aggregatestatement.Q4.numRowsModified=10 -aggregatestatement.Q4.parseTime=900 -aggregatestatement.Q4.bindTime=280 -aggregatestatement.Q4.optimizeTime=560 -aggregatestatement.Q4.routingInfoTime=130 -aggregatestatement.Q4.generateTime=370 -aggregatestatement.Q4.totalCompilationTime=450 -aggregatestatement.Q4.executionTime=20 -aggregatestatement.Q4.projectionTime=80 -aggregatestatement.Q4.totalExecutionTime=5670 -aggregatestatement.Q4.rowsModificationTime=1400 -aggregatestatement.Q4.qnNumRowsSeen=910 -aggregatestatement.Q4.qnMsgSendTime=330 -aggregatestatement.Q4.qnMsgSerTime=510 -aggregatestatement.Q4.qnRespDeSerTime=60 - -aggregatestatement.Q5.name=Q5 -aggregatestatement.Q5.queryDefinition=select region name, member name from regions where entrycount > 100; -aggregatestatement.Q5.numTimesCompiled=1 -aggregatestatement.Q5.numExecution=34 -aggregatestatement.Q5.numExecutionsInProgress=3 -aggregatestatement.Q5.numTimesGlobalIndexLookup=5 -aggregatestatement.Q5.numRowsModified=1 -aggregatestatement.Q5.parseTime=1000 -aggregatestatement.Q5.bindTime=290 -aggregatestatement.Q5.optimizeTime=550 -aggregatestatement.Q5.routingInfoTime=130 -aggregatestatement.Q5.generateTime=360 -aggregatestatement.Q5.totalCompilationTime=450 -aggregatestatement.Q5.executionTime=20 -aggregatestatement.Q5.projectionTime=80 -aggregatestatement.Q5.totalExecutionTime=5080 -aggregatestatement.Q5.rowsModificationTime=1500 -aggregatestatement.Q5.qnNumRowsSeen=9 -aggregatestatement.Q5.qnMsgSendTime=300 -aggregatestatement.Q5.qnMsgSerTime=500 -aggregatestatement.Q5.qnRespDeSerTime=98 - -aggregatestatement.Q6.name=Q6 -aggregatestatement.Q6.queryDefinition=select region name from regions where regionid in ( select * from region id where entry count <= 700); -aggregatestatement.Q6.numTimesCompiled=90 -aggregatestatement.Q6.numExecution=1 -aggregatestatement.Q6.numExecutionsInProgress=10 -aggregatestatement.Q6.numTimesGlobalIndexLookup=6 -aggregatestatement.Q6.numRowsModified=25 -aggregatestatement.Q6.parseTime=1100 -aggregatestatement.Q6.bindTime=300 -aggregatestatement.Q6.optimizeTime=540 -aggregatestatement.Q6.routingInfoTime=130 -aggregatestatement.Q6.generateTime=350 -aggregatestatement.Q6.totalCompilationTime=470 -aggregatestatement.Q6.executionTime=20 -aggregatestatement.Q6.projectionTime=80 -aggregatestatement.Q6.totalExecutionTime=5000 -aggregatestatement.Q6.rowsModificationTime=1600 -aggregatestatement.Q6.qnNumRowsSeen=900 -aggregatestatement.Q6.qnMsgSendTime=320 -aggregatestatement.Q6.qnMsgSerTime=490 -aggregatestatement.Q6.qnRespDeSerTime=76 - -aggregatestatement.Q7.name=Q7 -aggregatestatement.Q7.queryDefinition=select region name, member name from regions where entrycount < 25; -aggregatestatement.Q7.numTimesCompiled=15 -aggregatestatement.Q7.numExecution=30 -aggregatestatement.Q7.numExecutionsInProgress=20 -aggregatestatement.Q7.numTimesGlobalIndexLookup=7 -aggregatestatement.Q7.numRowsModified=35 -aggregatestatement.Q7.parseTime=1200 -aggregatestatement.Q7.bindTime=300 -aggregatestatement.Q7.optimizeTime=530 -aggregatestatement.Q7.routingInfoTime=140 -aggregatestatement.Q7.generateTime=340 -aggregatestatement.Q7.totalCompilationTime=470 -aggregatestatement.Q7.executionTime=20 -aggregatestatement.Q7.projectionTime=80 -aggregatestatement.Q7.totalExecutionTime=6050 -aggregatestatement.Q7.rowsModificationTime=1700 -aggregatestatement.Q7.qnNumRowsSeen=140 -aggregatestatement.Q7.qnMsgSendTime=370 -aggregatestatement.Q7.qnMsgSerTime=480 -aggregatestatement.Q7.qnRespDeSerTime=40 - -aggregatestatement.Q8.name=Q8 -aggregatestatement.Q8.queryDefinition=select cluster name from clustertoplogy where membercount > 5000; -aggregatestatement.Q8.numTimesCompiled=35 -aggregatestatement.Q8.numExecution=25 -aggregatestatement.Q8.numExecutionsInProgress=4 -aggregatestatement.Q8.numTimesGlobalIndexLookup=8 -aggregatestatement.Q8.numRowsModified=40 -aggregatestatement.Q8.parseTime=1300 -aggregatestatement.Q8.bindTime=350 -aggregatestatement.Q8.optimizeTime=520 -aggregatestatement.Q8.routingInfoTime=160 -aggregatestatement.Q8.generateTime=330 -aggregatestatement.Q8.totalCompilationTime=470 -aggregatestatement.Q8.executionTime=20 -aggregatestatement.Q8.projectionTime=80 -aggregatestatement.Q8.totalExecutionTime=6080 -aggregatestatement.Q8.rowsModificationTime=1800 -aggregatestatement.Q8.qnNumRowsSeen=130 -aggregatestatement.Q8.qnMsgSendTime=390 -aggregatestatement.Q8.qnMsgSerTime=470 -aggregatestatement.Q8.qnRespDeSerTime=450 - -aggregatestatement.Q9.name=Q9 -aggregatestatement.Q9.queryDefinition=select * from clients where member memory is not null -aggregatestatement.Q9.numTimesCompiled=65 -aggregatestatement.Q9.numExecution=25 -aggregatestatement.Q9.numExecutionsInProgress=9 -aggregatestatement.Q9.numTimesGlobalIndexLookup=9 -aggregatestatement.Q9.numRowsModified=21 -aggregatestatement.Q9.parseTime=1440 -aggregatestatement.Q9.bindTime=360 -aggregatestatement.Q9.optimizeTime=510 -aggregatestatement.Q9.routingInfoTime=170 -aggregatestatement.Q9.generateTime=320 -aggregatestatement.Q9.totalCompilationTime=470 -aggregatestatement.Q9.executionTime=20 -aggregatestatement.Q9.projectionTime=80 -aggregatestatement.Q9.totalExecutionTime=6006 -aggregatestatement.Q9.rowsModificationTime=1900 -aggregatestatement.Q9.qnNumRowsSeen=110 -aggregatestatement.Q9.qnMsgSendTime=310 -aggregatestatement.Q9.qnMsgSerTime=460 -aggregatestatement.Q9.qnRespDeSerTime=450 - -aggregatestatement.Q10.name=Q22 -aggregatestatement.Q10.queryDefinition=select name from clients where member='Client35'; -aggregatestatement.Q10.numTimesCompiled=11 -aggregatestatement.Q10.numExecution=70 -aggregatestatement.Q10.numExecutionsInProgress=5 -aggregatestatement.Q10.numTimesGlobalIndexLookup=10 -aggregatestatement.Q10.numRowsModified=64 -aggregatestatement.Q10.parseTime=1500 -aggregatestatement.Q10.bindTime=370 -aggregatestatement.Q10.optimizeTime=500 -aggregatestatement.Q10.routingInfoTime=190 -aggregatestatement.Q10.generateTime=300 -aggregatestatement.Q10.totalCompilationTime=500 -aggregatestatement.Q10.executionTime=20 -aggregatestatement.Q10.projectionTime=210 -aggregatestatement.Q10.totalExecutionTime=600 -aggregatestatement.Q10.rowsModificationTime=2000 -aggregatestatement.Q10.qnNumRowsSeen=100 -aggregatestatement.Q10.qnMsgSendTime=312 -aggregatestatement.Q10.qnMsgSerTime=450 -aggregatestatement.Q10.qnRespDeSerTime=150 - -aggregatestatement.Q11.name=Q11 -aggregatestatement.Q11.queryDefinition=select name from clients where member='C1'; -aggregatestatement.Q11.numTimesCompiled=11 -aggregatestatement.Q11.numExecution=70 -aggregatestatement.Q11.numExecutionsInProgress=5 -aggregatestatement.Q11.numTimesGlobalIndexLookup=10 -aggregatestatement.Q11.numRowsModified=64 -aggregatestatement.Q11.parseTime=1500 -aggregatestatement.Q11.bindTime=370 -aggregatestatement.Q11.optimizeTime=500 -aggregatestatement.Q11.routingInfoTime=190 -aggregatestatement.Q11.generateTime=300 -aggregatestatement.Q11.totalCompilationTime=500 -aggregatestatement.Q11.executionTime=20 -aggregatestatement.Q11.projectionTime=210 -aggregatestatement.Q11.totalExecutionTime=600 -aggregatestatement.Q11.rowsModificationTime=2000 -aggregatestatement.Q11.qnNumRowsSeen=100 -aggregatestatement.Q11.qnMsgSendTime=312 -aggregatestatement.Q11.qnMsgSerTime=450 -aggregatestatement.Q11.qnRespDeSerTime=4 - -aggregatestatement.Q12.name=Q12 -aggregatestatement.Q12.queryDefinition=select name from clients where member='C16'; -aggregatestatement.Q12.numTimesCompiled=11 -aggregatestatement.Q12.numExecution=70 -aggregatestatement.Q12.numExecutionsInProgress=5 -aggregatestatement.Q12.numTimesGlobalIndexLookup=10 -aggregatestatement.Q12.numRowsModified=64 -aggregatestatement.Q12.parseTime=1500 -aggregatestatement.Q12.bindTime=370 -aggregatestatement.Q12.optimizeTime=500 -aggregatestatement.Q12.routingInfoTime=190 -aggregatestatement.Q12.generateTime=300 -aggregatestatement.Q12.totalCompilationTime=500 -aggregatestatement.Q12.executionTime=20 -aggregatestatement.Q12.projectionTime=210 -aggregatestatement.Q12.totalExecutionTime=600 -aggregatestatement.Q12.rowsModificationTime=2000 -aggregatestatement.Q12.qnNumRowsSeen=100 -aggregatestatement.Q12.qnMsgSendTime=312 -aggregatestatement.Q12.qnMsgSerTime=450 -aggregatestatement.Q12.qnRespDeSerTime=175 - -aggregatestatement.Q13.name=Q13 -aggregatestatement.Q13.queryDefinition=select name from clients where member='C89'; -aggregatestatement.Q13.numTimesCompiled=11 -aggregatestatement.Q13.numExecution=70 -aggregatestatement.Q13.numExecutionsInProgress=5 -aggregatestatement.Q13.numTimesGlobalIndexLookup=10 -aggregatestatement.Q13.numRowsModified=64 -aggregatestatement.Q13.parseTime=1500 -aggregatestatement.Q13.bindTime=370 -aggregatestatement.Q13.optimizeTime=500 -aggregatestatement.Q13.routingInfoTime=190 -aggregatestatement.Q13.generateTime=300 -aggregatestatement.Q13.totalCompilationTime=500 -aggregatestatement.Q13.executionTime=20 -aggregatestatement.Q13.projectionTime=210 -aggregatestatement.Q13.totalExecutionTime=600 -aggregatestatement.Q13.rowsModificationTime=2000 -aggregatestatement.Q13.qnNumRowsSeen=100 -aggregatestatement.Q13.qnMsgSendTime=312 -aggregatestatement.Q13.qnMsgSerTime=450 -aggregatestatement.Q13.qnRespDeSerTime=-78 - -aggregatestatement.Q14.name=Q14 -aggregatestatement.Q14.queryDefinition=select * from regions where name='R90'; -aggregatestatement.Q14.numTimesCompiled=11 -aggregatestatement.Q14.numExecution=70 -aggregatestatement.Q14.numExecutionsInProgress=5 -aggregatestatement.Q14.numTimesGlobalIndexLookup=10 -aggregatestatement.Q14.numRowsModified=64 -aggregatestatement.Q14.parseTime=1500 -aggregatestatement.Q14.bindTime=370 -aggregatestatement.Q14.optimizeTime=500 -aggregatestatement.Q14.routingInfoTime=190 -aggregatestatement.Q14.generateTime=300 -aggregatestatement.Q14.totalCompilationTime=500 -aggregatestatement.Q14.executionTime=20 -aggregatestatement.Q14.projectionTime=210 -aggregatestatement.Q14.totalExecutionTime=600 -aggregatestatement.Q14.rowsModificationTime=2000 -aggregatestatement.Q14.qnNumRowsSeen=100 -aggregatestatement.Q14.qnMsgSendTime=312 -aggregatestatement.Q14.qnMsgSerTime=450 -aggregatestatement.Q14.qnRespDeSerTime=90 - -aggregatestatement.Q15.name=Q15 -aggregatestatement.Q15.queryDefinition=select * from regions where name='R17'; -aggregatestatement.Q15.numTimesCompiled=11 -aggregatestatement.Q15.numExecution=70 -aggregatestatement.Q15.numExecutionsInProgress=5 -aggregatestatement.Q15.numTimesGlobalIndexLookup=10 -aggregatestatement.Q15.numRowsModified=64 -aggregatestatement.Q15.parseTime=1500 -aggregatestatement.Q15.bindTime=370 -aggregatestatement.Q15.optimizeTime=500 -aggregatestatement.Q15.routingInfoTime=190 -aggregatestatement.Q15.generateTime=300 -aggregatestatement.Q15.totalCompilationTime=500 -aggregatestatement.Q15.executionTime=20 -aggregatestatement.Q15.projectionTime=210 -aggregatestatement.Q15.totalExecutionTime=600 -aggregatestatement.Q15.rowsModificationTime=2000 -aggregatestatement.Q15.qnNumRowsSeen=100 -aggregatestatement.Q15.qnMsgSendTime=312 -aggregatestatement.Q15.qnMsgSerTime=450 -aggregatestatement.Q15.qnRespDeSerTime=24 - -aggregatestatement.Q16.name=Q16 -aggregatestatement.Q16.queryDefinition=select * from members where name='M15'; -aggregatestatement.Q16.numTimesCompiled=11 -aggregatestatement.Q16.numExecution=70 -aggregatestatement.Q16.numExecutionsInProgress=5 -aggregatestatement.Q16.numTimesGlobalIndexLookup=10 -aggregatestatement.Q16.numRowsModified=64 -aggregatestatement.Q16.parseTime=1500 -aggregatestatement.Q16.bindTime=370 -aggregatestatement.Q16.optimizeTime=500 -aggregatestatement.Q16.routingInfoTime=190 -aggregatestatement.Q16.generateTime=300 -aggregatestatement.Q16.totalCompilationTime=500 -aggregatestatement.Q16.executionTime=20 -aggregatestatement.Q16.projectionTime=210 -aggregatestatement.Q16.totalExecutionTime=600 -aggregatestatement.Q16.rowsModificationTime=2000 -aggregatestatement.Q16.qnNumRowsSeen=100 -aggregatestatement.Q16.qnMsgSendTime=312 -aggregatestatement.Q16.qnMsgSerTime=450 -aggregatestatement.Q16.qnRespDeSerTime=210 - -aggregatestatement.Q17.name=Q17 -aggregatestatement.Q17.queryDefinition=select * from members where name='M5'; -aggregatestatement.Q17.numTimesCompiled=11 -aggregatestatement.Q17.numExecution=70 -aggregatestatement.Q17.numExecutionsInProgress=5 -aggregatestatement.Q17.numTimesGlobalIndexLookup=10 -aggregatestatement.Q17.numRowsModified=64 -aggregatestatement.Q17.parseTime=1500 -aggregatestatement.Q17.bindTime=370 -aggregatestatement.Q17.optimizeTime=500 -aggregatestatement.Q17.routingInfoTime=190 -aggregatestatement.Q17.generateTime=300 -aggregatestatement.Q17.totalCompilationTime=500 -aggregatestatement.Q17.executionTime=20 -aggregatestatement.Q17.projectionTime=210 -aggregatestatement.Q17.totalExecutionTime=600 -aggregatestatement.Q17.rowsModificationTime=2000 -aggregatestatement.Q17.qnNumRowsSeen=100 -aggregatestatement.Q17.qnMsgSendTime=312 -aggregatestatement.Q17.qnMsgSerTime=450 -aggregatestatement.Q17.qnRespDeSerTime=45 - -aggregatestatement.Q18.name=Q18 -aggregatestatement.Q18.queryDefinition=select * from members where name='M12'; -aggregatestatement.Q18.numTimesCompiled=11 -aggregatestatement.Q18.numExecution=70 -aggregatestatement.Q18.numExecutionsInProgress=5 -aggregatestatement.Q18.numTimesGlobalIndexLookup=10 -aggregatestatement.Q18.numRowsModified=64 -aggregatestatement.Q18.parseTime=1500 -aggregatestatement.Q18.bindTime=370 -aggregatestatement.Q18.optimizeTime=500 -aggregatestatement.Q18.routingInfoTime=190 -aggregatestatement.Q18.generateTime=300 -aggregatestatement.Q18.totalCompilationTime=500 -aggregatestatement.Q18.executionTime=20 -aggregatestatement.Q18.projectionTime=210 -aggregatestatement.Q18.totalExecutionTime=600 -aggregatestatement.Q18.rowsModificationTime=2000 -aggregatestatement.Q18.qnNumRowsSeen=100 -aggregatestatement.Q18.qnMsgSendTime=312 -aggregatestatement.Q18.qnMsgSerTime=450 -aggregatestatement.Q18.qnRespDeSerTime=180 - -aggregatestatement.Q19.name=Q19 -aggregatestatement.Q19.queryDefinition=select * from members where name='M11'; -aggregatestatement.Q19.numTimesCompiled=11 -aggregatestatement.Q19.numExecution=70 -aggregatestatement.Q19.numExecutionsInProgress=5 -aggregatestatement.Q19.numTimesGlobalIndexLookup=10 -aggregatestatement.Q19.numRowsModified=64 -aggregatestatement.Q19.parseTime=1500 -aggregatestatement.Q19.bindTime=370 -aggregatestatement.Q19.optimizeTime=500 -aggregatestatement.Q19.routingInfoTime=190 -aggregatestatement.Q19.generateTime=300 -aggregatestatement.Q19.totalCompilationTime=500 -aggregatestatement.Q19.executionTime=20 -aggregatestatement.Q19.projectionTime=210 -aggregatestatement.Q19.totalExecutionTime=600 -aggregatestatement.Q19.rowsModificationTime=2000 -aggregatestatement.Q19.qnNumRowsSeen=100 -aggregatestatement.Q19.qnMsgSendTime=312 -aggregatestatement.Q19.qnMsgSerTime=450 -aggregatestatement.Q19.qnRespDeSerTime=-100 - -aggregatestatement.Q20.name=Q20 -aggregatestatement.Q20.queryDefinition=select * from regions where name='R6'; -aggregatestatement.Q20.numTimesCompiled=11 -aggregatestatement.Q20.numExecution=70 -aggregatestatement.Q20.numExecutionsInProgress=5 -aggregatestatement.Q20.numTimesGlobalIndexLookup=10 -aggregatestatement.Q20.numRowsModified=64 -aggregatestatement.Q20.parseTime=1500 -aggregatestatement.Q20.bindTime=370 -aggregatestatement.Q20.optimizeTime=500 -aggregatestatement.Q20.routingInfoTime=190 -aggregatestatement.Q20.generateTime=300 -aggregatestatement.Q20.totalCompilationTime=500 -aggregatestatement.Q20.executionTime=20 -aggregatestatement.Q20.projectionTime=210 -aggregatestatement.Q20.totalExecutionTime=600 -aggregatestatement.Q20.rowsModificationTime=2000 -aggregatestatement.Q20.qnNumRowsSeen=100 -aggregatestatement.Q20.qnMsgSendTime=312 -aggregatestatement.Q20.qnMsgSerTime=450 -aggregatestatement.Q20.qnRespDeSerTime=50 - -aggregatestatement.Q21.name=Q21 -aggregatestatement.Q21.queryDefinition=select * from regions where name='R5'; -aggregatestatement.Q21.numTimesCompiled=11 -aggregatestatement.Q21.numExecution=70 -aggregatestatement.Q21.numExecutionsInProgress=5 -aggregatestatement.Q21.numTimesGlobalIndexLookup=10 -aggregatestatement.Q21.numRowsModified=64 -aggregatestatement.Q21.parseTime=1500 -aggregatestatement.Q21.bindTime=370 -aggregatestatement.Q21.optimizeTime=500 -aggregatestatement.Q21.routingInfoTime=190 -aggregatestatement.Q21.generateTime=300 -aggregatestatement.Q21.totalCompilationTime=500 -aggregatestatement.Q21.executionTime=20 -aggregatestatement.Q21.projectionTime=210 -aggregatestatement.Q21.totalExecutionTime=600 -aggregatestatement.Q21.rowsModificationTime=2000 -aggregatestatement.Q21.qnNumRowsSeen=100 -aggregatestatement.Q21.qnMsgSendTime=312 -aggregatestatement.Q21.qnMsgSerTime=450 -aggregatestatement.Q21.qnRespDeSerTime=40 - -aggregatestatement.Q22.name=Q22 -aggregatestatement.Q22.queryDefinition=select * from regions where name='R4'; -aggregatestatement.Q22.numTimesCompiled=11 -aggregatestatement.Q22.numExecution=70 -aggregatestatement.Q22.numExecutionsInProgress=5 -aggregatestatement.Q22.numTimesGlobalIndexLookup=10 -aggregatestatement.Q22.numRowsModified=64 -aggregatestatement.Q22.parseTime=1500 -aggregatestatement.Q22.bindTime=370 -aggregatestatement.Q22.optimizeTime=500 -aggregatestatement.Q22.routingInfoTime=190 -aggregatestatement.Q22.generateTime=300 -aggregatestatement.Q22.totalCompilationTime=500 -aggregatestatement.Q22.executionTime=20 -aggregatestatement.Q22.projectionTime=210 -aggregatestatement.Q22.totalExecutionTime=600 -aggregatestatement.Q22.rowsModificationTime=2000 -aggregatestatement.Q22.qnNumRowsSeen=100 -aggregatestatement.Q22.qnMsgSendTime=312 -aggregatestatement.Q22.qnMsgSerTime=450 -aggregatestatement.Q22.qnRespDeSerTime=250 - -aggregatestatement.Q23.name=Q23 -aggregatestatement.Q23.queryDefinition=select * from regions where name='R3'; -aggregatestatement.Q23.numTimesCompiled=11 -aggregatestatement.Q23.numExecution=70 -aggregatestatement.Q23.numExecutionsInProgress=5 -aggregatestatement.Q23.numTimesGlobalIndexLookup=10 -aggregatestatement.Q23.numRowsModified=64 -aggregatestatement.Q23.parseTime=1500 -aggregatestatement.Q23.bindTime=370 -aggregatestatement.Q23.optimizeTime=500 -aggregatestatement.Q23.routingInfoTime=190 -aggregatestatement.Q23.generateTime=300 -aggregatestatement.Q23.totalCompilationTime=500 -aggregatestatement.Q23.executionTime=20 -aggregatestatement.Q23.projectionTime=210 -aggregatestatement.Q23.totalExecutionTime=600 -aggregatestatement.Q23.rowsModificationTime=2000 -aggregatestatement.Q23.qnNumRowsSeen=100 -aggregatestatement.Q23.qnMsgSendTime=312 -aggregatestatement.Q23.qnMsgSerTime=450 -aggregatestatement.Q23.qnRespDeSerTime=-200 - -aggregatestatement.Q24.name=Q24 -aggregatestatement.Q24.queryDefinition=select * from regions where name='R2'; -aggregatestatement.Q24.numTimesCompiled=11 -aggregatestatement.Q24.numExecution=70 -aggregatestatement.Q24.numExecutionsInProgress=5 -aggregatestatement.Q24.numTimesGlobalIndexLookup=10 -aggregatestatement.Q24.numRowsModified=64 -aggregatestatement.Q24.parseTime=1500 -aggregatestatement.Q24.bindTime=370 -aggregatestatement.Q24.optimizeTime=500 -aggregatestatement.Q24.routingInfoTime=190 -aggregatestatement.Q24.generateTime=300 -aggregatestatement.Q24.totalCompilationTime=500 -aggregatestatement.Q24.executionTime=20 -aggregatestatement.Q24.projectionTime=210 -aggregatestatement.Q24.totalExecutionTime=600 -aggregatestatement.Q24.rowsModificationTime=2000 -aggregatestatement.Q24.qnNumRowsSeen=100 -aggregatestatement.Q24.qnMsgSendTime=312 -aggregatestatement.Q24.qnMsgSerTime=450 -aggregatestatement.Q24.qnRespDeSerTime=40 - -aggregatestatement.Q25.name=Q25 -aggregatestatement.Q25.queryDefinition=select * from regions where name='R1'; -aggregatestatement.Q25.numTimesCompiled=11 -aggregatestatement.Q25.numExecution=70 -aggregatestatement.Q25.numExecutionsInProgress=5 -aggregatestatement.Q25.numTimesGlobalIndexLookup=10 -aggregatestatement.Q25.numRowsModified=64 -aggregatestatement.Q25.parseTime=1500 -aggregatestatement.Q25.bindTime=370 -aggregatestatement.Q25.optimizeTime=500 -aggregatestatement.Q25.routingInfoTime=190 -aggregatestatement.Q25.generateTime=300 -aggregatestatement.Q25.totalCompilationTime=500 -aggregatestatement.Q25.executionTime=20 -aggregatestatement.Q25.projectionTime=210 -aggregatestatement.Q25.totalExecutionTime=600 -aggregatestatement.Q25.rowsModificationTime=2000 -aggregatestatement.Q25.qnNumRowsSeen=100 -aggregatestatement.Q25.qnMsgSendTime=312 -aggregatestatement.Q25.qnMsgSerTime=450 -aggregatestatement.Q25.qnRespDeSerTime=450 \ No newline at end of file +regionOnMember./R3.M1.fullPath=/R3 +regionOnMember./R3.M1.memberName=M1 +regionOnMember./R3.M1.name=/R3 +regionOnMember./R3.M1.regionType=PERSISTENT +regionOnMember./R3.M1.entrySize=21 +regionOnMember./R3.M1.entryCount=26 +regionOnMember./R3.M1.getsRate=10.50 +regionOnMember./R3.M1.putsRate=20.33 +regionOnMember./R3.M1.diskGetsRate=23.44 +regionOnMember./R3.M1.diskPutsRate=30.22 +regionOnMember./R3.M1.localMaxMemory=20 + +regionOnMember./R3.M2.fullPath=/R3 +regionOnMember./R3.M2.memberName=M2 +regionOnMember./R3.M2.name=/R3 +regionOnMember./R3.M2.regionType=PERSISTENT +regionOnMember./R3.M2.entrySize=215 +regionOnMember./R3.M2.entryCount=30 +regionOnMember./R3.M2.getsRate=18.6 +regionOnMember./R3.M2.putsRate=45.33 +regionOnMember./R3.M2.diskGetsRate=38.44 +regionOnMember./R3.M2.diskPutsRate=50.22 +regionOnMember./R3.M2.localMaxMemory=10
