search

sysown / proxysql

High-performance MySQL proxy with a GPL license.
http://www.proxysql.com
GNU General Public License v3.0
6.04k stars 983 forks source link

Add more performance metrics #866

Closed renecannao closed 6 years ago

renecannao commented 7 years ago

ProxySQL's performance can be affected by many factors, like number of rules, compression, type of workload, average length of queries, rewrite, etc . Having more metrics on where time is spent can be extremely useful when troubleshooting bottlenecks and quickly suggest how to correctly tune variables for maximum performance.

geotro commented 7 years ago

May I suggest that these metrics are split by block, such as compression, rules, rewrite as you said, but then aggregated and shown in one place showing total avg time to serve say 10000 queries, and how time is split by blocks.

Which brings me to the next point, did someone already do a web UI for proxysql stats?

ahfeel commented 7 years ago

I think the only UI I've seen for ProxySQL so far is the one contained in ClusterControl, but it's a premium option... Would be really great to have a UI !

renecannao commented 7 years ago

Development needs time :) I am focusing mostly on the core, and exporting metrics in a simple format that anything can process. Severalnines did that! But there also other exporters, like:

renecannao commented 6 years ago

ProxySQL 1.4.4 has now a web UI :) Although very basic.

http://www.proxysql.com/blog/proxysql-http-server-initial-release