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

Attachment: 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

Reply via email to