The SmartMySQL Debugger for Query Locks each other

The Smart-my-SQL Debugger for long-running queries issue: There are many cases to run slow queries on DB server if the queries didn’t review by DB performance expert and it causes DB server stall. Generally, a query runs slow if it ties up a lot of resources and there is resource contention on the server, namely CPU, memory and I/O. Apart from buying a bigger, faster server, indexing tables relevant to your slow queries could be one way to help improve performance. The Smart-My-SQL debugger automatically detects and displays long-running queries with a rich user interface. Also, it has the query optimizer feature, helps to fine-tune long running queries with optimal indexes.