バージョン 10 から バージョン 11 における更新: Virtuoso

差分発生行の前後
無視リスト:
更新日時:
2012/03/07 12:25:34 (13 年 前)
更新者:
wu
コメント:

--

凡例:

変更なし
追加
削除
変更

  • Virtuoso

    v10 v11  
    1 * [#Configure Virtuoso　配置] 
     1* [#Configure　Virtuoso　配置] 
    22 
    33* [#load Load performance]  
    … …  
    1313 
    1414 
    15 === Virtuoso　配置 === #Configure 
     15=== Virtuoso 配置 === #Configure 
    1616 
     17* NumberOfBuffers:  the amount of RAM used by Virtuoso to cache database files. This has a critical performance impact and thus the value should be fairly high for large databases. Exceeding physical memory in this setting will have a significant negative impact. For a database-only server about 65% of available RAM could be configured for database buffers. Each buffer caches one 8K page of data and occupies approximately 8700 bytes of memory. 
    1718 
     19* MaxCheckpointRemap:to avoid out of memory error, you should make sure the values for the paramaters NumberOfBuffers and MaxCheckpointRemap are not set with the same values. 
     20 
     21* AsyncQueueMaxThreads: the size of a pool of extra threads that can be used for query parallelization. This should be set to either 1.5 * the number of cores or 1.5 * the number of core threads; see which works better. 
     22 
     23* ThreadsPerQuery: the maximum number of threads a single query will take. This should be set to either the number of cores or the number of core threads; see which works better. 
     24 
     25* IndexTreeMaps: the number of mutexes over which control for buffering an index tree is split. This can generally be left at default (256 in normal operation; valid settings are powers of 2 from 2 to 1024), but setting to 64, 128, or 512 may be beneficial. A low number will lead to frequent contention; upwards of 64 will have little contention. 
     26 
     27* ThreadCleanupInterval & ResourcesCleanupInterval: Set both to 1 in order to reduce memory leaking. 
    1828 
    1929{{{ 
    20 JVM setting -Xmx55G -Xms30G -Druleset=empty -Dentity-index-size=1147483647 -Dcache-memory=26645m -Dtuple-index-memory=25G -DenablePredicateList=false  -DftsIndexPolicy=never -DftsLiteralsOnly=true -Dbuild-pcsot=false -Dbuild-ptsoc=false  -Djournaling=false -Drepository-type=file-repository  -XX:+UseG1GC -XX:+TieredCompilation -XX:+HeapDumpOnOutOfMemoryErro 
    21 r -Dentity-id-size=32   
     30NumberOfBuffers          = 6500000 
     31MaxDirtyBuffers          = 5000000 
     32MaxCheckpointRemap       = 1000000 
     33AsyncQueryMaxThreads     = 18 
     34ThreadsPerQuery          = 18 
     35IndexTreeMaps            = 512 
     36ThreadCleanupInterval    = 1 
     37ResourcesCleanupInterval = 1 
    2238}}} 
    2339 
    2440 
    25 More information please refer to [] 
     41More information please refer to [http://docs.openlinksw.com/virtuoso/databaseadmsrv.html] [http://www.openlinksw.com/weblog/oerling/?id=1665] 
    2642 
    2743