Uploaded image for project: 'Percona Monitoring and Management'
  1. Percona Monitoring and Management
  2. PMM-8091

Collect and present additional ProxySQL metrics taken from `runtime_mysql_servers` table

Details

    • Improvement
    • Status: Done
    • Medium
    • Resolution: Fixed
    • None
    • 2.21.0
    • ProxySQL_Exporter
    • --addclient=pxc,3 --with-proxysql

    • 1
    • Yes
    • Yes
    • [obsolete] C/S Core

    Description

      It's required to review a community PR about adding collector from runtime_mysql_servers table.

      User impact:
      Now we are collecting statuses from stats_mysql_connection_pool table.
      But according to discussion sysown/proxysql#1817
      stats_mysql_connection_pool collects way more statistics than just the status of the server: it reports number of current connections and historical one (successful and not), number of queries, and bytes sent/received.
      Therefore when a server is removed, it isn't immediately deleted from stats_mysql_connection_pool, or these statistics are lost.
      So such data can't be used in alerts.

      Also it's required to add "Endpoint Details Status" element on "ProxySQL Instance Summary" dashboard.  Data is provided by the new collector.

      Attachments

        Issue Links

          Activity

            People

              vadim.yalovets Vadim Yalovets
              vadim.yalovets Vadim Yalovets
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 1 week, 1 day, 3 hours, 25 minutes
                  1w 1d 3h 25m

                  Smart Checklist