Hmm, Virtuoso's sample INI file has spaces preceding parameter values and running with "NumberOfBuffers = 80000" certainly results in status() reporting 80000 buffers.

Marcelo, is your Virtuoso somehow using a different configuration file to the one you think it is ??


Regards,
Dave

On 7/01/13 9:40 AM, Hugh Williams wrote:
Hi Marcelo,

The status output still shows the buffers are set to the default of "2000", see:

/*2000 buffers, 1274 used,*/

Note there should not be an spaces preceding the parameter setting otherwise they will not be picked up which seem to the case here, thus please remove them, restart Virtuoso and check with the status command the Buffers are indeed being set to 340000.

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 4 Jan 2013, at 19:42, Marcelo Aliquintuy <[email protected] <mailto:[email protected]>> wrote:

Hi again, I followed your instructions to try fix the problem but
I tuning virtuoso with:
*/;; Uncomment next two lines if there is 4 GB system memory free/*
*/       NumberOfBuffers          = 340000/*
*/       MaxDirtyBuffers          = 250000/*

and upgrade to virtuoso 6.1.6 and i got the same problem:

status() before to execute the query:
/*SQL> status();*/
/*REPORT*/
/*VARCHAR*/
/*_______________________________________________________________________________*/
/*
*/
/*OpenLink Virtuoso  Server*/
/*Version 06.01.3127-pthreads for Darwin as of Dec 13 2012 */
/*Started on: 2013/01/04 16:26 GMT-180*/
/**/
/*Database Status:*/
/*  File size 65011712, 7936 pages, 5628 free.*/
/* 2000 buffers, 1274 used, 0 dirty 0 wired down, repl age 748 0 w. io 0 w/crsr.*/ /* Disk Usage: 1631 reads avg 0 msec, 0% r 0% w last 0 s, 1479 writes,*/ /* 203 read ahead, batch = 3. Autocompact 138 in 104 out, 24% saved.*/ /*Gate: 246 2nd in reads, 0 gate write waits, 0 in while read 0 busy scrap. */ /*Log = /Applications/dev/virtuoso-opensource-6.1.6/var/lib/virtuoso/db/virtuoso.trx, 155 bytes*/
/*1303 pages have been changed since last backup (in checkpoint state)*/
/*Current backup timestamp: 0x28D5-0x46-0xF4*/
/*Last backup date: Fri Jan  4 15:55:35 2013*/
/**/
/*Clients: 1 connects, max 1 concurrent*/
/*RPC: 4 calls, 1 pending, 1 max until now, 0 queued, 0 burst reads (0%), 0 second brk=9*/
/*Checkpoint Remap 114 pages, 0 mapped back. 1 s atomic time.*/
/*    DB master 7936 total 5628 free 114 remap 0 mapped back*/
/*   temp  256 total 251 free*/
/**/
/*Lock Status: 0 deadlocks of which 0 2r1w, 0 waits,*/
/*   Currently 1 threads running 0 threads waiting 0 threads in vdb.*/
/*Pending:*/
/**/
/*Client 1111:1:  Account: dba, 203 bytes in, 256 bytes out, 1 stmts.*/
/*PID: 4443056536, OS: unix, Application: unknown, IP#: 127.0.0.1*/
/*Transaction status: PENDING, 1 threads.*/
/*Locks: */
/**/
/**/
/*Running Statements:*/
/* Time (msec) Text*/
/*         141 status()*/
/**/
/**/
/*Hash indexes*/
/**/
/*
*/
/*38 Rows. -- 141 msec.*/



When try to run status() again after execute query thats doesnt response:
*/SQL> status();/*

top status of virtuoso:
/*PID COMMAND %CPU TIME #TH #WQ #POR #MREG RPRVT RSHRD RSIZE VPRVT VSIZE PGRP PPID STATE UID FAULTS COW MSGSENT MSGRECV SYSBSD SYSMACH CSW PAGEINS*/ /*87639 virtuoso-t 97.2 04:41.41 26/1 0 106 216 163M 244K 186M 196M 2580M 87639 1 running 501 47802 58 200 89 4142614 1425 348460+ 40*/

Thanks and Best Regards!!!
--
Marcelo Aliquintuy
87433162


------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnmore_123012
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Reply via email to