Yep. Four nodes running on ec2 with 2 gp2 ebs disks each (one for
persistence and one for wal). Running loader on first node connecting to
local host. The cache in question is using the data region included in this
config included at the bottom. here is the query info:
explain select count(*) from "click_csv"."CLICK_CSV" where user_id = 1234;
PLAN SELECT
COUNT(*) AS __C0_0
FROM "click_csv".CLICK_CSV __Z0
/* "click_csv".CLICK_CSV_DATE_ASC_USER_ID_ASC_IDX: USER_ID = 1234 */
WHERE __Z0.USER_ID = 1234
PLAN SELECT
CAST(SUM(__C0_0) AS BIGINT) AS __C0_0
FROM PUBLIC.__T0
/* PUBLIC."merge_scan" */
2 rows selected (0.141 seconds)
so that should use the right index.
0: jdbc:ignite:thin://127.0.0.1/> select count(*) from
"click_csv"."CLICK_CSV" where user_id = 1234;
COUNT(*) 13
1 row selected (90.328 seconds)
0: jdbc:ignite:thin://127.0.0.1/> select count(*) from
"click_csv"."CLICK_CSV" where user_id = 1234;
COUNT(*) 13
1 row selected (90.144 seconds)
0: jdbc:ignite:thin://127.0.0.1/> select count(*) from
"click_csv"."CLICK_CSV";
COUNT(*) 180347104
1 row selected (82.486 seconds)
The performance doesn't quite make sense at all.... here is the server
config:
<bean id="ignite.cfg"
class="org.apache.ignite.configuration.IgniteConfiguration">
<property name="publicThreadPoolSize" value="16"/>
<property name="systemThreadPoolSize" value="16"/>
<property name="dataStreamerThreadPoolSize" value="16"/>
<property name="deploymentMode" value="SHARED"/>
<property name="peerClassLoadingEnabled" value="true"/>
<property name="dataStorageConfiguration">
<bean
class="org.apache.ignite.configuration.DataStorageConfiguration">
<property name="storagePath" value="/per/persistence"/>
<property name="walPath" value="/wal"/>
<property name="walMode" value="BACKGROUND"/>
<property name="walHistorySize" value="5"/>
<property name="walFlushFrequency" value="5000"/>
<property name="checkpointThreads" value="16"/>
<property name="writeThrottlingEnabled" value="true"/>
<property name="walArchivePath" value="/wal/archive"/>
<property name="defaultDataRegionConfiguration">
<bean
class="org.apache.ignite.configuration.DataRegionConfiguration">
<property name="name" value="Default_Region"/>
<property name="maxSize" value="#{100L * 1024 *
1024}"/>
</bean>
</property>
<property name="dataRegionConfigurations">
<list>
<bean
class="org.apache.ignite.configuration.DataRegionConfiguration">
<property name="name" value="20G_Region_Eviction_P"/>
<property name="initialSize" value="#{10L * 1024 * 1024}"/>
<property name="maxSize" value="#{5 * 1024L * 1024 *
1024}"/>
<property name="persistenceEnabled" value="true"/>
<property name="pageEvictionMode" value="RANDOM_2_LRU"/>
<property name="checkpointPageBufferSize" value="#{2 * 1024L
* 1024 * 1024}"/>
</bean>
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
