Hi Sebastian,
[Database]
DatabaseFile=/home/trueg/.kde4/share/apps/nepomuk/repository/main/data/virtuosobackend/soprano-virtuoso.db
ErrorLogFile=/home/trueg/.kde4/share/apps/nepomuk/repository/main/data/virtuosobackend/soprano-virtuoso.log
TransactionFile=/home/trueg/.kde4/share/apps/nepomuk/repository/main/data/virtuosobackend/soprano-virtuoso.trx
xa_persistent_file=/home/trueg/.kde4/share/apps/nepomuk/repository/main/data/virtuosobackend/soprano-virtuoso.pxa
[TempDatabase]
DatabaseFile=/home/trueg/.kde4/share/apps/nepomuk/repository/main/data/virtuosobackend/soprano-virtuoso-temp.db
TransactionFile=/home/trueg/.kde4/share/apps/nepomuk/repository/main/data/virtuosobackend/soprano-virtuoso-temp.trx
MaxCheckpointRemap=1000
[Parameters]
LiteMode=1
ServerPort=1124
DisableTcpSocket=1
PrefixResultNames=0
ServerThreads=100
CheckpointInterval=10
NumberOfBuffers=10000
MaxDirtyBuffers=50
SchedulerInterval=5
FreeTextBatchSize=1000
But maybe I should shut down virtuoso other then sending it the TERM signal?
If you kill virtuoso with a SIGTERM, it will initiate a fast shutdown,
without performing a checkpoint.
If you want it to perform a complete shutdown of the database, you
either use the isql tool to perform a shutdown command, or you can kill
it with SIGINT.
However be aware that depending on the size of your transaction file
(.trx), this can take a while to perform, which may not be what you want
when you shutdown the machine. I would strongly advice against using
this in some rc.d script,
Hugh Williams wrote:
Hi Sebastian,
If you shutdown Virtuoso gracefully it should automatically run a checkpoint to commit
all pending transactions (or you can run one manually at anytime with the
"checkpoint" command) with the log file being zero bytes in size and thus
nothing has to be replayed on startup. Are you saying that your log file is typically not
zero bytes in size and thus always having to replay logs on start-up ? What parameters to
you have set for checkpointing in your virtuoso.ini config file ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
Twitter: http://twitter.com/OpenLink
On 26 Nov 2009, at 08:45, Sebastian Trueg wrote:
Is there any way I can speed up the start of Virtuoso? Maybe by issuing
some command before shutdown which already plays back all the
transactions in the log file?
Cheers,
Sebastian
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
