'Viewing SQL queries from all sources

I found this picture in a document. It shows the queries running on a given SQL database. It looks similar to DBeaver software. However, I couldn't find a way to get to this screen from DBeaver. Can someone please help me to figure out what software this is? It would be really helpful to troubleshoot performance-related issues.

enter image description here

mysqlsqldatabase


Solution 1:[1]

That's MySQL's SHOW PROCESSLIST.

IN ( SELECT ... ) often optimizes poorly; try to rewrite using a JOIN.

This may help:

INDEX(status, Calendar_Date, Date_Received)

For more help we need to see the queries and SHOW CREATE TABLE. You can obfuscate the names, but don't make it too hard to read.

{The TIMESTAMP qualifier is not required.)

Frameworks (eg, DBeaver) are handy for getting started. But ultimately you need to understand the underlying database.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Rick James

Related Questions