Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to kill a currently long running query in Neo4j

Tags:

neo4j

How can I kill a currently long-running query in Neo4j (without restarting the server)?

I know we can globally set a timeout for queries, but sometimes I want to execute heavy queries/creates/updates on the server that could take a while...

Thanks.

like image 898
Gil Stal Avatar asked Apr 17 '13 09:04

Gil Stal


People also ask

How do I see what queries are running on Neo4j?

Checking for running queries can be accomplished using Cypher in Enterprise Edition: CALL dbms. listQueries; . You must be logged in as an admin user to perform the query. If you want to stop a long-running query, use CALL dbms.

What is CQL in Neo4j?

CQL stands for Cypher Query Language. Like Oracle Database has query language SQL, Neo4j has CQL as query language.

What are the limitations of Neo4j?

Neo4j has some upper bound limit for the graph size and can support tens of billions of nodes, properties, and relationships in a single graph. No security is provided at the data level and there is no data encryption. Security auditing is not available in Neo4j.


1 Answers

Available in version >3.1 Enterprise with

CALL dbms.listQueries() CALL dbms.killQuery(queryId)  

Admins may "kill'em all"

There is also

 :queries 
like image 143
Jerome_B Avatar answered Oct 25 '22 22:10

Jerome_B