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: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
