Re: Ignite Web Console partition monitoring - ratio for Keys in offheap is NEGATIVE number

2019-02-21 Thread Alexey Kuznetsov
Hi, James Wang! This is a deviation from "ideal" mean value. So it means that this node contains less keys than "ideal" mean value for 4.7% "Ideal" means all data distributed over cluster in uniform fashion. In "ideal" situation this metric should be zero. This metric is useful to detect

Re: WAL - Fsync time average time is too higher

2019-02-21 Thread Ilya Kasnacheev
Hello! We do not advice using Apache Ignite with HDD. Apache Ignite is not optimized for high-latency storage. Regards, -- Ilya Kasnacheev чт, 21 февр. 2019 г. в 08:58, James Wang 王升平 (edvance CN) < james.w...@edvancesecurity.com>: > Hi Support, > > > > > > I monitor the system through

Re: C++ computer delay

2019-02-21 Thread Ilya Kasnacheev
Hello! Can you collect some thread dumps (Java ones, using jstack) during those 10 seconds freezes? Regards, -- Ilya Kasnacheev ср, 20 февр. 2019 г. в 20:18, F.D. : > Hi igniters, > I've a problem when I launch a sequence of about 350 compute funcions in > my cluster of 10 node. I register a

Re: C++ computer delay

2019-02-21 Thread F.D.
Hi, thread log of the client? On Thu, Feb 21, 2019 at 10:29 AM Ilya Kasnacheev wrote: > Hello! > > Can you collect some thread dumps (Java ones, using jstack) during those > 10 seconds freezes? > > Regards, > -- > Ilya Kasnacheev > > > ср, 20 февр. 2019 г. в 20:18, F.D. : > >> Hi igniters, >>

Re: Cpu usage cannot be improved

2019-02-21 Thread Ilya Kasnacheev
Hello! Unfortunately, not much is going on in this thread dump (please use jstack next time), but the main take away is that you seem to be using persistence. If you are using persistence you should not expect CPU usage to hit 100% since most of operations will be I/O-bound. In this case you

Re: C++ computer delay

2019-02-21 Thread Ilya Kasnacheev
Hello! Preferably all nodes in the cluster. Regards, -- Ilya Kasnacheev чт, 21 февр. 2019 г. в 12:39, F.D. : > Hi, > > thread log of the client? > > On Thu, Feb 21, 2019 at 10:29 AM Ilya Kasnacheev < > ilya.kasnach...@gmail.com> wrote: > >> Hello! >> >> Can you collect some thread dumps

Ignite2.7 Affinity Key in SQL

2019-02-21 Thread Ajay
Hi, I want to know scenarios, 1)I want to use ignite affinity key logic to keep homogeneous data in one place, for this i created bean like public class RowID { private int id; @AffinityKeyMapped private int regid; ... } and configured in xml

Re: OverlappingFileLockException when restarting client node

2019-02-21 Thread Davalb
Since we did not set the workDir explicitly it seems like the temp dir of the tomcat was used as workDir which was of course the same directory for the nodes running in the same tomcat. Thanks for your help. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Ignite is a third-party persistence problem

2019-02-21 Thread hulitao198758
If don't open the persistence in Ignite server startup, as in-memory database to use, can achieve using the Sql query data, if not in the memory, automatic to from the mysql database and loaded into memory, there is a new data to the automatic synchronization to mysql, or Ignite in future versions

third-party persistence problem

2019-02-21 Thread hulitao198758
If don't open the persistence in Ignite server startup, as in-memory database to use, can achieve using the Sql query data, if not in the memory, automatic to from the mysql database and loaded into memory, there is a new data to the automatic synchronization to mysql, or Ignite in future versions

the third-party persistence problem

2019-02-21 Thread hulitao198758
If don't open the persistence in Ignite server startup, as in-memory database to use, can achieve using the Sql query data, if not in the memory, automatic to from the mysql database and loaded into memory, there is a new data to the automatic synchronization to mysql, or Ignite in future versions

Question about ignite data storage

2019-02-21 Thread newigniter
I created a table and inserted 9013 records in it. The table has 17 columns and the total size of the data before import into ignite is 282,625 bytes. I have native persistence enabled and have 2 nodes in my cluster. Data is replicated to both nodes. I am using ignite 2.7. After import into

Ignite and third party database realize data persistence real - time loading problem

2019-02-21 Thread hulitao198758
If don't open the persistence in Ignite server startup, as in-memory database to use, can achieve using the Sql query data, if not in the memory, automatically pulled from the mysql database and loaded into memory, there is a new data to the automatic synchronization to mysql, or Ignite in future

Mysql and ignite persistence inheritance issues

2019-02-21 Thread hulitao198758
Ignite does not enable the persistence function. The startup is to connect to the MySql database. The Sql statement can be run in Ignite to automatically load the data in mysql. In Ignite, select, insert, update, delete, etc., if the data in the memory does not exist, then Automatically load data

Accessing Ignite from MS Excel

2019-02-21 Thread Andrew Munn
What's the best way to access Ignite data from MS Excel? It looks like I could use the ODBC driver but I'd like updates pushed into Excel, not Excel polling for updates. I could use Excel-DNA and use the C# client. Is there a better way?

Re: Cpu usage cannot be improved

2019-02-21 Thread gn01887818
I have confirmed that I am using jstack... Jstack -J-d64 -m processId I generated jstackInfo.txt like this. Still have to make other orders? That's right, currently using a regular hard drive, it seems to be stuck on the hard drive speed. Thank you -- Sent from:

Re: Cpu usage cannot be improved

2019-02-21 Thread gn01887818
I have confirmed that I am using jstack... Jstack -J-d64 -m processId I generated jstackInfo.txt like this. Still have to make other orders? That's right, currently using a regular hard drive, it seems to be stuck on the hard drive speed. Thank you -- Sent from: