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
|