Hi Erick,

Can you please provide the following:

1. The output of running the top command on the machine at the time you are running these problem queries such that we can see the CPU, I/ O etc consumption
2. How many hard disks and CPUs are in the machine currently
3. Some of these problem queries for analysis

Your FDsPerFile has too many stripes most probably, resulting in the process running out of descriptors. We would suggest you use only one stripe per physical disk.

Best Regards
Hugh Williams
Professional Services
OpenLink Software
http://www.openlinksw.com


On 5 Jun 2008, at 11:33, Erick Antezana wrote:

Hello,

could anybody point out some doc/examples for doing some performance tuning?

I have been playing (in a linux box with 16GB RAM, 1 CPU, ...) with some params (numberofbuffers, maxcheckpointremap, O_DIRECT, etc) as indicated in:

http://virtuoso.openlinksw.com/wiki/main/Main/VOSScale

http://docs.openlinksw.com/virtuoso/rdfperformancetuning.html

however, our system is still pretty slow or even no responsive :- ( while
launching some SPARQL queries...

on the other hand, we're planing on buying a new server. Could anybody
recommend some specs (RAM, CPU, disks, ...) so that it could
"steadily/reasonably" cope with huge amounts of data (about 160GB in RDF
files). Any advice for the hard disks spec (type: SCSI, ...; IO rate;
...)? config (striping, ...)?

thanks in advance!
Erick
p.s. while setting the param FDsPerFile to 16 for isntance, I've got an
error while re-starting virtuoso:

12:15:54 Cannot open stripe on /virtuoso/db/right/db-seg32-2.db (24)
12:15:54 Server exiting

should that param be set the first time the system is started (due to
the striping?)?


---------------------------------------------------------------------- ---
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users


Reply via email to