| Attributes | Values |
|---|
| type
| |
| Date Created
| |
| Date Modified
| |
| label
| - VirtTipsAndTricksGuideRDFPerformanceTuning
|
| maker
| |
| Title
| - VirtTipsAndTricksGuideRDFPerformanceTuning
|
| isDescribedUsing
| |
| has creator
| |
| content
| - %META:TOPICPARENT{name="VirtTipsAndTricksGuide"}%
---+ How can I configure Virtuoso for maximum performance with available memory?
---++ Virtuoso INI file settings
When running with large data sets, the Virtuoso process should be configured to use between 2/3 and 3/5 of system RAM.
See Virtuoso configuration file parameters [[http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#VIRTINI][NumberOfBuffers and MaxDirtyBuffers]] for details.
Each buffer consumes 8 KB. Typical sizes for the NumberOfBuffers and MaxDirtyBuffers (3/4 of NumberOfBuffers) parameters at various memory sizes are as follows, :
| *System Memory* | *NumberOfBuffers* | *MaxDirtyBuffers* |
| default installation | 2000 | 1200 |
| 2 GB | 170000 | 130000 |
| 4 GB | 340000 | 250000 |
| 8 GB | 680000 | 500000 |
| 16 GB | 1360000 | 1000000 |
| 32 GB | 2720000 | 2000000 |
| 48 GB | 4000000 | 3000000 |
| 64 GB | 5450000 | 4000000 |
---++ "swappiness"
<b>For Linux users only,</b> there is a kernel tuning parameter called "[[http://www.linuxvox.com/2009/10/what-is-the-linux-kernel-parameter-vm-swappiness/][swappiness]]" that controls how much the kernel favors swap over RAM.
When hosting large data sets, it is recommended that this parameter be changed from its default value of 60 to something closer to 10, to reduce the amount of swapping that takes place on the server. Useful tidbits regarding swappiness include:
* The swappiness setting is found in the file <b><code>/proc/sys/vm/swappiness</code></b>.
* The command <b><code>/sbin/sysctl vm.swappiness</code></b> can be used to view its setting.
* The command <b><code>/sbin/sysctl -w vm.swappiness=10</code></b> can be used to change its value.
* Adding <b><code>vm.swappiness = 10</code></b> to the file <b><code>/etc/sysctl.conf</code></b> will force the value to be set at machine boot time.
---++Related
* [[VirtTipsAndTricksGuide][Virtuoso Tips and Tricks Collection]]
* [[http://www.linuxvox.com/2009/10/what-is-the-linux-kernel-parameter-vm-swappiness/][Documentation of Linux swappiness kernel tuning parameter]]
* [[http://docs.openlinksw.com/virtuoso/rdfperformancetuning.html][Tuning Virtuoso for RDF Performance]]
* [[http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#VIRTINI][Virtuoso INI file settings]]
|
| id
| - 710b3100e51bf698ce3984bf6f3e20c0
|
| link
| |
| has container
| |
| http://rdfs.org/si...ices#has_services
| |
| atom:title
| - VirtTipsAndTricksGuideRDFPerformanceTuning
|
| links to
| |
| atom:source
| |
| atom:author
| |
| atom:published
| |
| atom:updated
| |
| topic
| |
| is made
of | |
| is container of
of | |
| is link
of | |
| is http://rdfs.org/si...vices#services_of
of | |
| is creator of
of | |
| is atom:entry
of | |
| is atom:contains
of | |
![[RDF Data]](/fct/images/sw-rdf-blue.png)
![[cxml]](/fct/images/cxml_doc.png)
![[csv]](/fct/images/csv_doc.png)
![[text]](/fct/images/ntriples_doc.png)
![[turtle]](/fct/images/n3turtle_doc.png)
![[ld+json]](/fct/images/jsonld_doc.png)
![[rdf+json]](/fct/images/json_doc.png)
![[rdf+xml]](/fct/images/xml_doc.png)
![[atom+xml]](/fct/images/atom_doc.png)
![[html]](/fct/images/html_doc.png)