Hello! You can add lazy=true setting in your DBeaver connection configuration. See https://apacheignite.readme.io/docs/jdbc-driver
Other than that, unfortunately, the recommendation is to be careful with your queries. Nobody can guarantee that any RDBMS doesn't have HCF queries, but in case of Apache Ignite there's only rudimentary support of query memory consumption checks and limiting. Regards, -- Ilya Kasnacheev 2018-05-17 20:40 GMT+03:00 engrdean <engrd...@gmail.com>: > Thanks Ilya, but I don't have any code running on the Ignite servers other > than the Ignite process. I am connecting with the SQL client DBeaver to > run > my query and running DBeaver on a separate machine. > > Are there any adjustments I can make on the Ignite server to insure that an > arbitrary user query can't crash the server? > > Alternatively, is there anything I can do to get Ignite to store the result > set off heap? I am no where near exhausting the overall memory on the > servers, just the java heap memory. > > I have already implemented all of the memory tuning recommendations in the > latest Ignite docs but that did not seem to help. Right now I have 10GB of > memory allocated for heap space out of the 64GB available on the server. > > > ilya.kasnacheev wrote > > Hello! > > > > Yes, SELECT * FROM cache; will cause problems for you, unless you are > > using > > lazy=true, which isn't default. > > > > However, if you're using lazy=true, you should probably search for memory > > leaks in your own code (such as trying to keep all results in memory at > > the > > same time instead of iterating). > > > > Regards, > > > > -- > > Ilya Kasnacheev > > > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
