[GitHub] [incubator-zipkin-brave] harishkadamudi opened a new issue #923: Zipkin issues with MariaDB Integration

[GitBox <gi...@apache.org>]

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