Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Wed, 7 Sep 2011 18:11:10 +0000 (UTC)
From: "Kevin Wilfong (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: 
 <148582726.26751.1315419070035.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <859369368.26726.1315418590401.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Updated] (HIVE-2430) Performance degradation in stats DB
 after JIRA HIVE-2144 (https://issues.apache.org/jira/browse/HIVE-2144)
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/HIVE-2430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kevin Wilfong updated HIVE-2430:
--------------------------------

    Summary: Performance degradation in stats DB after JIRA HIVE-2144 (https://issues.apache.org/jira/browse/HIVE-2144)  (was: Performance degradation after After JIRA HIVE-2144 (https://issues.apache.org/jira/browse/HIVE-2144))

> Performance degradation in stats DB after JIRA HIVE-2144 (https://issues.apache.org/jira/browse/HIVE-2144)
> ----------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-2430
>                 URL: https://issues.apache.org/jira/browse/HIVE-2430
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Kevin Wilfong
>            Assignee: Kevin Wilfong
>
> After JIRA HIVE-2144 (https://issues.apache.org/jira/browse/HIVE-2144), the performance in stats DB degraded significantly due to MySQL's inefficient index maintenance. 
> We should remove the primary index introduced in that JIRA and resolve duplicates in the stats aggregation
> phase. 

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira