{Denodo}サーバー構成

https://community.denodo.com/docs/html/browse/8.0/jp/vdp/administration/server_configuration/server_configuration

-- 1. キャッシュの構成

SET 'com.denodo.vdb.cache.cacheStatus' = 'ON';
SET 'com.denodo.vdb.cache.cacheMaintenance' = 'ON';
SET 'com.denodo.vdb.cache.cacheMaintainerPeriodInSecs' = '21600';
SET 'com.denodo.vdb.cache.timeToLiveInSecs' = '3600';

-- 2. 同時リクエスト数の制限

SET 'com.denodo.vdb.interpreter.execution.processor.VDBActionProcessor.concurrentQueriesLimit' = 'ON';
SET 'com.denodo.vdb.interpreter.execution.processor.VDBActionProcessor.maxConcurrentQueries' = '100';

SET 'com.denodo.vdb.interpreter.execution.processor.VDBActionProcessor.waitingQueriesLimit' = 'ON';
SET 'com.denodo.vdb.interpreter.execution.processor.VDBActionProcessor.maxWaitingQueries' = '500';

-- 3. デフォルトロケールの構成
SET 'com.denodo.vdb.misc.I18nParametersManager.i18nDefault' = 'jp';
SET 'com.denodo.wsgenerator.restfulws.timezone' = 'GMT';

-- 4. ID の文字セット

SET 'com.denodo.vdb.catalog.database.identifiersCharset' = 'restricted';

-- 5. メモリ使用量とスワップポリシーの構成

SET 'com.denodo.vdb.engine.session.restriction.ResourceManagerEngine.resourceManagerStatus' = 'ON';
SET 'com.denodo.vdb.engine.resource.queryMemoryLimit' = '200';
SET 'com.denodo.vdb.engine.RowQueueSizeInMB' = '10';

SET 'com.denodo.vdb.engine.swap.SwapManager.swappingStatus' = 'ON';
SET 'com.denodo.vdb.engine.swap.SwapManager.maxBlockSizeInKB' = '200';
SET 'com.denodo.vdb.engine.swap.SwapManager.swappingResultMaxSizeInMB' = '50';

-- 6. クエリの最適化

SET 'com.denodo.vdb.interpreter.execution.SelectAction.costoptimization' = 'false';
SET 'com.denodo.vdb.interpreter.execution.SelectAction.simplify' = 'true';
SET 'com.denodo.vdb.interpreter.execution.SelectAction.summaryRewrite' = 'true';
SET 'com.denodo.vdb.interpreter.execution.SelectAction.dataMovement' = 'true';

SET 'queryOptimization.parallelProcessing.enabled' = 'false';
SET 'queryOptimization.parallelProcessing.dataSource' = 'cache';
SET 'queryOptimization.parallelProcessing.customDataSource.databaseName' = '';
SET 'queryOptimization.parallelProcessing.customDataSource.dataSourceName' = '';

-- 7. ストアドプロシージャのランタイムパラメータの構成

SET 'storedProcedures.defaultQueryTimeout' = '80000';
SET 'storedProcedures.defaultChunkTimeout' = '80000';
SET 'storedProcedures.defaultChunkSize' = '100';

-- 8. スレッドプール

SET 'com.denodo.vdb.engine.thread.ThreadPool.maxThreads' = '300';
SET 'com.denodo.vdb.engine.thread.ThreadPool.expirationTime' = '600000';
SET 'com.denodo.vdb.engine.thread.ThreadPool.sleepTime' = '300000';
SET 'com.denodo.vdb.engine.thread.ThreadPool.timeout' = '43200000';
SET 'com.denodo.vdb.engine.thread.ThreadPool.checkoutTime' = '30000';