Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id B3513200C77 for ; Mon, 1 May 2017 16:52:36 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id B1ED6160BAE; Mon, 1 May 2017 14:52:36 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 05CD3160BAB for ; Mon, 1 May 2017 16:52:35 +0200 (CEST) Received: (qmail 62136 invoked by uid 500); 1 May 2017 14:52:34 -0000 Mailing-List: contact dev-help@accumulo.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@accumulo.apache.org Delivered-To: mailing list dev@accumulo.apache.org Received: (qmail 62124 invoked by uid 99); 1 May 2017 14:52:33 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 01 May 2017 14:52:33 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 43C371B1401 for ; Mon, 1 May 2017 14:52:33 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 0.48 X-Spam-Level: X-Spam-Status: No, score=0.48 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RCVD_IN_SORBS_SPAM=0.5] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=deenlo-com.20150623.gappssmtp.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id 6H6PaBq0tFN7 for ; Mon, 1 May 2017 14:52:31 +0000 (UTC) Received: from mail-qk0-f174.google.com (mail-qk0-f174.google.com [209.85.220.174]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 0DC2E5F642 for ; Mon, 1 May 2017 14:52:30 +0000 (UTC) Received: by mail-qk0-f174.google.com with SMTP id y63so95584773qkd.1 for ; Mon, 01 May 2017 07:52:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=deenlo-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=dtc0+hYbTht1xFvIvM6QyCpJEmuvZu+F0oSRqsvNClY=; b=BOjM/y1l2vpIfwsh6aI4qwZvYI5MRdSH2uBTGHkeGGjDqCqUdPtwG4iDLCdUziQQuR iY1arDvjYqjkFgnj02rjNsiX7KyX/DYQizGxB7eZs18VPql20d50ZmrLCwzuiCPxZ/df rH7qObviG9FVMaWSJQ14rIQL+oLD+4dmqCUcGj0hjDoKfnf34zJsgDv8GNzdz/m+y0SN FKulSX8dSrh0WUlWaxz66/Gac0UWHiQPjAYc6WYQumwNaGsGG5RRLtQVnSxlj2Le6G8b mSGSeIE8kpwDdpGgJJW+MdFT6r9zoIV4g1BR88j4bVKe/FSgcCfWGTdga5iRrgO+u2HZ 0gpA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=dtc0+hYbTht1xFvIvM6QyCpJEmuvZu+F0oSRqsvNClY=; b=rsZGSRbiN7TUdoQ8MFZWww2RYmyz0QLFcCSPyva/QjBO/GKzHZLAesBrwgO5nRk/xC v1ahkS/mvRdr2aoWBLmU2X4UsB6NTjT6I5uxBd0/hqHypUKBZig16k7r9CjksApdy4VM VyAysOj9yTvlhEl/rkC9delmQvXU6fn4Csf7FTBRWkV2kv9PRoPXQGXOZgdTnV3TYXYm +fNoTVEN8dcfYXwhIBzwoKxNonyBV/umk6pc9+AGYu5d8ZL0VtSI2UYf8zljM+O+yFac 4HrJzXyQLrdMa7Bbsl271TPq79rkQLqzkApu3Jn4+zsyOrqz3yduR2Ibf9sHrwyZUyqe 9KNw== X-Gm-Message-State: AN3rC/49kCXzVr38sWISds2Og14SH51iUj3UDfgjeawchvAsNq2Ya9GE IyJQuP74LVtUg2DDCErK9m+3P7vf9g== X-Received: by 10.55.20.102 with SMTP id e99mr20207364qkh.191.1493650344433; Mon, 01 May 2017 07:52:24 -0700 (PDT) MIME-Version: 1.0 Received: by 10.12.141.66 with HTTP; Mon, 1 May 2017 07:52:23 -0700 (PDT) In-Reply-To: References: From: Keith Turner Date: Mon, 1 May 2017 10:52:23 -0400 Message-ID: Subject: Re: Accumulo Table Sacanning Taking Time!!! To: Accumulo Dev List Content-Type: text/plain; charset=UTF-8 archived-at: Mon, 01 May 2017 14:52:36 -0000 Do you know if the tablet server and/or client is CPU bound? When you run the query, do you see either go to 100% CPU? For the *~1 million* records, what is the data size? I Ask because I am curious what the data rate is? For example is it 2MB/sec 500KB/sec? On Thu, Apr 27, 2017 at 7:09 AM, Suresh Prajapati wrote: > Hello Team > > I am developing a client in accumulo to store geo-spatial information and > using geomesa for indexing on top of it. However i found that scanning *~1 > million* records taking *2-3 sec*. I looked at indexes and query plan of > geomesa but not able to find cause of the problem. I am running accumulo as > single tablet-server(including master). I want to know - > what are the factors can affect accumulo scanning operation? how can I > optimise this time? > > Thank You > Suresh Prajapati