Hi folks,
I've set up four Virtuoso instances (Version 7.2.2.3215) on an Ubuntu 14.04.4
LTS server with 12 cores and 128 GB memory.
If I run several (federated) queries in parallel (maximal 16 at a time), where
some of the queries may take several minutes, it may happened that a SPARQL
endpoint return some HTTP error. If I rerun the same query some seconds later,
it will ordinarily be evaluated correct and the requested results are returned.
I've already tried to solve this infrequent issue but without any success. Can
you please give me some recommendations?
Maybe my configuration may comprise some not well-chosen parameter?
Please find below my virtuoso.ini:
[Database]
DatabaseFile = ../var/lib/virtuoso/db/virtuoso.db
ErrorLogFile = ../var/lib/virtuoso/db/virtuoso.log
LockFile = ../var/lib/virtuoso/db/virtuoso.lck
TransactionFile = ../var/lib/virtuoso/db/virtuoso.trx
xa_persistent_file = ../var/lib/virtuoso/db/virtuoso.pxa
ErrorLogLevel = 7
FileExtend = 200
MaxCheckpointRemap = 150000
Striping = 0
TempStorage = TempDatabase
[TempDatabase]
DatabaseFile = ../var/lib/virtuoso/db/virtuoso-temp.db
TransactionFile = ../var/lib/virtuoso/db/virtuoso-temp.trx
MaxCheckpointRemap = 9000
Striping = 0
[Parameters]
ServerPort = 1112
LiteMode = 0
DisableUnixSocket = 1
DisableTcpSocket = 0
MaxClientConnections = 10000
ServerThreads = 1000
CheckpointInterval = 60
O_DIRECT = 0
CaseMode = 2
MaxStaticCursorRows = 5000
CheckpointAuditTrail = 0
AllowOSCalls = 0
SchedulerInterval = 10
DirsAllowed = ., ../share/virtuoso/vad,../saleem/dumps,
/opt/benchset/bibsonomy
ThreadCleanupInterval = 1
ThreadThreshold = 1000
ResourcesCleanupInterval = 1
FreeTextBatchSize = 100000
SingleCPU = 0
VADInstallDir = ../share/virtuoso/vad/
PrefixResultNames = 0
RdfFreeTextRulesSize = 100
IndexTreeMaps = 512
MaxMemPoolSize = 200000000
PrefixResultNames = 0
MacSpotlight = 0
MaxQueryMem = 8G ; memory allocated to query processor
VectorSize = 1000 ; initial parallel query vector
(array of query operations) size
MaxVectorSize = 2000000 ; query vector size threshold.
AdjustVectorSize = 0
ThreadsPerQuery = 24
AsyncQueueMaxThreads = 36
NumberOfBuffers = 1360000
MaxDirtyBuffers = 1000000
TraceOn = errors
CallstackOnException = 1
MaxSortedTopRows = 10000000
DefaultIsolation = 2
[HTTPServer]
ServerPort = 8891
ServerRoot = ../var/lib/virtuoso/vsp
MaxClientConnections = 10000
DavRoot = DAV
EnabledDavVSP = 0
HTTPProxyEnabled = 0
TempASPXDir = 0
DefaultMailServer = localhost:25
ServerThreads = 1000
MaxKeepAlives = 100
KeepAliveTimeout = 10
MaxCachedProxyConnections = 10
ProxyConnectionCacheTimeout = 15
HTTPThreadSize = 280000
HttpPrintWarningsInOutput = 0
Charset = UTF-8
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
[VDB]
ArrayOptimization = 0
NumArrayParameters = 10
VDBDisconnectTimeout = 1000
KeepConnectionOnFixedThread = 0
[Replication]
ServerName = db-AKSWDESKTOP
ServerEnable = 1
QueueMax = 50000
[Striping]
Segment1 = 8G, db-seg1-1.db, db-seg1-2.db
Segment2 = 8G, db-seg2-1.db, db-seg2-2.db
[Zero Config]
ServerName = virtuoso (AKSWDESKTOP)
[Mono]
[URIQA]
DynamicLocal = 0
DefaultHost = localhost:8890
[SPARQL]
DefaultGraph = http://test.hs-albsig.de/benchset
ResultSetMaxRows = 10000000
DefaultQuery = select distinct ?Concept where {[] a ?Concept} LIMIT
100
DeferInferenceRulesInit = 0 ; controls inference rules loading
[Plugins]
LoadPath = ../lib/virtuoso/hosting
Best regards
Andy Nolle
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
