search

charles-001 / dolphie

Your single pane of glass for real-time analytics into MySQL/MariaDB & ProxySQL
https://pypi.org/project/dolphie/
GNU General Public License v3.0
654 stars 40 forks source link

Slow queries - FR #10

Closed lefred closed 1 year ago

lefred commented 1 year ago

It would be great to have a panel that check in PFS the slow queries ans then display some metadata and Query Execution Plan for those queries.

See https://lefred.be/content/mysql-8-0-if-i-should-optimize-only-one-query-on-my-application-which-one-should-it-be/ for ideas

charles-001 commented 1 year ago

The thing with PFS data is that it aggregates data from the time MySQL starts. Dolphie is built to be a real time view of what's happening so not sure if I want to include possible stale/inaccurate data.

charles-001 commented 1 year ago

Closing this since it's been 2 weeks with no response