orientdb 1.6.4 and 1.7.9 I have a database with a couple of registered entities and one index on each entity. We use this as a cache for recording metric data for generating graphs (pictures, not models). Due to the occasional crash (intentional kill of the JVM, OOM, .dll problems...whatever). Because we are concerned about durability we have set the following: tx.commit.sync=true tx.log.sync=true index.auto.rebuildAfterNotSoftClose=true storage.compression.method=gzip memory.use.unsafe=false (for problems on solaris) file.mmap.strategy=4 (for problems with hangs on aix) Recently we have also added these two settings because the recovery log could end up gigabytes in size and take many hours to recover after running for a week or so. storage.wal.maxSegmentSize=32 storage.wal.maxSize=256 We are using plocal storage. The problem is that recovery time is so long due to the index rebuilds. Often it takes an hour or more to open the database and wait for automatic index rebuild. For our customers this is a problem. Most of our transactions are quite small, but there are a lot of them. Most updates are fewer than 5 documents, but every hour or so there may be a large change, or a large delete of many documents. We do have as many as 20 open database connections for simultaneous read/writes between threads. Most database updates use a transaction, but some do not due to a lot of conflict on some indexes timing out (design issue we're working to address). So...kinda random workload. Run time performance is perfectly fine so we're not concerned about that. So the question is: Is index rebuild important? With the write ahead log and synchronization turned on, can we dispose with index rebuild completely changing to speed up recovery times? If so can someone suggest some parameter changes to improve recovery times Are there are settings we can use to make index writes completely reliable and then turn off index rebuilds? How do we make opening the database faster after a crash? TIA
-- --- You received this message because you are subscribed to the Google Groups "OrientDB" 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.
