API tools faq
paste
Advertisement
jbjares

virtuoso.ini

jbjares
Oct 28th, 2014
650
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 7.58 KB | None | 0 0
raw download clone embed print report
  1. ;
  2. ;  virtuoso.ini
  3. ;
  4. ;  Configuration file for the OpenLink Virtuoso VDBMS Server
  5. ;
  6. ;  To learn more about this product, or any other product in our
  7. ;  portfolio, please check out our web site at:
  8. ;
  9. ;      http://virtuoso.openlinksw.com/
  10. ;
  11. ;  or contact us at:
  12. ;
  13. ;      general.information@openlinksw.com
  14. ;
  15. ;  If you have any technical questions, please contact our support
  16. ;  staff at:
  17. ;
  18. ;      technical.support@openlinksw.com
  19. ;
  20.  
  21. ;
  22. ;  Database setup
  23. ;
  24. [Database]
  25. DatabaseFile            = /usr/local/virtuoso-opensource/var/lib/virtuoso/db/virtuoso.db
  26. ErrorLogFile            = /usr/local/virtuoso-opensource/var/lib/virtuoso/db/virtuoso.log
  27. LockFile            = /usr/local/virtuoso-opensource/var/lib/virtuoso/db/virtuoso.lck
  28. TransactionFile         = /usr/local/virtuoso-opensource/var/lib/virtuoso/db/virtuoso.trx
  29. xa_persistent_file      = /usr/local/virtuoso-opensource/var/lib/virtuoso/db/virtuoso.pxa
  30. ErrorLogLevel           = 7
  31. FileExtend          = 200
  32. MaxCheckpointRemap      = 2000
  33. Striping            = 0
  34. TempStorage         = TempDatabase
  35.  
  36.  
  37. [TempDatabase]
  38. DatabaseFile            = /usr/local/virtuoso-opensource/var/lib/virtuoso/db/virtuoso-temp.db
  39. TransactionFile         = /usr/local/virtuoso-opensource/var/lib/virtuoso/db/virtuoso-temp.trx
  40. MaxCheckpointRemap      = 2000
  41. Striping            = 0
  42.  
  43.  
  44. ;
  45. ;  Server parameters
  46. ;
  47. [Parameters]
  48. ServerPort          = 1111
  49. LiteMode            = 0
  50. DisableUnixSocket       = 0
  51. DisableTcpSocket        = 0
  52. ;SSLServerPort          = 2111
  53. ;SSLCertificate         = cert.pem
  54. ;SSLPrivateKey          = pk.pem
  55. ;X509ClientVerify       = 0
  56. ;X509ClientVerifyDepth      = 0
  57. ;X509ClientVerifyCAFile     = ca.pem
  58. MaxClientConnections        = 10000000000000000
  59. CheckpointInterval      = 60
  60. O_DIRECT            = 1
  61. CaseMode            = 2
  62. MaxStaticCursorRows     = 50000000000
  63. CheckpointAuditTrail        = 0
  64. AllowOSCalls            = 0
  65. SchedulerInterval       = 10
  66. DirsAllowed         = ., /usr/local/virtuoso-opensource/share/virtuoso/vad
  67. ThreadCleanupInterval       = 0
  68. ThreadThreshold         = 1000000000
  69. ResourcesCleanupInterval    = 0
  70. FreeTextBatchSize       = 1000000000000000000000000
  71. SingleCPU           = 0
  72. VADInstallDir           = /usr/local/virtuoso-opensource/share/virtuoso/vad/
  73. PrefixResultNames               = 0
  74. RdfFreeTextRulesSize        = 100000
  75. IndexTreeMaps           = 256
  76. MaxMemPoolSize                  = 200000000
  77. PrefixResultNames               = 0
  78. MacSpotlight                    = 0
  79. IndexTreeMaps                   = 64
  80. MaxQueryMem             = 16G       ; memory allocated to query processor
  81. VectorSize          = 10000     ; initial parallel query vector (array of query operations) size
  82. MaxVectorSize           = 1000000   ; query vector size threshold.
  83. AdjustVectorSize        = 0
  84. ThreadsPerQuery         = 40
  85. AsyncQueueMaxThreads        = 100000000
  86. ;;
  87. ;; When running with large data sets, one should configure the Virtuoso
  88. ;; process to use between 2/3 to 3/5 of free system memory and to stripe
  89. ;; storage on all available disks.
  90. ;;
  91. ;; Uncomment next two lines if there is 2 GB system memory free
  92. ;NumberOfBuffers          = 170000
  93. ;MaxDirtyBuffers          = 130000
  94. ;; Uncomment next two lines if there is 4 GB system memory free
  95. ;NumberOfBuffers          = 340000
  96. ; MaxDirtyBuffers          = 250000
  97. ;; Uncomment next two lines if there is 8 GB system memory free
  98. ;NumberOfBuffers          = 680000
  99. ;MaxDirtyBuffers          = 500000
  100. ;; Uncomment next two lines if there is 16 GB system memory free
  101. ;NumberOfBuffers          = 1360000
  102. ;MaxDirtyBuffers          = 1000000
  103. ;; Uncomment next two lines if there is 32 GB system memory free
  104. ;NumberOfBuffers          = 2720000
  105. ;MaxDirtyBuffers          = 2000000
  106. ;; Uncomment next two lines if there is 48 GB system memory free
  107. NumberOfBuffers          = 4000000
  108. MaxDirtyBuffers          = 3000000
  109. ;; Uncomment next two lines if there is 64 GB system memory free
  110. ;NumberOfBuffers          = 5450000
  111. ;MaxDirtyBuffers          = 4000000
  112. ;;
  113. ;; Note the default settings will take very little memory
  114. ;; but will not result in very good performance
  115. ;;
  116. ;NumberOfBuffers          = 10000
  117. ;MaxDirtyBuffers          = 6000
  118.  
  119.  
  120. [HTTPServer]
  121. ServerPort          = 8890
  122. ServerRoot          = /usr/local/virtuoso-opensource/var/lib/virtuoso/vsp
  123. MaxClientConnections        = 1000
  124. DavRoot             = DAV
  125. EnabledDavVSP           = 0
  126. HTTPProxyEnabled        = 0
  127. TempASPXDir         = 0
  128. DefaultMailServer       = localhost:25
  129. ServerThreads           = 10000
  130. MaxKeepAlives           = 1000
  131. KeepAliveTimeout        = 100
  132. MaxCachedProxyConnections   = 100
  133. ProxyConnectionCacheTimeout = 15
  134. HTTPThreadSize          = 280000
  135. HttpPrintWarningsInOutput   = 0
  136. Charset             = UTF-8
  137. ;HTTPLogFile                = logs/http.log
  138. MaintenancePage                 = atomic.html
  139. EnabledGzipContent              = 0
  140.  
  141.  
  142. [AutoRepair]
  143. BadParentLinks          = 0
  144.  
  145. [Client]
  146. SQL_PREFETCH_ROWS       = 1000
  147. SQL_PREFETCH_BYTES      = 16000
  148. SQL_QUERY_TIMEOUT       = 0
  149. SQL_TXN_TIMEOUT         = 0
  150. ;SQL_NO_CHAR_C_ESCAPE       = 1
  151. ;SQL_UTF8_EXECS         = 0
  152. ;SQL_NO_SYSTEM_TABLES       = 0
  153. ;SQL_BINARY_TIMESTAMP       = 1
  154. ;SQL_ENCRYPTION_ON_PASSWORD = -1
  155.  
  156. [VDB]
  157. ArrayOptimization       = 0
  158. NumArrayParameters      = 10000
  159. VDBDisconnectTimeout        = 10000
  160. KeepConnectionOnFixedThread = 0
  161.  
  162. [Replication]
  163. ServerName          = db-VMDGSIT04
  164. ServerEnable            = 1
  165. QueueMax            = 50000
  166.  
  167.  
  168. ;
  169. ;  Striping setup
  170. ;
  171. ;  These parameters have only effect when Striping is set to 1 in the
  172. ;  [Database] section, in which case the DatabaseFile parameter is ignored.
  173. ;
  174. ;  With striping, the database is spawned across multiple segments
  175. ;  where each segment can have multiple stripes.
  176. ;
  177. ;  Format of the lines below:
  178. ;    Segment<number> = <size>, <stripe file name> [, <stripe file name> .. ]
  179. ;
  180. ;  <number> must be ordered from 1 up.
  181. ;
  182. ;  The <size> is the total size of the segment which is equally divided
  183. ;  across all stripes forming  the segment. Its specification can be in
  184. ;  gigabytes (g), megabytes (m), kilobytes (k) or in database blocks
  185. ;  (b, the default)
  186. ;
  187. ;  Note that the segment size must be a multiple of the database page size
  188. ;  which is currently 8k. Also, the segment size must be divisible by the
  189. ;  number of stripe files forming  the segment.
  190. ;
  191. ;  The example below creates a 200 meg database striped on two segments
  192. ;  with two stripes of 50 meg and one of 100 meg.
  193. ;
  194. ;  You can always add more segments to the configuration, but once
  195. ;  added, do not change the setup.
  196. ;
  197. [Striping]
  198. Segment1            = 100M, db-seg1-1.db, db-seg1-2.db
  199. Segment2            = 100M, db-seg2-1.db
  200. ;...
  201.  
  202. ;[TempStriping]
  203. ;Segment1           = 100M, db-seg1-1.db, db-seg1-2.db
  204. ;Segment2           = 100M, db-seg2-1.db
  205. ;...
  206.  
  207. ;[Ucms]
  208. ;UcmPath            = <path>
  209. ;Ucm1               = <file>
  210. ;Ucm2               = <file>
  211. ;...
  212.  
  213.  
  214. [Zero Config]
  215. ServerName          = virtuoso (VMDGSIT04)
  216. ;ServerDSN          = ZDSN
  217. ;SSLServerName          =
  218. ;SSLServerDSN           =
  219.  
  220.  
  221. [Mono]
  222. ;MONO_TRACE         = Off
  223. ;MONO_PATH          = <path_here>
  224. ;MONO_ROOT          = <path_here>
  225. ;MONO_CFG_DIR           = <path_here>
  226. ;virtclr.dll            =
  227.  
  228.  
  229. [URIQA]
  230. DynamicLocal            = 0
  231. DefaultHost         = localhost:8890
  232.  
  233.  
  234. [SPARQL]
  235. ;ExternalQuerySource        = 1
  236. ;ExternalXsltSource         = 1
  237. ;DefaultGraph           = http://localhost:8890/dataspace
  238. ;ImmutableGraphs            = http://localhost:8890/dataspace
  239. ResultSetMaxRows            = 10000
  240. MaxQueryCostEstimationTime  = 4000  ; in seconds
  241. MaxQueryExecutionTime       = 600   ; in seconds
  242. DefaultQuery                = select distinct ?s ?p ?o where {?s ?p ?o .} LIMIT 100
  243. DeferInferenceRulesInit     = 0  ; controls inference rules loading
  244. ;PingService            = http://rpc.pingthesemanticweb.com/
  245.  
  246.  
  247. [Plugins]
  248. LoadPath            = /usr/local/virtuoso-opensource/lib/virtuoso/hosting
  249. Load1               = plain, wikiv
  250. Load2               = plain, mediawiki
  251. Load3               = plain, creolewiki
  252. ;Load4          = plain, im
  253. ;Load5      = plain, wbxml2
  254. ;Load6          = plain, hslookup
  255. ;Load7          = attach, libphp5.so
  256. ;Load8          = Hosting, hosting_php.so
  257. ;Load9          = Hosting,hosting_perl.so
  258. ;Load10     = Hosting,hosting_python.so
  259. ;Load11     = Hosting,hosting_ruby.so
  260. ;Load12             = msdtc,msdtc_sample
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!