orientdb: OrientDB 3.0.3 slowdown
OrientDB Version: 3.0.3-SNAPSHOT
Java Version: 1.8.0_161
OS: Ubuntun 16.04
Hi OrientDB team !
Because of some refactoring, we needed to switch from OrientDB v2.2.30 to OrientDB v3.0.3. The OSQL parser had lots of issues in version prior to 3.0.0 and its much better now, thank you for that. Now, we encountered a new problem, we have performance requirements and those are not met since we switched to OrientDB v3.0.3.
As a warning, we took a SNAPSHOT version, so it might be related to that but still.
When i ran the tests i noticed it was slower than usual but it didn’t bothered me in particular but some tests crashed because of execution timeouts. So i went ahead and made some very simple benchmark to compare the speed of OrientDB v2.2.30 against v.3.0.3
TestClass with OrientDB 2.2.30 : 22.462s TestClass with OrientDB 3.0.3 : 52.127s
I did not made the full procecure, running over 10 times the same piece of code with having the cache refreshed and so on. But it is representative enough to show a real problem. The only thing that changed between the two tests is the OrientDB version (both for the client and the server, i started with OrientDB v.2.2.30, shut it down when i finished and booted right after that OrientDB v.3.0.3) and replacing OResultSet with OBasicLegacyResultSet.
There are no fine tuning anywhere (to my knowledge at least), the only configuration I did is adding credentials for logging as root user. That’s it.
Here are the result of the config command in both servers :
> OrientDB v2.2.30
> +----+---------------------------------------------------+---------------------------------------------------------------------------------------+
> |# |NAME |VALUE |
> +----+---------------------------------------------------+---------------------------------------------------------------------------------------+
> |0 |environment.dumpCfgAtStartup |false |
> |1 |environment.concurrent |true |
> |2 |environment.lockManager.concurrency.level |64 |
> |3 |environment.allowJVMShutdown |true |
> |4 |script.pool.maxSize |20 |
> |5 |memory.useUnsafe |true |
> |6 |memory.chunk.size |2147483647 |
> |7 |memory.directMemory.safeMode |true |
> |8 |memory.directMemory.trackMode |false |
> |9 |memory.directMemory.onlyAlignedMemoryAccess |true |
> |10 |jvm.gc.delayForOptimize |600 |
> |11 |storage.openFiles.limit |512 |
> |12 |storage.componentsLock.cache |10000 |
> |13 |storage.diskCache.pinnedPages |20 |
> |14 |storage.diskCache.bufferSize |4096 |
> |15 |storage.diskCache.writeCachePart |15 |
> |16 |storage.diskCache.writeCachePageTTL |86400 |
> |17 |storage.diskCache.writeCachePageFlushInterval |25 |
> |18 |storage.diskCache.writeCacheFlushInactivityInterval|60000 |
> |19 |storage.diskCache.writeCacheFlushLockTimeout |-1 |
> |20 |storage.diskCache.diskFreeSpaceCheckInterval |5 |
> |21 |storage.diskCache.diskFreeSpaceCheckIntervalInPages|2048 |
> |22 |storage.diskCache.keepState |true |
> |23 |storage.diskCache.checksumMode |StoreAndSwitchReadOnlyMode |
> |24 |storage.configuration.syncOnUpdate |true |
> |25 |storage.compressionMethod |nothing |
> |26 |storage.encryptionMethod |nothing |
> |27 |storage.encryptionKey | |
> |28 |storage.makeFullCheckpointAfterCreate |false |
> |29 |storage.makeFullCheckpointAfterOpen |false |
> |30 |storage.makeFullCheckpointAfterClusterCreate |true |
> |31 |storage.trackChangedRecordsInWAL |false |
> |32 |storage.useWAL |true |
> |33 |storage.wal.syncOnPageFlush |true |
> |34 |storage.wal.cacheSize |3000 |
> |35 |storage.wal.fileAutoCloseInterval |10 |
> |36 |storage.wal.maxSegmentSize |128 |
> |37 |storage.wal.maxSize |4096 |
> |38 |storage.wal.commitTimeout |1000 |
> |39 |storage.wal.shutdownTimeout |10000 |
> |40 |storage.wal.fuzzyCheckpointInterval |300 |
> |41 |storage.wal.reportAfterOperationsDuringRestore |10000 |
> |42 |storage.wal.restore.batchSize |1000 |
> |43 |storage.wal.readCacheSize |1000 |
> |44 |storage.wal.fuzzyCheckpointShutdownWait |600 |
> |45 |storage.wal.fullCheckpointShutdownTimeout |600 |
> |46 |storage.wal.path | |
> |47 |storage.diskCache.pageSize |64 |
> |48 |storage.diskCache.diskFreeSpaceLimit |256 |
> |49 |storage.lowestFreeListBound |16 |
> |50 |storage.lockTimeout |0 |
> |51 |storage.record.lockTimeout |2000 |
> |52 |storage.useTombstones |false |
> |53 |record.downsizing.enabled |true |
> |54 |object.saveOnlyDirty |false |
> |55 |db.pool.min |1 |
> |56 |db.pool.max |100 |
> |57 |db.pool.idleTimeout |0 |
> |58 |db.pool.idleCheckDelay |0 |
> |59 |db.mvcc.throwfast |false |
> |60 |db.validation |true |
> |61 |nonTX.recordUpdate.synch |false |
> |62 |nonTX.clusters.sync.immediately |manindex |
> |63 |tx.trackAtomicOperations |false |
> |64 |tx.pageCacheSize |12 |
> |65 |index.embeddedToSbtreeBonsaiThreshold |40 |
> |66 |index.sbtreeBonsaiToEmbeddedThreshold |-1 |
> |67 |hashTable.slitBucketsBuffer.length |1500 |
> |68 |index.auto.synchronousAutoRebuild |true |
> |69 |index.auto.lazyUpdates |10000 |
> |70 |index.flushAfterCreate |true |
> |71 |index.manual.lazyUpdates |1 |
> |72 |index.durableInNonTxMode |true |
> |73 |index.ignoreNullValuesDefault |false |
> |74 |index.txMode |FULL |
> |75 |index.cursor.prefetchSize |10000 |
> |76 |sbtree.maxDepth |64 |
> |77 |sbtree.maxKeySize |10240 |
> |78 |sbtree.maxEmbeddedValueSize |40960 |
> |79 |sbtreebonsai.bucketSize |2 |
> |80 |sbtreebonsai.linkBagCache.size |100000 |
> |81 |sbtreebonsai.linkBagCache.evictionSize |1000 |
> |82 |sbtreebonsai.freeSpaceReuseTrigger |0.5 |
> |83 |ridBag.embeddedDefaultSize |4 |
> |84 |ridBag.embeddedToSbtreeBonsaiThreshold |2147483647 |
> |85 |ridBag.sbtreeBonsaiToEmbeddedToThreshold |-1 |
> |86 |collections.preferSBTreeSet |false |
> |87 |file.trackFileClose |false |
> |88 |file.lock |true |
> |89 |file.deleteDelay |10 |
> |90 |file.deleteRetry |50 |
> |91 |security.userPasswordSaltIterations |65536 |
> |92 |security.userPasswordSaltCacheSize |500 |
> |93 |security.userPasswordDefaultAlgorithm |PBKDF2WithHmacSHA256 |
> |94 |network.maxConcurrentSessions |1000 |
> |95 |network.socketBufferSize |0 |
> |96 |network.lockTimeout |15000 |
> |97 |network.socketTimeout |15000 |
> |98 |network.requestTimeout |3600000 |
> |99 |network.retry.strategy |auto |
> |100 |network.retry |5 |
> |101 |network.retryDelay |500 |
> |102 |network.binary.loadBalancing.enabled |false |
> |103 |network.binary.loadBalancing.timeout |2000 |
> |104 |network.binary.maxLength |16384 |
> |105 |network.binary.readResponse.maxTimes |20 |
> |106 |network.binary.debug |false |
> |107 |network.http.installDefaultCommands |true |
> |108 |network.http.serverInfo |OrientDB Server v.2.2.30 (build 43d850df23c0fd1edca7279761c2238fdc6cc576, branch 2.2.x)|
> |109 |network.http.maxLength |1000000 |
> |110 |network.http.streaming |false |
> |111 |network.http.charset |utf-8 |
> |112 |network.http.jsonResponseError |true |
> |113 |network.http.jsonp |false |
> |114 |network.http.sessionExpireTimeout |300 |
> |115 |network.http.useToken |false |
> |116 |network.token.secretKey | |
> |117 |network.token.encryptionAlgorithm |HmacSHA256 |
> |118 |network.token.expireTimeout |60 |
> |119 |profiler.enabled |false |
> |120 |profiler.config | |
> |121 |profiler.autoDump.interval |0 |
> |122 |profiler.autoDump.type |full |
> |123 |profiler.maxValues |200 |
> |124 |profiler.memoryCheckInterval |120000 |
> |125 |sequence.maxRetry |100 |
> |126 |sequence.retryDelay |200 |
> |127 |storageProfiler.intervalBetweenSnapshots |100 |
> |128 |storageProfiler.cleanUpInterval |5000 |
> |129 |log.console.level |info |
> |130 |log.file.level |info |
> |131 |class.minimumClusters |0 |
> |132 |log.console.ansi |auto |
> |133 |cache.local.impl |com.orientechnologies.orient.core.cache.ORecordCacheWeakRefs |
> |134 |command.timeout |0 |
> |135 |command.cache.enabled |false |
> |136 |command.cache.evictStrategy |PER_CLUSTER |
> |137 |command.cache.minExecutionTime |10 |
> |138 |command.cache.maxResultsetSize |500 |
> |139 |query.parallelAuto |false |
> |140 |query.parallelMinimumRecords |300000 |
> |141 |query.parallelResultQueueSize |20000 |
> |142 |query.scanPrefetchPages |20 |
> |143 |query.scanBatchSize |1000 |
> |144 |query.scanThresholdTip |50000 |
> |145 |query.limitThresholdTip |10000 |
> |146 |query.live.support |true |
> |147 |query.timeout.defaultStrategy |EXCEPTION |
> |148 |lucene.query.pageSize |10000 |
> |149 |statement.cacheSize |100 |
> |150 |sql.graphConsistencyMode |tx |
> |151 |client.channel.maxPool |100 |
> |152 |client.connectionPool.waitTimeout |5000 |
> |153 |client.channel.dbReleaseWaitTimeout |10000 |
> |154 |client.ssl.enabled |false |
> |155 |client.ssl.keyStore | |
> |156 |client.ssl.keyStorePass | |
> |157 |client.ssl.trustStore | |
> |158 |client.ssl.trustStorePass | |
> |159 |server.openAllDatabasesAtStartup |false |
> |160 |server.channel.cleanDelay |5000 |
> |161 |server.cache.staticFile |false |
> |162 |server.log.dumpClientExceptionLevel |FINE |
> |163 |server.log.dumpClientExceptionFullStackTrace |false |
> |164 |distributed.dumpStatsEvery |0 |
> |165 |distributed.crudTaskTimeout |10000 |
> |166 |distributed.maxStartupDelay |10000 |
> |167 |distributed.commandTaskTimeout |120000 |
> |168 |distributed.commandQuickTaskTimeout |5000 |
> |169 |distributed.commandLongTaskTimeout |86400000 |
> |170 |distributed.deployDbTaskTimeout |1200000 |
> |171 |distributed.deployChunkTaskTimeout |60000 |
> |172 |distributed.deployDbTaskCompression |7 |
> |173 |distributed.asynchQueueSize |0 |
> |174 |distributed.asynchResponsesTimeout |15000 |
> |175 |distributed.purgeResponsesTimerDelay |15000 |
> |176 |distributed.conflictResolverRepairerChain |quorum,content,majority,version |
> |177 |distributed.conflictResolverRepairerCheckEvery |5000 |
> |178 |distributed.conflictResolverRepairerBatch |50 |
> |179 |distributed.txAliveTimeout |30000 |
> |180 |distributed.requestChannels |1 |
> |181 |distributed.responseChannels |1 |
> |182 |distributed.queueTimeout |15000 |
> |183 |distributed.heartbeatTimeout |10000 |
> |184 |distributed.checkHealthCanOfflineServer |false |
> |185 |distributed.checkHealthEvery |10000 |
> |186 |distributed.autoRemoveOfflineServers |0 |
> |187 |distributed.publishNodeStatusEvery |10000 |
> |188 |distributed.localQueueSize |10000 |
> |189 |distributed.dbWorkerThreads |0 |
> |190 |distributed.queueMaxSize |10000 |
> |191 |distributed.backupDirectory |../backup/databases |
> |192 |distributed.backupTryIncrementalFirst |true |
> |193 |distributed.checkIntegrityLastTxs |16 |
> |194 |distributed.concurrentTxMaxAutoRetry |15 |
> |195 |distributed.atomicLockTimeout |1000 |
> |196 |distributed.concurrentTxAutoRetryDelay |10 |
> |197 |db.document.serializer |ORecordSerializerBinary |
> |198 |client.krb5.config | |
> |199 |client.krb5.ccname | |
> |200 |client.krb5.ktname | |
> |201 |client.credentialinterceptor | |
> |202 |client.ci.keyalgorithm |AES |
> |203 |client.ci.ciphertransform |AES/CBC/PKCS5Padding |
> |204 |client.ci.keystore.file | |
> |205 |client.ci.keystore.password | |
> |206 |security.createDefaultUsers |true |
> |207 |server.security.file | |
> |208 |jna.disable.system.library |true |
> |209 |db.makeFullCheckpointOnIndexChange |true |
> |210 |db.makeFullCheckpointOnSchemaChange |true |
> |211 |client.session.tokenBased |true |
> |212 |oauth2.secretkey | |
> |213 |storage.cluster.usecrc32 |false |
> |214 |lazyset.workOnStream |true |
> |215 |db.mvcc |true |
> |216 |db.use.distributedVersion |false |
> |217 |mvrbtree.timeout |0 |
> |218 |mvrbtree.nodePageSize |256 |
> |219 |mvrbtree.loadFactor |0.7 |
> |220 |mvrbtree.optimizeThreshold |100000 |
> |221 |mvrbtree.entryPoints |64 |
> |222 |mvrbtree.optimizeEntryPointsFactor |1.0 |
> |223 |mvrbtree.entryKeysInMemory |false |
> |224 |mvrbtree.entryValuesInMemory |false |
> |225 |mvrbtree.ridBinaryThreshold |-1 |
> |226 |mvrbtree.ridNodePageSize |64 |
> |227 |mvrbtree.ridNodeSaveMemory |false |
> |228 |tx.commit.synch |false |
> |229 |tx.autoRetry |1 |
> |230 |tx.log.fileType |classic |
> |231 |tx.log.synch |false |
> |232 |tx.useLog |true |
> |233 |index.auto.rebuildAfterNotSoftClose |true |
> |234 |client.channel.minPool |1 |
> |235 |storage.keepOpen |true |
> |236 |cache.local.enabled |true |
> +----+---------------------------------------------------+---------------------------------------------------------------------------------------+
>
>
>
>
>
>
> OrientDB v3.0.3-SNAPSHOT
> +----+------------------------------------------+------------------------------------------------------------------------------------------------+
> |# |NAME |VALUE |
> +----+------------------------------------------+------------------------------------------------------------------------------------------------+
> |0 |network.binary.maxLength |16384 |
> |1 |distributed.autoRemoveOfflineServers |0 |
> |2 |index.sbtreeBonsaiToEmbeddedThreshold |-1 |
> |3 |server.database.path | |
> |4 |security.userPasswordSaltCacheSize |500 |
> |5 |distributed.dumpStatsEvery |0 |
> |6 |distributed.asynchResponsesTimeout |15000 |
> |7 |sbtree.maxEmbeddedValueSize |40960 |
> |8 |storage.diskCache.writeCacheFlushInacti...|60000 |
> |9 |network.http.installDefaultCommands |true |
> |10 |tx.commit.synch |false |
> |11 |security.userPasswordSaltIterations |65536 |
> |12 |statement.cacheSize |100 |
> |13 |security.userPasswordDefaultAlgorithm |PBKDF2WithHmacSHA256 |
> |14 |network.socketTimeout |15000 |
> |15 |cache.local.impl |com.orientechnologies.orient.core.cache.ORecordCacheWeakRefs |
> |16 |client.channel.minPool |1 |
> |17 |network.socketBufferSize |0 |
> |18 |distributed.publishNodeStatusEvery |10000 |
> |19 |storage.trackChangedRecordsInWAL |true |
> |20 |log.console.level |info |
> |21 |query.parallelResultQueueSize |20000 |
> |22 |environment.dumpCfgAtStartup |false |
> |23 |sequence.retryDelay |200 |
> |24 |distributed.backupDirectory |../backup/databases |
> |25 |storage.configuration.syncOnUpdate |true |
> |26 |network.retryDelay |500 |
> |27 |db.makeFullCheckpointOnIndexChange |true |
> |28 |network.http.charset |utf-8 |
> |29 |command.cache.enabled |false |
> |30 |distributed.concurrentTxAutoRetryDelay |100 |
> |31 |sbtreebonsai.bucketSize |2 |
> |32 |storage.useWAL |true |
> |33 |network.http.streaming |false |
> |34 |storage.openFiles.limit |-1 |
> |35 |storage.wal.readCacheSize |1000 |
> |36 |db.mvcc.throwfast |false |
> |37 |index.embeddedToSbtreeBonsaiThreshold |40 |
> |38 |db.validation |true |
> |39 |server.openAllDatabasesAtStartup |false |
> |40 |storage.diskCache.keepState |true |
> |41 |distributed.txAliveTimeout |30000 |
> |42 |command.cache.maxResultsetSize |500 |
> |43 |profiler.autoDump.type |full |
> |44 |distributed.asynchQueueSize |0 |
> |45 |db.use.distributedVersion |false |
> |46 |network.http.serverInfo |OrientDB Server v.3.0.3-SNAPSHOT - Veloce (build 1fc192a43baab3eaf9a92579d2dc330a4343270b, br...|
> |47 |client.ci.ciphertransform |AES/CBC/PKCS5Padding |
> |48 |storage.wal.reportAfterOperationsDuring...|10000 |
> |49 |server.log.dumpClientExceptionFullStack...|false |
> |50 |jna.disable.system.library |true |
> |51 |storage.trackFileAccess |true |
> |52 |distributed.checkIntegrityLastTxs |16 |
> |53 |environment.concurrent |true |
> |54 |network.token.secretKey | |
> |55 |index.manual.lazyUpdates |1 |
> |56 |tx.autoRetry |1 |
> |57 |storage.compressionMethod |nothing |
> |58 |storage.wal.restore.batchSize |50000 |
> |59 |query.limitThresholdTip |10000 |
> |60 |distributed.deployDbTaskCompression |7 |
> |61 |index.ignoreNullValuesDefault |false |
> |62 |storage.diskCache.pinnedPages |20 |
> |63 |storage.diskCache.bufferSize |9954 |
> |64 |distributed.deployDbTaskTimeout |1200000 |
> |65 |client.ssl.trustStorePass | |
> |66 |memory.directMemory.safeMode |true |
> |67 |distributed.responseChannels |1 |
> |68 |storage.diskCache.exclusiveFlushBoundary |0.9 |
> |69 |orient.initInServletContextListener |true |
> |70 |storage.wal.segmentBufferSize |32 |
> |71 |file.lock |true |
> |72 |network.http.jsonResponseError |true |
> |73 |query.parallelAuto |false |
> |74 |log.console.ansi |auto |
> |75 |network.token.expireTimeout |60 |
> |76 |distributed.commandTaskTimeout |120000 |
> |77 |cloud.base.url |cloud.orientdb.com |
> |78 |distributed.maxStartupDelay |10000 |
> |79 |distributed.conflictResolverRepairerBatch |1000 |
> |80 |sbtree.maxKeySize |10240 |
> |81 |network.binary.readResponse.maxTimes |20 |
> |82 |file.trackFileClose |false |
> |83 |network.http.useToken |false |
> |84 |memory.leftToOS |2g |
> |85 |sql.graphConsistencyMode |tx |
> |86 |storage.makeFullCheckpointAfterClusterC...|true |
> |87 |nonTX.clusters.sync.immediately |manindex |
> |88 |storage.encryptionKey |<hidden> |
> |89 |storage.wal.commitTimeout |1000 |
> |90 |network.retry |5 |
> |91 |query.remoteResultSet.pageSize |100 |
> |92 |distributed.commandLongTaskTimeout |86400000 |
> |93 |storage.lowestFreeListBound |16 |
> |94 |profiler.memoryCheckInterval |120000 |
> |95 |storage.wal.shutdownTimeout |10000 |
> |96 |storage.diskCache.exclusiveBoundary |0.7 |
> |97 |distributed.queueMaxSize |10000 |
> |98 |client.ssl.trustStore | |
> |99 |document.binaryMapping |0 |
> |100 |index.auto.synchronousAutoRebuild |true |
> |101 |network.http.sessionExpireTimeout |900 |
> |102 |storage.diskCache.writeCachePart |15 |
> |103 |storage.record.lockTimeout |2000 |
> |104 |log.file.level |info |
> |105 |distributed.checkHealthCanOfflineServer |false |
> |106 |file.deleteDelay |10 |
> |107 |memory.chunk.size |2147483647 |
> |108 |network.binary.loadBalancing.enabled |false |
> |109 |network.binary.loadBalancing.timeout |2000 |
> |110 |db.pool.idleTimeout |0 |
> |111 |command.cache.minExecutionTime |10 |
> |112 |storage.wal.syncOnPageFlush |true |
> |113 |sbtreebonsai.linkBagCache.size |100000 |
> |114 |server.cache.staticFile |false |
> |115 |record.downsizing.enabled |true |
> |116 |distributed.backupTryIncrementalFirst |true |
> |117 |client.krb5.ccname | |
> |118 |ridBag.embeddedToSbtreeBonsaiThreshold |2147483647 |
> |119 |jvm.gc.delayForOptimize |600 |
> |120 |db.document.serializer |ORecordSerializerBinary |
> |121 |file.deleteRetry |50 |
> |122 |storage.exclusiveFileAccess |true |
> |123 |memory.directMemory.trackMode |false |
> |124 |network.http.maxLength |1000000 |
> |125 |server.log.dumpClientExceptionLevel |FINE |
> |126 |query.scanBatchSize |1000 |
> |127 |storage.diskCache.writeCachePageTTL |86400 |
> |128 |sbtreebonsai.linkBagCache.evictionSize |1000 |
> |129 |db.makeFullCheckpointOnSchemaChange |true |
> |130 |tx.useLog |true |
> |131 |distributed.conflictResolverRepairerChain |majority,content,version |
> |132 |distributed.heartbeatTimeout |10000 |
> |133 |network.lockTimeout |15000 |
> |134 |distributed.purgeResponsesTimerDelay |15000 |
> |135 |profiler.enabled |false |
> |136 |query.remoteResultSet.sendExecutionPlan |false |
> |137 |tx.log.synch |false |
> |138 |storage.encryptionMethod |nothing |
> |139 |storage.diskCache.diskFreeSpaceCheckInt...|5 |
> |140 |client.channel.maxPool |100 |
> |141 |query.scanPrefetchPages |20 |
> |142 |query.live.support |true |
> |143 |server.channel.cleanDelay |5000 |
> |144 |script.pool.maxSize |20 |
> |145 |client.channel.dbReleaseWaitTimeout |10000 |
> |146 |storage.wal.cacheSize |3000 |
> |147 |environment.allowJVMShutdown |true |
> |148 |cloud.project.token | |
> |149 |distributed.crudTaskTimeout |3000 |
> |150 |client.krb5.ktname | |
> |151 |distributed.conflictResolverRepairerChe...|5000 |
> |152 |tx.pageCacheSize |12 |
> |153 |command.timeout |0 |
> |154 |client.ci.keystore.file | |
> |155 |index.auto.rebuildAfterNotSoftClose |true |
> |156 |storage.wal.path | |
> |157 |network.requestTimeout |3600000 |
> |158 |storage.diskCache.diskFreeSpaceLimit |1024 |
> |159 |query.parallelMinimumRecords |300000 |
> |160 |network.binary.minProtocolVersion |26 |
> |161 |query.scanThresholdTip |50000 |
> |162 |index.cursor.prefetchSize |10000 |
> |163 |memory.directMemory.onlyAlignedMemoryAc...|true |
> |164 |storage.useTombstones |false |
> |165 |distributed.dbWorkerThreads |0 |
> |166 |sequence.maxRetry |100 |
> |167 |object.saveOnlyDirty |false |
> |168 |sbtree.maxDepth |64 |
> |169 |memory.pool.limit |256 |
> |170 |server.security.file | |
> |171 |storage.pessimisticLock |false |
> |172 |storage.makeFullCheckpointAfterCreate |false |
> |173 |storage.diskCache.diskFreeSpaceCheckInt...|2048 |
> |174 |db.pool.min |1 |
> |175 |client.credentialinterceptor | |
> |176 |distributed.commandQuickTaskTimeout |5000 |
> |177 |distributed.checkHealthEvery |10000 |
> |178 |network.binary.debug |false |
> |179 |cloud.project.id | |
> |180 |storage.wal.maxSize |-1 |
> |181 |security.createDefaultUsers |true |
> |182 |memory.useUnsafe |true |
> |183 |distributed.requestChannels |1 |
> |184 |server.backwardCompatibility |true |
> |185 |db.pool.max |100 |
> |186 |profiler.autoDump.interval |0 |
> |187 |index.txMode |FULL |
> |188 |index.flushAfterCreate |true |
> |189 |storage.diskCache.chunkSize |256 |
> |190 |client.connection.strategy | |
> |191 |client.ssl.enabled |false |
> |192 |storage.wal.fullCheckpointShutdownTimeout |600 |
> |193 |client.krb5.config | |
> |194 |client.ci.keystore.password | |
> |195 |storage.wal.fuzzyCheckpointInterval |300 |
> |196 |class.minimumClusters |0 |
> |197 |storage.internal.journaled.tx.streaming...| |
> |198 |storage.wal.maxSegmentSize |128 |
> |199 |distributed.deployChunkTaskTimeout |60000 |
> |200 |client.ssl.keyStore | |
> |201 |nonTX.recordUpdate.synch |false |
> |202 |network.http.jsonp |false |
> |203 |storage.diskCache.walSizeToStopFlush |2147483648 |
> |204 |distributed.atomicLockTimeout |1000 |
> |205 |ridBag.embeddedDefaultSize |4 |
> |206 |network.retry.strategy |auto |
> |207 |environment.lockManager.concurrency.level |64 |
> |208 |storage.diskCache.pageSize |64 |
> |209 |storageProfiler.intervalBetweenSnapshots |100 |
> |210 |client.connectionPool.waitTimeout |5000 |
> |211 |profiler.maxValues |200 |
> |212 |distributed.localQueueSize |10000 |
> |213 |storage.componentsLock.cache |10000 |
> |214 |storage.lockTimeout |0 |
> |215 |storage.wal.fuzzyCheckpointShutdownWait |600 |
> |216 |distributed.concurrentTxMaxAutoRetry |15 |
> |217 |index.durableInNonTxMode |true |
> |218 |hashTable.slitBucketsBuffer.length |1500 |
> |219 |index.auto.lazyUpdates |10000 |
> |220 |sbtreebonsai.freeSpaceReuseTrigger |0.5 |
> |221 |profiler.config | |
> |222 |client.ci.keyalgorithm |AES |
> |223 |tx.trackAtomicOperations |false |
> |224 |network.token.encryptionAlgorithm |HmacSHA256 |
> |225 |ridBag.sbtreeBonsaiToEmbeddedToThreshold |2147483647 |
> |226 |client.ssl.keyStorePass | |
> |227 |command.cache.evictStrategy |PER_CLUSTER |
> |228 |oauth2.secretkey | |
> |229 |storage.cluster.usecrc32 |false |
> |230 |storage.makeFullCheckpointAfterOpen |true |
> |231 |network.maxConcurrentSessions |1000 |
> |232 |storage.wal.fileAutoCloseInterval |10 |
> |233 |memory.leftToContainer |256m |
> |234 |distributed.queueTimeout |500000 |
> |235 |db.pool.idleCheckDelay |0 |
> |236 |storage.diskCache.checksumMode |StoreAndSwitchReadOnlyMode |
> |237 |storage.diskCache.writeCachePageFlushIn...|25 |
> |238 |storageProfiler.cleanUpInterval |5000 |
> |239 |storage.diskCache.writeCacheFlushLockTi...|-1 |
> |240 |storage.diskCache.walSizeToStartFlush |6442450944 |
> +----+------------------------------------------+------------------------------------------------------------------------------------------------+
>
Any idea, tips, about what is going on ? I don’t see any over explanation than right now, OrientDB is plain slow compared to what it was before and it is quite disappointing 😦
Best Regards,
Cyprien Gottstein.
About this issue
- Original URL
- State: closed
- Created 6 years ago
- Reactions: 1
- Comments: 16 (7 by maintainers)
Commits related to this issue
- avoided encryption of password client side for each session open, issue #8319 — committed to orientechnologies/orientdb by tglman 6 years ago
- made sure that the backward compatible pool reuse sessions, issue #8319 — committed to orientechnologies/orientdb by tglman 6 years ago
- made sure that the backward compatible pool reuse sessions, issue #8319 — committed to orientechnologies/orientdb by tglman 6 years ago
Hi All,
Fix for this cases have been released in 3.0.3 and 3.0.4 now the connect through pool has no delay. Closing this, feel free to re-open if you still see the problem.
Regards