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

ProxySQL Active Frontend Connections graph is unusable with +10k clients

Details

    • 1.75
    • Yes
    • Yes
    • No
    • Observability
    • Hide

      Check Active Frontend Connection panel with 10000 client connections.

      Show
      Check Active Frontend Connection panel with 10000 client connections.

    Description

      When thousands of Client connections are established against ProxySQL, the performance of Active Frontend Connections leads to a graph that doesn't render. Further this can make the rendering and general usage of ProxySQL Instance Summary dashboard feel very sluggish.
      We should find a way to use topk or other limiter in order to reduce the impact of analyzing +10k metric series, specifically series proxysql_processlist_client_connection_list
      This is expected to be a somewhat common occurrence as one of the value propositions of ProxySQL is the connection pooling feature, so thousands of client connections is expected.

      Steps to Reproduce

      1. Launch PMM Server against ProxySQL v2.4 + PXC or Percona Server for MySQL
      2. Launch 10,000 client connections against ProxySQL
      3. Load ProxySQL Instance Summary dashboard

      Attachments

        1. image-2023-03-02-22-51-12-803.png
          95 kB
          Ihor Cherkasov
        2. image-2023-03-03-16-39-01-162.png
          185 kB
          Ihor Cherkasov
        3. image-2023-03-22-02-42-03-876.png
          255 kB
          Ihor Cherkasov
        4. PMM-Demo.png
          31 kB
          Aaditya Dubey

        Activity

          People

            anton.bystrov Anton Bystrov
            michael.coburn@percona.com Michael Coburn
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist