LISTSERV mailing list manager LISTSERV 16.5

Help for QSERV-L Archives


QSERV-L Archives

QSERV-L Archives


QSERV-L@LISTSERV.SLAC.STANFORD.EDU


View:

Message:

[

First

|

Previous

|

Next

|

Last

]

By Topic:

[

First

|

Previous

|

Next

|

Last

]

By Author:

[

First

|

Previous

|

Next

|

Last

]

Font:

Proportional Font

LISTSERV Archives

LISTSERV Archives

QSERV-L Home

QSERV-L Home

QSERV-L  July 2013

QSERV-L July 2013

Subject:

Re: Summer planning and Qserv large scale test

From:

Medernach <[log in to unmask]>

Reply-To:

General discussion for qserv (LSST prototype baseline catalog)

Date:

Thu, 11 Jul 2013 16:02:14 +0200

Content-Type:

text/plain

Parts/Attachments:

Parts/Attachments

text/plain (106 lines)

On 07/11/2013 03:53 PM, Douglas Smith wrote:
> Ok, I'll get these test together.  I checked on things, and it looks
> like the source production worked without errors, I found the
> bad nodes with the object production.  So that went fine, except
> for the lost time in the fileserver load.  The source loading into
> mysql is going on now, that should take ~2hours I guess.
>

Excellent news ! This is doing very well.

> So, then we'll have the meeting and then try the final config and
> see if things can start up.
>

About config, which xrootd files need to be changed, only supervisors ?

> Douglas
>
>
> On 07/11/2013 06:40 AM, Medernach wrote:
>> On 07/11/2013 02:23 PM, Douglas Smith wrote:
>>> Oh, yes, good point.  Lets do that, I'll check on the source
>>> production and make an announcement for that.
>>>
>> About the summer planning : I will be in holydays tomorrow for one week. I will
>> be back the 22nd of July (but busy on power off/restarting our grid Tier2 this
>> day and part of the day after) and available all summer until the 20th of August.
>>
>> I hope the Qserv scale test will do well. About benchmarking queries, the
>> following links have some kind of example queries we think interesting to test :
>>
>> https://dev.lsstcorp.org/trac/wiki/db/Qserv/IN2P3/BenchmarkMarch2013
>> https://dev.lsstcorp.org/trac/wiki/db/queries/ForPerfTest
>>
>> And also below is some query from our Petasky colleagues which takes quite a
>> long time (but it is Ok and I don't think it is a real problem) :
>>
>> select objectid as id, count(sourceid) as c
>> from Source
>> group by objectid
>> having  c > 1000
>> limit 10 ;
>>
>> Could you please set up a similar wiki page with queries and fill the results we
>> will obtain ?
>>
>> Thanks in advance,
>> --
>> Emmanuel
>>
>>> Douglas
>>>
>>> On 07/11/2013 12:39 AM, Medernach wrote:
>>>> On 07/11/2013 03:40 AM, Douglas Smith wrote:
>>>>> Well, most of the source production is done now, but 20-30
>>>>> machines are taking longer, and they are not done yet, although
>>>>> they appear close.
>>>>>
>>>>> I think I'm going to let this go, and do the data loading tomorrow.
>>>>> Perhaps Emmanuel can try to get the Object data loaded on the
>>>>> worker nodes.  The list.txt in the master etc dir has all the current
>>>>> node that are working at this point.
>>>>>
>>>>> I'll try and be back up and online by the afternoon France time
>>>>> tomorrow.
>>>>>
>>>> By the way, do we have planned a meeting at 9h00 (Pacific time) ?
>>>>
>>>>> Douglas
>>>>>
>>>>>
>>>>> On 07/10/2013 05:24 AM, Yvan Calas wrote:
>>>>>> On Jul 10, 2013, at 2:22 PM, Douglas Smith <[log in to unmask]> wrote:
>>>>>>
>>>>>>> Well, there is also the fact that the cmsd isn't going to work
>>>>>>> correctly until we define the supervisors also.  The master can
>>>>>>> only manage 63 workers, and the rest will just cause it problems.
>>>>>>>
>>>>>>> Maybe we should shut down the cmsd until the data has been
>>>>>>> produced on the nodes.
>>>>>> I killed the cmsd process few minutes ago.
>>>>>>
>>>>>> ---
>>>>>> Yvan Calas
>>>>>> CC-IN2P3 -- Storage Group
>>>>>> 43 Bd du 11 Novembre 1918
>>>>>> F-69622 Villeurbanne Cedex
>>>>>> Tel: +33 4 78 93 08 80
>>>>>>
>>>>>
>>>
>>>
>
> ########################################################################
> Use REPLY-ALL to reply to list
>
> To unsubscribe from the QSERV-L list, click the following link:
> https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1
>

########################################################################
Use REPLY-ALL to reply to list

To unsubscribe from the QSERV-L list, click the following link:
https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1

Top of Message | Previous Page | Permalink

Advanced Options


Options

Log In

Log In

Get Password

Get Password


Search Archives

Search Archives


Subscribe or Unsubscribe

Subscribe or Unsubscribe


Archives

March 2018
February 2018
January 2018
December 2017
August 2017
December 2016
November 2016
October 2016
September 2016
August 2016
July 2016
June 2016
May 2016
April 2016
March 2016
February 2016
January 2016
December 2015
November 2015
October 2015
September 2015
August 2015
July 2015
June 2015
May 2015
April 2015
March 2015
February 2015
January 2015
December 2014
November 2014
October 2014
September 2014
August 2014
July 2014
June 2014
May 2014
April 2014
March 2014
February 2014
January 2014
December 2013
November 2013
October 2013
September 2013
August 2013
July 2013
June 2013
May 2013
April 2013
March 2013
February 2013
January 2013
December 2012

ATOM RSS1 RSS2



LISTSERV.SLAC.STANFORD.EDU

Secured by F-Secure Anti-Virus CataList Email List Search Powered by the LISTSERV Email List Manager

Privacy Notice, Security Notice and Terms of Use