Hello Ilya,
The test method is as follows:
Start 2 nodes on the localhost.
Use the CREATE TABLE statement to create a table;
Use the COPY command to load some data;
Access to cluster through sqlline;
Execute select count (*) from T;
Execute select * from sys.metrics WHERE name LIKE '%cache.T%';
At this time, you will find that the relevant data are all 0, but the
value of OffHeapEntriesCount is still correct.
If you use sqlline to access another node, the result is the same.
The configuration file to start the cluster is as follows:
<beanid="ignite.cfg"class="org.apache.ignite.configuration.IgniteConfiguration">
<propertyname="peerClassLoadingEnabled"value="true"/>
<propertyname="consistentId"value="#{systemEnvironment['CONSISTENTID']}"/>
<propertyname="metricExporterSpi">
<list>
<beanclass="org.apache.ignite.spi.metric.sql.SqlViewMetricExporterSpi"/>
</list>
</property>
<propertyname="cacheConfiguration">
<list>
<beanid="partitioned-cache-template"abstract="true"class="org.apache.ignite.configuration.CacheConfiguration">
<propertyname="name"value="cache-partitioned*"/>
<propertyname="cacheMode"value="PARTITIONED"/>
<propertyname="backups"value="0"/>
<propertyname="statisticsEnabled"value="true"/>
<propertyname="queryParallelism"value="2"/>
<propertyname="partitionLossPolicy"value="READ_WRITE_SAFE"/>
</bean>
<beanid="replicated-cache-template"abstract="true"class="org.apache.ignite.configuration.CacheConfiguration">
<propertyname="name"value="cache-replicated*"/>
<propertyname="cacheMode"value="REPLICATED"/>
<propertyname="statisticsEnabled"value="true"/>
<propertyname="partitionLossPolicy"value="READ_WRITE_SAFE"/>
</bean>
</list>
</property>
<!-- Enabling Apache Ignite Persistent Store. -->
<propertyname="dataStorageConfiguration">
<beanclass="org.apache.ignite.configuration.DataStorageConfiguration">
<propertyname="metricsEnabled"value="true"/>
<propertyname="defaultDataRegionConfiguration">
<beanclass="org.apache.ignite.configuration.DataRegionConfiguration">
<propertyname="persistenceEnabled"value="true"/>
<propertyname="metricsEnabled"value="true"/>
<propertyname="maxSize"value="#{2L * 1024 * 1024 * 1024}"/>
</bean>
</property>
</bean>
</property>
</bean>
在 2021/1/27 下午6:24, Ilya Kasnacheev 写道:
Hello!
These values are per-node, as far as I know. Is it possible that you
have connected to a node which does not handle any queries (as
reducer, anyway)?
Regards,
--
Ilya Kasnacheev
вт, 26 янв. 2021 г. в 13:48, 38797715 <38797...@qq.com
<mailto:38797...@qq.com>>:
Hi,
We found that SYS.METRICS View some data is always 0, such as
QueryCompleted,QueryExecuted,QuerySumTime,QueryCompleted,QuerySumTime
and QueryMaximumTime. This is a bug? Or what configuration is
needed? Or
the related functions have not been implemented yet?
