DBeaver as a MySQL Workbench Replacement : Performance Queries
"Hey, Dave! "Is there any way to get the old MySQL Workbench performance information from DBeaver?" An old acquaintance asked me this question this morning. The queries running without an index and the high-cost SQL statement information were what was wanted. Yup. The good news is that all that information on the instance's performance is all SQL. And that SQL is pretty simple and runs on the MySQL server. You can grab a copy below of MySQLWorkbenchPerformanceQuries4DBeaver.sql or download from https://github.com/davestokes/HandySQL For those not in the know, these are short scripts with varying levels of utility for reporting information about a MySQL instance. I put them into a single .sql file to help diagnose trouble tickets. And you can run all these queries at once in DBeaver with ATL + X . For those new to MySQL administration, save a copy somewhere safe because someday you may need to know about memory, I/O hotspots, or buffer stats....