Hello,
My concurrent read cypher queries very slow. Both console.log and neo4j.0.0.log show no errors, but the messages.log file inside the graph.db folder repeated shows errors as follows *even if I do not do any request to the database*: > 2014-08-28 11:04:02.452+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC >> Monitor: Application threads blocked for an additional 113ms [total block >> time: 3.601s] > > 2014-08-28 11:04:03.834+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC >> Monitor: Application threads blocked for an additional 171ms [total block >> time: 3.772s] > > 2014-08-28 11:04:15.824+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC >> Monitor: Application threads blocked for an additional 179ms [total block >> time: 3.951s] > > 2014-08-28 11:04:20.272+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC >> Monitor: Application threads blocked for an additional 179ms [total block >> time: 4.13s] > > 2014-08-28 11:04:22.726+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC >> Monitor: Application threads blocked for an additional 144ms [total block >> time: 4.274s] > > 2014-08-28 11:04:27.702+0000 WARN [o.n.k.EmbeddedGraphDatabase]: GC >> Monitor: Application threads blocked for an additional 171ms [total block >> time: 4.445s] > > neo4j.properties: > # Default values for the low-level graph engine #neostore.nodestore.db.mapped_memory=25M #neostore.relationshipstore.db.mapped_memory=50M #neostore.propertystore.db.mapped_memory=90M #neostore.propertystore.db.strings.mapped_memory=130M #neostore.propertystore.db.arrays.mapped_memory=130M > # Autoindexing > # Enable auto-indexing for nodes, default is false node_auto_indexing=true > # The node property keys to be auto-indexed, if enabled node_keys_indexable=name,age,createdTimestamp > # Enable auto-indexing for relationships, default is false relationship_auto_indexing=true > # The relationship property keys to be auto-indexed, if enabled relationship_keys_indexable=name,age > # Keep logical logs, helps debugging but uses more disk space, enabled for # legacy reasons To limit space needed to store historical logs use values > such # as: "7 days" or "100M size" instead of "true" keep_logical_logs=false > # Enable online backups to be taken from this database. online_backup_enabled=true > # Port to listen to for incoming backup requests. online_backup_server=127.0.0.1:6362 > > # Uncomment and specify these lines for running Neo4j in High Availability > mode. # See the High availability setup tutorial for more details on these > settings # http://docs.neo4j.org/chunked/2.0.0/ha-setup-tutorial.html > # ha.server_id is a unique integer for each instance of the Neo4j database > in # the cluster (as opposed to the coordinator instance IDs). #ha.server_id= > # ha.initial_hosts is a comma-separated list (without spaces) of the > host:port # of where to find one or more of the known Cluster members, if they are # already present. If none of them can be contacted the cluster will be > formed # by this instance. # Avoid localhost due to IP resolution issues on some systems. # Addresses w/o host (:<port>) will use the localhost IP. #ha.initial_hosts=:5001,:5002,:5003 > # IP and port for this instance to bind to to communicate data with the # other neo4j instances in the cluster. This is broadcasted to the other # cluster members, so different members can have different communication > ports. # Avoid localhost due to IP resolution issues on some systems. # Addresses w/o host (:<port>) will use the localhost IP. #ha.server=:6001 > # IP and port for this instance to bind to, for communicating cluster # information with the rest of the instances. This will be communicated to > the # rest of the instances via normal cluster traffic but for an instance to > join # a cluster it must already know at least one other instance. # Port ranges as well as single ports is supported. # Avoid localhost due to IP resolution issues on some systems. # Addresses w/o host (:<port>) will use the localhost IP. # See also ha.initial_hosts #ha.cluster_server=:5001-5099 > # The interval at which slaves will pull updates from the master. Comment > out # the option to disable periodic pulling of updates. Unit is seconds. ha.pull_interval=10 > # Amount of slaves the master will try to push a transaction to upon commit # (default is 1). The master will optimistically continue and not fail the # transaction even if it fails to reach the push factor. Setting this to 0 > will # increase write performance when writing through master but could > potentially # lead to branched data (or loss of transaction) if the master goes down. #ha.tx_push_factor=1 > # Strategy the master will use when pushing data to slaves (if the push > factor # is greater than 0). There are two options available "fixed" (default) or # "round_robin". Fixed will start by pushing to slaves ordered by server id # (highest first) improving performance since the slaves only have to cache > up # one transaction at a time. #ha.tx_push_strategy=fixed > # Enable this to be able to upgrade a store from an older version. #allow_store_upgrade=true > # Enable this to specify a parser other than the default one. #cypher_parser_version=2.0 > # Enable shell server so that remote clients can connect vi Neo4j shell. #remote_shell_enabled=true # Specify custom shell port (default is 1337). #remote_shell_port=1234 > execution_guard_enabled=true neo4j-server.properties : ################################################################ # Neo4j configuration # ################################################################ > #*************************************************************** # Server configuration #*************************************************************** > # location of the database directory org.neo4j.server.database.location=data/graph.db > # Let the webserver only listen on the specified IP. Default is localhost > (only # accept local connections). Uncomment to allow any connection. Please see > the # security section in the neo4j manual before modifying this.# > org.neo4j.server.webserver.address=0.0.0.0 org.neo4j.server.webserver.address=0.0.0.0 > # # HTTP Connector # > # http port (for all data, administrative, and UI access) org.neo4j.server.webserver.port=7474 > # # HTTPS Connector # > # Turn https-support on/off org.neo4j.server.webserver.https.enabled=True > # https port (for all data, administrative, and UI access) org.neo4j.server.webserver.https.port=7473 > # Certificate location (auto generated if the file does not exist) org.neo4j.server.webserver.https.cert.location=conf/ssl/snakeoil.cert > # Private key location (auto generated if the file does not exist) org.neo4j.server.webserver.https.key.location=conf/ssl/snakeoil.key > # Internally generated keystore (don't try to put your own # keystore there, it will get deleted when the server starts) org.neo4j.server.webserver.https.keystore.location=data/keystore > #***************************************************************** # Administration client configuration #***************************************************************** > # location of the servers round-robin database directory. possible values: # - absolute path like /var/rrd # - path relative to the server working directory like data/rrd # - commented out, will default to the database data directory. org.neo4j.server.webadmin.rrdb.location=data/rrd > # REST endpoint for the data API # Note the / in the end is mandatory org.neo4j.server.webadmin.data.uri=/db/data/ > # REST endpoint of the administration API (used by Webadmin) org.neo4j.server.webadmin.management.uri=/db/manage/ > # Low-level graph engine tuning file org.neo4j.server.db.tuning.properties=conf/neo4j.properties > > # The console services to be enabled org.neo4j.server.manage.console_engines=shell > # Allowed values: # HA - High Availability # SINGLE - Single mode, default. # To run in High Availability mode, configure the # neo4j.properties config file, then uncomment this line: org.neo4j.server.database.mode=SINGLE > # Comma separated list of JAX-RS packages containing JAX-RS resources, one # package name for each mountpoint. The listed package names will be loaded # under the mountpoints specified. Uncomment this line to mount the # org.neo4j.examples.server.unmanaged.HelloWorldResource.java from # neo4j-examples under /examples/unmanaged, resulting in a final URL of # http://localhost:7474/examples/unmanaged/helloworld/{nodeId} #org.neo4j.server.thirdparty_jaxrs_classes=org.neo4j.examples.server.unmanaged=/examples/unmanaged > > #***************************************************************** # HTTP logging configuration #***************************************************************** > # HTTP logging is disabled. HTTP logging can be enabled by setting this # property to 'true'. org.neo4j.server.http.log.enabled=False > # Logging policy file that governs how HTTP log output is presented and # archived. Note: changing the rollover and retention policy is sensible, > but # changing the output format is less so, since it is configured to use the # ubiquitous common log format org.neo4j.server.http.log.config=conf/neo4j-http-logging.xml > org.neo4j.server.webserver.limit.executiontime=60000 neo4j-server.properties: ################################################################ # Neo4j configuration # ################################################################ > #*************************************************************** # Server configuration #*************************************************************** > # location of the database directory org.neo4j.server.database.location=data/graph.db > # Let the webserver only listen on the specified IP. Default is localhost > (only # accept local connections). Uncomment to allow any connection. Please see > the # security section in the neo4j manual before modifying this.# > org.neo4j.server.webserver.address=0.0.0.0 org.neo4j.server.webserver.address=0.0.0.0 > # # HTTP Connector # > # http port (for all data, administrative, and UI access) org.neo4j.server.webserver.port=7474 > # # HTTPS Connector # > # Turn https-support on/off org.neo4j.server.webserver.https.enabled=True > # https port (for all data, administrative, and UI access) org.neo4j.server.webserver.https.port=7473 > # Certificate location (auto generated if the file does not exist) org.neo4j.server.webserver.https.cert.location=conf/ssl/snakeoil.cert > # Private key location (auto generated if the file does not exist) org.neo4j.server.webserver.https.key.location=conf/ssl/snakeoil.key > # Internally generated keystore (don't try to put your own # keystore there, it will get deleted when the server starts) org.neo4j.server.webserver.https.keystore.location=data/keystore > #***************************************************************** # Administration client configuration #***************************************************************** > # location of the servers round-robin database directory. possible values: # - absolute path like /var/rrd # - path relative to the server working directory like data/rrd # - commented out, will default to the database data directory. org.neo4j.server.webadmin.rrdb.location=data/rrd > # REST endpoint for the data API # Note the / in the end is mandatory org.neo4j.server.webadmin.data.uri=/db/data/ > # REST endpoint of the administration API (used by Webadmin) org.neo4j.server.webadmin.management.uri=/db/manage/ > # Low-level graph engine tuning file org.neo4j.server.db.tuning.properties=conf/neo4j.properties > > # The console services to be enabled org.neo4j.server.manage.console_engines=shell > # Allowed values: # HA - High Availability # SINGLE - Single mode, default. # To run in High Availability mode, configure the # neo4j.properties config file, then uncomment this line: org.neo4j.server.database.mode=SINGLE > # Comma separated list of JAX-RS packages containing JAX-RS resources, one # package name for each mountpoint. The listed package names will be loaded # under the mountpoints specified. Uncomment this line to mount the # org.neo4j.examples.server.unmanaged.HelloWorldResource.java from # neo4j-examples under /examples/unmanaged, resulting in a final URL of # http://localhost:7474/examples/unmanaged/helloworld/{nodeId} #org.neo4j.server.thirdparty_jaxrs_classes=org.neo4j.examples.server.unmanaged=/examples/unmanaged > > #***************************************************************** # HTTP logging configuration #***************************************************************** > # HTTP logging is disabled. HTTP logging can be enabled by setting this # property to 'true'. org.neo4j.server.http.log.enabled=False > # Logging policy file that governs how HTTP log output is presented and # archived. Note: changing the rollover and retention policy is sensible, > but # changing the output format is less so, since it is configured to use the # ubiquitous common log format org.neo4j.server.http.log.config=conf/neo4j-http-logging.xml > org.neo4j.server.webserver.limit.executiontime=60000 root@precise64:/home/vagrant# cat /etc/neo4j/neo4j-wrapper.conf wrapper.java.additional=-Dorg.neo4j.server.properties=conf/neo4j-server.properties wrapper.java.additional=-Djava.util.logging.config.file=conf/logging.properties wrapper.java.additional=-Dlog4j.configuration=file:conf/log4j.properties > # Java Additional Parameters wrapper.java.additional=-XX:+UseConcMarkSweepGC wrapper.java.additional=-XX:+CMSClassUnloadingEnabled > # Remote JMX monitoring, uncomment and adjust the following lines as > needed. # Also make sure to update the jmx.access and jmx.password files with > appropriate permission roles and passwords, # the shipped configuration contains only a read only role called 'monitor' > with password 'Neo4j'. # For more details, see: > http://download.oracle.com/javase/6/docs/technotes/guides/management/agent.html # On Unix based systems the jmx.password file needs to be owned by the user > that will run the server, # and have permissions set to 0600. # For details on setting these file permissions on Windows see: # > http://download.oracle.com/javase/1.5.0/docs/guide/management/security-windows.html #wrapper.java.additional=-Dcom.sun.management.jmxremote.port=3637 #wrapper.java.additional=-Dcom.sun.management.jmxremote.authenticate=true #wrapper.java.additional=-Dcom.sun.management.jmxremote.ssl=false #wrapper.java.additional=-Dcom.sun.management.jmxremote.password.file=conf/jmx.password #wrapper.java.additional=-Dcom.sun.management.jmxremote.access.file=conf/jmx.access > # Some systems cannot discover host name automatically, and need this line > configured: #wrapper.java.additional=-Djava.rmi.server.hostname=$THE_NEO4J_SERVER_HOSTNAME > # Uncomment the following lines to enable garbage collection logging wrapper.java.additional=-Xloggc:data/log/neo4j-gc.log wrapper.java.additional=-XX:+PrintGCDetails wrapper.java.additional=-XX:+PrintGCDateStamps wrapper.java.additional=-XX:+PrintGCApplicationStoppedTime wrapper.java.additional=-XX:+PrintTenuringDistribution > # Initial Java Heap Size (in MB) wrapper.java.initmemory=1500 > # Maximum Java Heap Size (in MB) wrapper.java.maxmemory=1500 > # Application parameters. Add parameters as needed starting from 1 wrapper.java.app.mainclass=org.neo4j.server.Bootstrapper > # both pidfile and lockfile are relative to the bin dir wrapper.pidfile=../data/neo4j-server.pid wrapper.lockfile=../data/neo4j-server.lck > #******************************************************************** # Wrapper Windows NT/2000/XP Service Properties #******************************************************************** # WARNING - Do not modify any of these properties when an application # using this configuration file has been installed as a service. # Please uninstall the service before modifying this section. The # service can then be reinstalled. > # Name of the service wrapper.name=neo4j > # User account to be used for linux installs. Will default to current # user if not set. wrapper.user=neo4j wrapper.user.created=false It's virtualbox os with 4G ram: > Linux precise64 3.2.0-23-generic #36-Ubuntu SMP Tue Apr 10 20:39:51 UTC > 2012 x86_64 x86_64 x86_64 GNU/Linux > Any ideas? -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
