Hi Guys,
Can I run several Virtuoso server instances on the same machine
(with different port number)? if any risk exist then? I found
sometimes the server instance work well but sometimes exited for
no reason.
Environment:
OS: Debian 2.6.18.1.2007050801
Open source Virtuoso v5.0.8
On Wed, Sep 3, 2008 at 11:22 PM, Yrjänä Rankka
<[EMAIL PROTECTED]> wrote:
jiusheng chen wrote:
Hi Hugh,
To speed up loading large dataset like dbpedia into one PC, if
parallel loading (split large data into several segments, loading
these segments in parallel) is effective? any further suggestions?
Hi Jiusheng,
I've usually had about 3 ISQL processes per core loading the data
set. I didn't bother to split the dbpedia dataset into any smaller
segments than it was to begin with.
You'll need RAM - plenty of it. A good rule of thumb would be to
give Virtuoso at least 2/3 of total RAM in the system.
See section [Parameters] in virtuoso.ini - the ones you're
interested about are NumberOfBuffers and MaxDirtyBuffers.
A handy tip: you can spawn a new ISQL process when you run a
stored procedure/query by using the ampersand in the ISQL command
line. I.e.
SQL> my_lengthy_stored_proc()&
Best Regards,
Yrjänä
On Wed, Sep 3, 2008 at 5:27 PM, Hugh Williams
<[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote:
Hi Jiusheng,
The isql program has a "shutdown" command that can be used to
shutdown the Virtuoso instance it is connected to:
$ ./isql 1111
Connected to OpenLink Virtuoso
Driver: 05.00.3033 OpenLink Virtuoso ODBC Driver
OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL> shutdown();
$
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
On 3 Sep 2008, at 08:09, jiusheng chen wrote:
Hi Hugh,
Thanks for your reply.
Perhaps I got a incorrect impression before.
BTW, how to stop the server instance? just kill the virtuoso_t
job?
On Tue, Sep 2, 2008 at 4:58 PM, Hugh Williams
<[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>
wrote:
Hi Jiusheng,
The Virtuoso isql program is a simple Interactive SQL client
side tool for accessing a Virtuoso server instance on the
specified hostname and port number (localhost, 1111 being
defaults), and as such will always assume the specified
server has already been started by some other means
regardless of version.
If their is specific documentation you read that gave the
impression that isql starts a Virtuoso instance then please
provide a link or details of it such that we can have it
corrected or made clear as to what isql does ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software
Web: http://www.openlinksw.com
Support: http://support.openlinksw.com
Forums: http://boards.openlinksw.com/support
On 2 Sep 2008, at 02:21, jiusheng chen wrote:
Thank you, guys.
You are right, there needs to start virtuoso-t explicitly
before using isql. But it seemed to me this step is not
necessary for version 5.0.7. <http://5.0.7.>
On Mon, Sep 1, 2008 at 5:01 PM, Tim Haynes
<[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
jiusheng chen wrote:
> Hi Tim,
>
> I installed it, but seems it doesn't work.
>
> [EMAIL PROTECTED]:/disk1/sda/datasets$ isql
> OpenLink Interactive SQL (Virtuoso), version 0.9849b.
> Type HELP; for help and EXIT; to exit.
> SQL> select * from DB.DBA.SYS_USERS;
>
> *** Error S2801: [Virtuoso Driver]CL033: Connect
failed to
> localhost:1111 = localhost:1111.
> at line 1 of Top-Level:
> select * from DB.DBA.SYS_USERS
>
>
> Virtuoso was installed with default settings.
>
Hi,
This looks like you haven't started it. From the
${prefix}/var/lib/db/
directory, run virtuoso-t -df to make it start in the
foreground and once
it claims to be online, isql should work. If not, please
include teh server
debug output too.
Regards,
~Tim
--
Tim Haynes
Product Development Consultant
OpenLink Software
<http://www.openlinksw.com/>
-- Thanks,
Chen Jiusheng
-- Thanks,
Chen Jiusheng
--
Thanks,
Chen Jiusheng
---------------------------------------------------------------------
---
---------------------------------------------------------------------
----
This SF.Net email is sponsored by the Moblin Your Move Developer's
challenge
Build the coolest Linux based applications with Moblin SDK & win
great prizes
Grand prize is a trip for two to an Open Source event anywhere in
the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
---------------------------------------------------------------------
---
_______________________________________________
Dbpedia-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dbpedia-discussion
--
Yrjana Rankka | [EMAIL PROTECTED]
Developer, Virtuoso Team | http://www.openlinksw.com
| Making Technology Work For You
--
Thanks,
Chen Jiusheng
