15972b5125
`MaxConstructTriples` needs to bumped to the same value as `ResultSetMaxRows` since `virtuoso` will check the value of the former variable first. By setting it to 10000, we were severely limiting the number of triples that can be constructed.
255 lines
8.4 KiB
INI
Executable File
255 lines
8.4 KiB
INI
Executable File
;
|
|
; virtuoso.ini
|
|
;
|
|
; Configuration file for the OpenLink Virtuoso VDBMS Server
|
|
;
|
|
; To learn more about this product, or any other product in our
|
|
; portfolio, please check out our web site at:
|
|
;
|
|
; http://virtuoso.openlinksw.com/
|
|
;
|
|
; or contact us at:
|
|
;
|
|
; general.information@openlinksw.com
|
|
;
|
|
; If you have any technical questions, please contact our support
|
|
; staff at:
|
|
;
|
|
; technical.support@openlinksw.com
|
|
;
|
|
;
|
|
; Database setup
|
|
;
|
|
[Database]
|
|
DatabaseFile = /usr/local/virtuoso-opensource/var/lib/virtuoso/db/virtuoso.db
|
|
ErrorLogFile = /usr/local/virtuoso-opensource/var/lib/virtuoso/db/virtuoso.log
|
|
LockFile = /usr/local/virtuoso-opensource/var/lib/virtuoso/db/virtuoso.lck
|
|
TransactionFile = /usr/local/virtuoso-opensource/var/lib/virtuoso/db/virtuoso.trx
|
|
xa_persistent_file = /usr/local/virtuoso-opensource/var/lib/virtuoso/db/virtuoso.pxa
|
|
ErrorLogLevel = 7
|
|
FileExtend = 200
|
|
MaxCheckpointRemap = 8500 ;;niels 1/4 of the number of buffers (assuming db uses most of the available buffers, you can check with `status()` in isql-v
|
|
Striping = 0
|
|
TempStorage = TempDatabase
|
|
Syslog = 1 ; write to syslog in case of failures where writing to log is not possible
|
|
|
|
[TempDatabase]
|
|
DatabaseFile = /usr/local/virtuoso-opensource/var/lib/virtuoso/db/virtuoso-temp.db
|
|
TransactionFile = /usr/local/virtuoso-opensource/var/lib/virtuoso/db/virtuoso-temp.trx
|
|
MaxCheckpointRemap = 2000
|
|
Striping = 0
|
|
|
|
;
|
|
; Server parameters
|
|
;
|
|
[Parameters]
|
|
ServerPort = 1111
|
|
LiteMode = 0
|
|
DisableUnixSocket = 1
|
|
DisableTcpSocket = 0
|
|
;SSLServerPort = 2111
|
|
;SSLCertificate = cert.pem
|
|
;SSLPrivateKey = pk.pem
|
|
;X509ClientVerify = 0
|
|
;X509ClientVerifyDepth = 0
|
|
;X509ClientVerifyCAFile = ca.pem
|
|
MaxClientConnections = 10
|
|
CheckpointInterval = 60
|
|
TraceOn = errors ; write traces
|
|
O_DIRECT = 0
|
|
CaseMode = 2
|
|
MaxStaticCursorRows = 5000
|
|
CheckpointAuditTrail = 0
|
|
AllowOSCalls = 0
|
|
SchedulerInterval = 10
|
|
DirsAllowed = ., /usr/local/virtuoso-opensource/share/virtuoso/vad
|
|
ThreadCleanupInterval = 10
|
|
ThreadThreshold = 10
|
|
ResourcesCleanupInterval = 10
|
|
FreeTextBatchSize = 100000
|
|
SingleCPU = 0
|
|
VADInstallDir = /usr/local/virtuoso-opensource/share/virtuoso/vad/
|
|
PrefixResultNames = 0
|
|
RdfFreeTextRulesSize = 100
|
|
IndexTreeMaps = 256
|
|
MaxMemPoolSize = 200000000
|
|
PrefixResultNames = 0
|
|
MacSpotlight = 0
|
|
MaxQueryMem = 2G
|
|
VectorSize = 1000 ; initial parallel query vector (array of query operations) size
|
|
MaxVectorSize = 1000000 ; query vector size threshold.
|
|
AdjustVectorSize = 0
|
|
ThreadsPerQuery = 4
|
|
AsyncQueueMaxThreads = 10
|
|
TransactionAfterImageLimit = 150000000 ; max 150MB transaction, total transient consumption is 450MB (roll forward + roll back)
|
|
;;
|
|
;; When running with large data sets, one should configure the Virtuoso
|
|
;; process to use between 2/3 to 3/5 of free system memory and to stripe
|
|
;; storage on all available disks.
|
|
;;
|
|
;; Uncomment next two lines if there is 2 GB system memory free
|
|
;;NumberOfBuffers = 170000
|
|
;;MaxDirtyBuffers = 130000
|
|
|
|
;; Uncomment next two lines if there is 4 GB system memory free
|
|
NumberOfBuffers = 340000
|
|
MaxDirtyBuffers = 250000
|
|
;; Uncomment next two lines if there is 8 GB system memory free
|
|
;NumberOfBuffers = 680000
|
|
;MaxDirtyBuffers = 500000
|
|
;; Uncomment next two lines if there is 16 GB system memory free
|
|
;NumberOfBuffers = 1360000
|
|
;MaxDirtyBuffers = 1000000
|
|
;; Uncomment next two lines if there is 32 GB system memory free
|
|
;NumberOfBuffers = 2720000
|
|
;MaxDirtyBuffers = 2000000
|
|
;; Uncomment next two lines if there is 48 GB system memory free
|
|
;NumberOfBuffers = 4000000
|
|
;MaxDirtyBuffers = 3000000
|
|
;; Uncomment next two lines if there is 64 GB system memory free
|
|
;NumberOfBuffers = 5450000
|
|
;MaxDirtyBuffers = 4000000
|
|
;;
|
|
;; Note the default settings will take very little memory
|
|
;; but will not result in very good performance
|
|
;;
|
|
;NumberOfBuffers = 10000
|
|
;MaxDirtyBuffers = 6000
|
|
|
|
;; Introduced after bug with export service
|
|
MaxSortedTopRows = 1000000 ; 1 million!
|
|
|
|
[HTTPServer]
|
|
ServerPort = 8890
|
|
ServerRoot = /usr/local/virtuoso-opensource/var/lib/virtuoso/vsp
|
|
MaxClientConnections = 10
|
|
DavRoot = DAV
|
|
EnabledDavVSP = 0
|
|
HTTPProxyEnabled = 0
|
|
TempASPXDir = 0
|
|
DefaultMailServer = localhost:25
|
|
ServerThreads = 10
|
|
MaxKeepAlives = 10
|
|
KeepAliveTimeout = 10
|
|
MaxCachedProxyConnections = 10
|
|
ProxyConnectionCacheTimeout = 15
|
|
HTTPThreadSize = 280000
|
|
HttpPrintWarningsInOutput = 0
|
|
Charset = UTF-8
|
|
;;HTTPLogFile = http.log
|
|
MaintenancePage = atomic.html
|
|
EnabledGzipContent = 1
|
|
|
|
[AutoRepair]
|
|
BadParentLinks = 0
|
|
|
|
[Client]
|
|
SQL_PREFETCH_ROWS = 100
|
|
SQL_PREFETCH_BYTES = 16000
|
|
SQL_QUERY_TIMEOUT = 0
|
|
SQL_TXN_TIMEOUT = 0
|
|
;SQL_NO_CHAR_C_ESCAPE = 1
|
|
;SQL_UTF8_EXECS = 0
|
|
;SQL_NO_SYSTEM_TABLES = 0
|
|
;SQL_BINARY_TIMESTAMP = 1
|
|
;SQL_ENCRYPTION_ON_PASSWORD = -1
|
|
|
|
[VDB]
|
|
ArrayOptimization = 0
|
|
NumArrayParameters = 10
|
|
VDBDisconnectTimeout = 1000
|
|
KeepConnectionOnFixedThread = 0
|
|
|
|
[Replication]
|
|
ServerName = db-D602566B774E
|
|
ServerEnable = 1
|
|
QueueMax = 50000
|
|
|
|
;
|
|
; Striping setup
|
|
;
|
|
; These parameters have only effect when Striping is set to 1 in the
|
|
; [Database] section, in which case the DatabaseFile parameter is ignored.
|
|
;
|
|
; With striping, the database is spawned across multiple segments
|
|
; where each segment can have multiple stripes.
|
|
;
|
|
; Format of the lines below:
|
|
; Segment<number> = <size>, <stripe file name> [, <stripe file name> .. ]
|
|
;
|
|
; <number> must be ordered from 1 up.
|
|
;
|
|
; The <size> is the total size of the segment which is equally divided
|
|
; across all stripes forming the segment. Its specification can be in
|
|
; gigabytes (g), megabytes (m), kilobytes (k) or in database blocks
|
|
; (b, the default)
|
|
;
|
|
; Note that the segment size must be a multiple of the database page size
|
|
; which is currently 8k. Also, the segment size must be divisible by the
|
|
; number of stripe files forming the segment.
|
|
;
|
|
; The example below creates a 200 meg database striped on two segments
|
|
; with two stripes of 50 meg and one of 100 meg.
|
|
;
|
|
; You can always add more segments to the configuration, but once
|
|
; added, do not change the setup.
|
|
;
|
|
[Striping]
|
|
Segment1 = 100M, db-seg1-1.db, db-seg1-2.db
|
|
Segment2 = 100M, db-seg2-1.db
|
|
;...
|
|
;[TempStriping]
|
|
;Segment1 = 100M, db-seg1-1.db, db-seg1-2.db
|
|
;Segment2 = 100M, db-seg2-1.db
|
|
;...
|
|
;[Ucms]
|
|
;UcmPath = <path>
|
|
;Ucm1 = <file>
|
|
;Ucm2 = <file>
|
|
;...
|
|
|
|
[Zero Config]
|
|
ServerName = virtuoso (D602566B774E)
|
|
;ServerDSN = ZDSN
|
|
;SSLServerName =
|
|
;SSLServerDSN =
|
|
|
|
[Mono]
|
|
;MONO_TRACE = Off
|
|
;MONO_PATH = <path_here>
|
|
;MONO_ROOT = <path_here>
|
|
;MONO_CFG_DIR = <path_here>
|
|
;virtclr.dll =
|
|
|
|
[URIQA]
|
|
DynamicLocal = 0
|
|
DefaultHost = localhost:8890
|
|
|
|
[SPARQL]
|
|
;ExternalQuerySource = 1
|
|
;ExternalXsltSource = 1
|
|
;DefaultGraph = http://localhost:8890/dataspace
|
|
;ImmutableGraphs = http://localhost:8890/dataspace
|
|
ResultSetMaxRows = 1000000 ; 1 million
|
|
MaxConstructTriples = 1000000 ; More info on this addition here: https://github.com/redpencilio/docker-virtuoso/pull/29
|
|
;MaxQueryCostEstimationTime = 4000 ; in seconds
|
|
MaxQueryExecutionTime = 1200 ; in seconds
|
|
DefaultQuery = select distinct ?Concept where {[] a ?Concept} LIMIT 100
|
|
DeferInferenceRulesInit = 0 ; controls inference rules loading
|
|
MaxMemInUse = 0 ; limits the amount of memory for construct dict (0=unlimited). More info on this addition here: https://github.com/redpencilio/docker-virtuoso/pull/29
|
|
;PingService = http://rpc.pingthesemanticweb.com/
|
|
|
|
[Plugins]
|
|
LoadPath = /usr/local/virtuoso-opensource/lib/virtuoso/hosting
|
|
;Load1 = plain, wikiv
|
|
;Load2 = plain, mediawiki
|
|
;Load3 = plain, creolewiki
|
|
;Load4 = plain, im
|
|
;Load5 = plain, wbxml2
|
|
;Load6 = plain, hslookup
|
|
;Load7 = attach, libphp5.so
|
|
;Load8 = Hosting, hosting_php.so
|
|
;Load9 = Hosting,hosting_perl.so
|
|
;Load10 = Hosting,hosting_python.so
|
|
;Load11 = Hosting,hosting_ruby.so
|
|
;Load12 = msdtc,msdtc_sample |