Hallo,
try shutdown like this:
isql $PORT $USER $PASS verbose=on banner=off prompt=off echo=ON
errors=stdout exec="shutdown;"
I think, this is the way virtuoso should be shutdown correctly.
If you kill virtuoso, it will rollback more data while startup.
Cheers,
Armin
Sebastian Trueg schrieb:
All default. This is all I put in my config:
[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?
Cheers,
Sebastian
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
--
Armin Nagel
Softwareentwickler
neofonie
Technologieentwicklung und
Informationsmanagement GmbH
Robert-Koch-Platz 4
10115 Berlin
fon: +49.30 24627 257
fax: +49.30 24627 120
[email protected]
http://www.neofonie.de
Handelsregister
Berlin-Charlottenburg: HRB 67460
Geschaeftsfuehrung
Helmut Hoffer von Ankershoffen
(Sprecher der Geschaeftsfuehrung)
Nurhan Yildirim
________________________________
Die erste Web 2.0 Suchmaschine jetzt auf http://www.wefind.de .
Unterwegs immer bestens informiert mit WeFind Mobile für iPhone und
jetzt auch mit WeFind Mobile für Android: kostenloser Download im iTunes
AppStore und im Android Market.
