Introducing Neo4j Workspace We’re inviting you to check out Neo4j Workspace. Workspace combines our most powerful graph tools (Data Importer, Bloom, and Browser) all in one place to help you get up and running with graph databases faster. For experie...
The Neo4j Graph Platform includes the core database and all the technologies surrounding the database, making it useful and accessible for a lot of different users. When asking a question, please select a descriptive label that best matches your quer...
Using apoc.text.phonetic one can perform a Soundex search. For example if one defines the following nodes CREATE (n:Person {name:'Anders'}) CREATE (m:Person {name:'Andrew'}) CREATE (p:Person {name:'Andres'}) then to find these 3 nodes, since they a...
The following Cypher can be used to get a simple high level view of the number of objects within your graph database. This may be used if one is trying to compare the contents of two databases: match (n) return 'Number of Nodes: ' + count(n) as outpu...
If you need to generate the equivalent output from command :sysinfo as run from the Neo4j Browser at http://localhost:7474 this can be achieved by running the following Cypher call dbms.queryJmx("org.neo4j:instance=kernel#0,name=Store file sizes") yi...
The initial and eventual memory configuration parameters can be a moving target, based on how your store changes in size and how your workload increases or changes over time. This guidance is meant for the initial configuration. In order to decide on...
When using LOAD CSV to read a file which includes data with double quote characters ("), the quotes need to be escaped as 2 double quote characters For example if your data file (courses.csv) included the following content COURSE_ID|COURSE_TITLE 1215...
neo4j-import allows one to initially load a graph.db via CSV files. There may be times when using a ',' as a field or array delimiter is not appropriate as your data may contain this character as part of its data. When this is the case you can chan...
When perfoming an install of Neo4j using the Debian install kit and as detailed at https://neo4j.com/docs/operations-manual/current/deployment/single-instance/debian/, upon completion you will need to configure the linux configuration option for max ...
If you wish to set a 'breakpoint' in a Cypher statement so as to perform further analysis (i.e. see how many locks are taken, memory utilization) one can add a call to apoc.utils.sleep(XXX) which will result in the query sleeping for XXXX msec. For e...
If you skip the Consistency Check part of neo4j-backup, or you want to check that all is well with a data store, you can run the tool against an offline store. $ java -cp 'lib/*:system/lib/*' org.neo4j.consistency.ConsistencyCheckTool /tmp/graph.db ...
If you have multiple graphs set up and want to quickly switch between each without modifying dbms.active_database in conf/neo4j.conf, you can accomplish this with a neo4j restart and with the environment variable NEO4J_CONF defined pointing to the ap...
Java Garbage Collection (gc) pauses are monitored by the MonitorGc process in Neo4j, and recorded in the $NEO4J_HOME/logs/debug.log ( or $NEO4J_HOME/data/graph.db/messages.log for Neo4j v2.3.x and prior). To quickly find the 10 longest pauses in Neo4...
With a traditional SQL RDBMS one could perform a create table as select (i.e. CTAS) whereby its purpose is to create a new table and copy existing data from the original table to the new copy. If you are looking to achieve the same with Cypher this...
Commencing with Neo4j 3.2.2 one can override default configuration settings of the browser whereby a number of these settings are defined under the left frame and through the 'gears' icon. To implement said functionality you would first need to know ...
Linux users are typically configured with a maximum number of files to be opened. This is describe at based upon your installation method. To monitor how many open files a user has one can run lsof -u <user> replacing with the linux username who s...
Neo4j 3.0 introduces the ability to log the value of query parameters in the log/query.log file. The settings to control this feature are located in the conf/neo4j.conf file. To enable query logging with parameters, one must first enable query loggin...
All the sessions of the conference are now available online
