Re: How to transfer monetdb database to another machine
Thanks a lot for helping. I am unable to figure as to where does * <dbfarm>/<dbname>* directory reside within ubuntu 12.04. Can you please help me with this. On Sun, Oct 13, 2013 at 6:06 PM, <users-list-request@monetdb.org> wrote:
Send users-list mailing list submissions to users-list@monetdb.org
To subscribe or unsubscribe via the World Wide Web, visit https://www.monetdb.org/mailman/listinfo/users-list or, via email, send a message with subject or body 'help' to users-list-request@monetdb.org
You can reach the person managing the list at users-list-owner@monetdb.org
When replying, please edit your Subject line so it is more specific than "Re: Contents of users-list digest..."
Today's Topics:
1. Re: Query execution time (baraa Mohamad) 2. Re: Query execution time (Martin Kersten) 3. Re: How to transfer monetdb database to another machine (Martin Kersten) 4. Re: Query execution time (Martin Kersten)
----------------------------------------------------------------------
Message: 1 Date: Sun, 13 Oct 2013 12:31:35 +0200 From: baraa Mohamad <bem85@hotmail.com> To: Communication channel for MonetDB users <users-list@monetdb.org> Cc: Communication channel for MonetDB users <users-list@monetdb.org> Subject: Re: Query execution time Message-ID: <BAY406-EAS1557A9804AABD08B94A7905A8190@phx.gbl> Content-Type: text/plain; charset="utf-8"
That's great! Thank you very much for your appreciated help.
I just could't really understand the output of this command.
This is my output: Real: 1m23 User: 0m24s Sys: 0m2.3s
I'm a little bit confused because when I execute the same query directly without the time option i get 733,28ms.
So i couldn't know what is the real execution time.
Le 13 oct. 2013 ? 11:29, "Martin Kersten" <Martin.Kersten@cwi.nl> a ?crit :
How about (time mclient -d db <inputfile >/dev/null)
On 10/13/13 11:24 AM, baraa Mohamad wrote: Thank you for your answer. But in general I would like to know how to get the query exexution time without printing the results. It's for performance comparaison. I want to evaluate MonetDB for my research and i'm working with large tables.
Please any idea??
Greetings, Baraa
Le 13 oct. 2013 ? 11:02, "Martin Kersten" <Martin.Kersten@cwi.nl <mailto:Martin.Kersten@cwi.nl>> a ?crit :
Hi
On 10/13/13 10:55 AM, baraa Mohamad wrote:
> Hello dear MontDB users, > > I have a question please, I just need to get the query execution time > without showing the results of the query (for performance > comparaison) . > Something which corresponds to the "traceonly" in Oracle. that will be > greate if I can see the query plan but for the moment the most > important > for me is to get the query execution time. > > for example: I want to know the query exection time of this query > (select * from source where a>10) knowing that I have more than one This is not the ind of query you fire when you expect a large outcome. Better use SELECT COUNT(*)....
> hundred million records which correspond to this predicate. > > Thank in advace for your appreciated help. > > Baraa
users-list mailing list users-list@monetdb.org <mailto:users-list@monetdb.org> https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org <mailto:users-list@monetdb.org> https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
Hi, the recommended way of transferring a database as a user rather than an administrator is to dump and restore it; cf., http://www.monetdb.org/Documentation/UserGuide/DumpRestore <dbfarm>/<dbname> (or <dbpath>) depend on how you start your MonetDB server; for details, see the respective man pages, i.e., `man monetdbd` `man monetdb` `man mserver5` or http://www.monetdb.org/Documentation/monetdbd-man-page http://www.monetdb.org/Documentation/monetdb-man-page http://www.monetdb.org/Documentation/mserver5-man-page Best, Stefan ----- Original Message -----
Thanks a lot for helping. I am unable to figure as to where does <dbfarm>/<dbname> directory reside within ubuntu 12.04. Can you please help me with this.
On Sun, Oct 13, 2013 at 6:06 PM, < users-list-request@monetdb.org > wrote:
Send users-list mailing list submissions to users-list@monetdb.org
To subscribe or unsubscribe via the World Wide Web, visit https://www.monetdb.org/mailman/listinfo/users-list or, via email, send a message with subject or body 'help' to users-list-request@monetdb.org
You can reach the person managing the list at users-list-owner@monetdb.org
When replying, please edit your Subject line so it is more specific than "Re: Contents of users-list digest..."
Today's Topics:
1. Re: Query execution time (baraa Mohamad) 2. Re: Query execution time (Martin Kersten) 3. Re: How to transfer monetdb database to another machine (Martin Kersten) 4. Re: Query execution time (Martin Kersten)
----------------------------------------------------------------------
Message: 1 Date: Sun, 13 Oct 2013 12:31:35 +0200 From: baraa Mohamad < bem85@hotmail.com > To: Communication channel for MonetDB users < users-list@monetdb.org > Cc: Communication channel for MonetDB users < users-list@monetdb.org > Subject: Re: Query execution time Message-ID: <BAY406-EAS1557A9804AABD08B94A7905A8190@phx.gbl> Content-Type: text/plain; charset="utf-8"
That's great! Thank you very much for your appreciated help.
I just could't really understand the output of this command.
This is my output: Real: 1m23 User: 0m24s Sys: 0m2.3s
I'm a little bit confused because when I execute the same query directly without the time option i get 733,28ms.
So i couldn't know what is the real execution time.
Le 13 oct. 2013 ? 11:29, "Martin Kersten" < Martin.Kersten@cwi.nl > a ?crit :
How about (time mclient -d db <inputfile >/dev/null)
On 10/13/13 11:24 AM, baraa Mohamad wrote: Thank you for your answer. But in general I would like to know how to get the query exexution time without printing the results. It's for performance comparaison. I want to evaluate MonetDB for my research and i'm working with large tables.
Please any idea??
Greetings, Baraa
Le 13 oct. 2013 ? 11:02, "Martin Kersten" < Martin.Kersten@cwi.nl <mailto: Martin.Kersten@cwi.nl >> a ?crit :
Hi
On 10/13/13 10:55 AM, baraa Mohamad wrote:
> Hello dear MontDB users, > > I have a question please, I just need to get the query execution time > without showing the results of the query (for performance > comparaison) . > Something which corresponds to the "traceonly" in Oracle. that will be > greate if I can see the query plan but for the moment the most > important > for me is to get the query execution time. > > for example: I want to know the query exection time of this query > (select * from source where a>10) knowing that I have more than one This is not the ind of query you fire when you expect a large outcome. Better use SELECT COUNT(*)....
> hundred million records which correspond to this predicate. > > Thank in advace for your appreciated help. > > Baraa
users-list mailing list users-list@monetdb.org <mailto: users-list@monetdb.org > https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org <mailto: users-list@monetdb.org > https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Rose Beck -
Stefan Manegold