Hi AM using 2.3
Loaded 2 caches - Customer & Account with 10 million rows. You can see the same from the below snippet, 2.5M avg * 4 -> 10M visor> cache -e Time of the snapshot: 12/11/17, 17:57:11 +===========================================================================================================================+ | Name(@) | Mode | Nodes | Entries (Heap / Off-heap) | Hits | Misses | Reads | Writes | +===========================================================================================================================+ | Account(@c0) | PARTITIONED | 4 | min: 0 (0 / 0) | min: 0 | min: 0 | min: 0 | min: 0 | | | | | avg: 2500000.25 (0.50 / 2499999.75) | avg: 0.00 | avg: 0.00 | avg: 0.00 | avg: 0.00 | | | | | max: 3475957 (1 / 3475956) | max: 0 | max: 0 | max: 0 | max: 0 | +---------------+-------------+-------+-------------------------------------+-----------+-----------+-----------+-----------+ | Customer(@c1) | PARTITIONED | 4 | min: 0 (0 / 0) | min: 0 | min: 0 | min: 0 | min: 0 | | | | | avg: 2499999.75 (0.00 / 2499999.75) | avg: 0.00 | avg: 0.00 | avg: 0.00 | avg: 0.00 | | | | | max: 3475956 (0 / 3475956) | max: 0 | max: 0 | max: 0 | max: 0 | +---------------------------------------------------------------------------------------------------------------------------+ Also, output of the REST API also shows 10M http://10.144.114.115:8080/ignite?cmd=size&cacheName=Account Resp: {"successStatus":0,"affinityNodeId":null,"sessionToken":null,"error":null,"response":9999999} [tibusr@JMNGD1BAQ10V04 bin]$ ./sqlline.sh --color=true --verbose=true -u jdbc:ignite:thin://127.0.0.1 issuing: !connect jdbc:ignite:thin://127.0.0.1 '' '' org.apache.ignite.IgniteJdbcThinDriver Connecting to jdbc:ignite:thin://127.0.0.1 Connected to: Apache Ignite (version 2.3.0#20171028-sha1:8add7fd5) Driver: Apache Ignite Thin JDBC Driver (version 2.3.0#20171028-sha1:8add7fd5) Autocommit status: true Transaction isolation: TRANSACTION_REPEATABLE_READ sqlline version 1.3.0 0: jdbc:ignite:thin://127.0.0.1> select count(*) from "Account".ACCOUNT; +--------------------------------+ | COUNT(*) | +--------------------------------+ | 6671907 | +--------------------------------+ 1 row selected (105.706 seconds) I have used AffinityKey to store the Account cache, but should not cause this issue. For other cache Customer, I could see 10M is cache size I could see properly from all. Also, where do I see the back up copies held by a node? Thanks Naveen -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
