Hi Paul, Are you not [email protected], to whom I sent the following earlier this week when the exact same questions was posed ?
> From: Hugh Williams <[email protected]> > Subject: Re: [Virtuoso-users] Striping in Windows > Date: 13 November 2012 23:35:21 GMT > To: <[email protected]> <[email protected]> > Cc: <[email protected]> > > Hi Paul, > > Hmmm, I get the same issue with the 6.1.6 windows build when trying to enable > striping, although it works with a 6.1.4 build and if I replace the 6.1.6 > virtuoso.ini file with the 6.1.4 one the 6.1.6 striping then works. So seems > something is corrupt (hidden character, unixtodos issue) in the INI file, > which I cannot see having tried unixtodos program to hopefully remove any > unexpected chars. > > Try the following INI file and let me know if it works for you: > > ; > ; 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: > ; > ; [email protected] > ; > ; If you have any technical questions, please contact our support > ; staff at: > ; > ; [email protected] > ; > > ; > ; Database setup > ; > [Database] > DatabaseFile = virtuoso.db > ErrorLogFile = virtuoso.log > LockFile = virtuoso.lck > TransactionFile = virtuoso.trx > xa_persistent_file = virtuoso.pxa > ErrorLogLevel = 7 > FileExtend = 200 > MaxCheckpointRemap = 2000 > Striping = 1 > TempStorage = TempDatabase > > > [TempDatabase] > DatabaseFile = virtuoso-temp.db > TransactionFile = 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 > ServerThreads = 20 > CheckpointInterval = 60 > O_DIRECT = 0 > CaseMode = 2 > MaxStaticCursorRows = 5000 > CheckpointAuditTrail = 0 > AllowOSCalls = 0 > SchedulerInterval = 10 > DirsAllowed = ., ../vad > ThreadCleanupInterval = 0 > ThreadThreshold = 10 > ResourcesCleanupInterval = 0 > FreeTextBatchSize = 100000 > SingleCPU = 0 > VADInstallDir = ../vad/ > PrefixResultNames = 0 > RdfFreeTextRulesSize = 100 > IndexTreeMaps = 256 > MaxMemPoolSize = 200000000 > PrefixResultNames = 0 > MacSpotlight = 0 > IndexTreeMaps = 64 > ;; > ;; 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 > > > [HTTPServer] > ServerPort = 8890 > ServerRoot = ../vsp > ServerThreads = 20 > 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 = logs/http.log > > [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-VOS-WIN > 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 = 1G, f:\db-seg1-1.db, g:\db-seg1-2.db > ;Segment2 = 2G, e:/_virtuoso_2/db-seg2-1.db > Segment1 = 100M, c:\dbs-seg1-1.db = q1, c:\dbs-seg1-2.db > = q2 > ;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 (VOS-WIN) > ;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 = 1 > DefaultHost = localhost:8890 > > > [SPARQL] > ;ExternalQuerySource = 1 > ;ExternalXsltSource = 1 > ;DefaultGraph = http://localhost:8890/dataspace > ;ImmutableGraphs = http://localhost:8890/dataspace > ResultSetMaxRows = 10000 > MaxQueryCostEstimationTime = 400 ; in seconds > MaxQueryExecutionTime = 60 ; in seconds > DefaultQuery = select distinct ?Concept where {[] a > ?Concept} LIMIT 100 > DeferInferenceRulesInit = 0 ; controls inference rules loading > ;PingService = http://rpc.pingthesemanticweb.com/ > > > [Plugins] > LoadPath = ../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 > Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google+ -- http://plus.google.com/100570109519069333827/ Facebook -- http://www.facebook.com/OpenLinkSoftware Universal Data Access, Integration, and Management Technology Providers On 12 Nov 2012, at 22:21, Paul Houle wrote: > I’m trying to create stripes in Windows with the latest open source > edition of Virtuoso (6.1.6) > > So I’ve set Striping=1 and also wrote > > [Striping] > Segment1 = 50g, c:\v1\v1.db > Segment2 = 50g, d:\v2\v2.db > > into the virtuoso.ini file; the trouble I have is that the system creates > files named “c” and “d” in the databases directory and starts filling them > with zeroes or whatever it is doing. I guess there must be some kind of > escaping that I’m missing that would cause virtuoso to recognize that this is > a drive letter. > > What should I be doing here? > ------------------------------------------------------------------------------ > Monitor your physical, virtual and cloud infrastructure from a single > web console. Get in-depth insight into apps, servers, databases, vmware, > SAP, cloud infrastructure, etc. Download 30-day Free Trial. > Pricing starts from $795 for 25 servers or applications! > http://p.sf.net/sfu/zoho_dev2dev_nov_______________________________________________ > Virtuoso-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________ Virtuoso-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
