From dev-return-907-archive-asf-public=cust-asf.ponee.io@zipkin.apache.org  Wed Jun 12 10:01:33 2019
Return-Path: <dev-return-907-archive-asf-public=cust-asf.ponee.io@zipkin.apache.org>
X-Original-To: archive-asf-public@cust-asf.ponee.io
Delivered-To: archive-asf-public@cust-asf.ponee.io
Received: from mail.apache.org (hermes.apache.org [207.244.88.153])
	by mx-eu-01.ponee.io (Postfix) with SMTP id 8EE7518061A
	for <archive-asf-public@cust-asf.ponee.io>; Wed, 12 Jun 2019 12:01:33 +0200 (CEST)
Received: (qmail 59517 invoked by uid 500); 12 Jun 2019 10:01:33 -0000
Mailing-List: contact dev-help@zipkin.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@zipkin.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@zipkin.apache.org>
List-Post: <mailto:dev@zipkin.apache.org>
List-Id: <dev.zipkin.apache.org>
Reply-To: dev@zipkin.apache.org
Delivered-To: mailing list dev@zipkin.apache.org
Received: (qmail 59504 invoked by uid 99); 12 Jun 2019 10:01:33 -0000
Received: from ec2-52-202-80-70.compute-1.amazonaws.com (HELO gitbox.apache.org) (52.202.80.70)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Jun 2019 10:01:33 +0000
From: GitBox <git@apache.org>
To: dev@zipkin.apache.org
Subject: [GitHub] [incubator-zipkin-brave] harishkadamudi opened a new issue #923:
 Zipkin issues with MariaDB Integration
Message-ID: <156033369293.21515.1842388607436954107.gitbox@gitbox.apache.org>
Date: Wed, 12 Jun 2019 10:01:32 -0000
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit

harishkadamudi opened a new issue #923: Zipkin issues with MariaDB Integration
URL: https://github.com/apache/incubator-zipkin-brave/issues/923
 
 
   ## Describe the Bug
   **Zipkin integrated with MariaDB creating duplicate Indexes**
   
   We have Zipkin server integrated with MariaDB.
   Of late, we found MariaDB is slow in responding, Calls from zipkin-UI are taking longer than usual time, we thought it could be because of data
   After close investigation, we found out that, multiple indexes on table zipkin span
   Indexes looks like below
   trace_id_high
   trace_id_high_2
   trace_id_high_2
   ....
   ....
   trace_id_high_15
   
   since it is creating multiple indexes, CPU usage is very high and doing lot of IO operations, hence delaying even a simple queries.
   
   ## Steps to Reproduce
   Steps to reproduce the behavior:
   Below is my pom details to reproduce the Issue.
   
   ```
   <zipkin.main.version>2.4.6</zipkin.main.version>
   <zipkin.server.version>2.4.6</zipkin.server.version>
   <spring.cloud.version>Dalston.RELEASE</spring.cloud.version>
   <spring.boot.version>1.5.14.RELEASE</spring.boot.version>
   
   <dependency>
   	<groupId>io.zipkin.java</groupId>
   	<artifactId>zipkin</artifactId>
   	<version>${zipkin.main.version}</version>
   </dependency>
   <dependency>
   	<groupId>io.zipkin.java</groupId>
   	<artifactId>zipkin-server</artifactId>
   	<version>${zipkin.server.version}</version>
   </dependency>
   <dependency>
   	<groupId>io.zipkin.java</groupId>
   	<artifactId>zipkin-autoconfigure-ui</artifactId>
   	<version>${zipkin.server.version}</version>
   	<scope>runtime</scope>
   </dependency>
   ```
   It also looks like every time we restart zipkin server indexes are growing in numbers
   
   ## Expected Behaviour
   Zipkin server shouldn't create multiple/duplicate Indexes
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@zipkin.apache.org
For additional commands, e-mail: dev-help@zipkin.apache.org