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

Timeout on MySQL Connection looks to small in PMM 1.14

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 1.14.0
    • Fix Version/s: future
    • Component/s: PMM Client
    • Labels:

      Description

      Hi,

      See below. On the loaded system pmm-admin add mysql fails in just about
      2 seconds with timeout error. As we can see Percona Server was running.
      Need to assess if timeout should be increased.

      =====

      pmroot@Ymysql14:~# pmm-admin add mysql
      [linux:metrics] OK, already monitoring this system.
      [mysql:metrics] OK, now monitoring MySQL metrics using DSN
      root:***@unix(/var/ru
      n/mysqld/mysqld.sock)
      [mysql:queries] Error adding MySQL queries: Cannot connect to MySQL:
      context dea
      dline exceeded

      Verify that MySQL user exists and has the correct privileges.
      Use additional flags --user, --password, --host, --port, --socket if needed.
      root@Ymysql14:~# mysql
      Welcome to the MySQL monitor. Commands end with ; or \g.
      Your MySQL connection id is 142
      Server version: 5.7.22-22-log Percona Server (GPL), Release '22', Revision
      'f62d93c'

      Copyright (c) 2009-2018 Percona LLC and/or its affiliates
      Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

      Oracle is a registered trademark of Oracle Corporation and/or its
      affiliates. Other names may be trademarks of their respective
      owners.

      Type 'help;' or '\h' for help. Type '\c' to clear the current input
      statement.

      mysql> quit
      Bye
      root@Ymysql14:~# pmm-admin add mysql
      [linux:metrics] OK, already monitoring this system.
      [mysql:metrics] OK, already monitoring MySQL metrics.
      [mysql:queries] OK, now monitoring MySQL queries from slowlog using DSN
      root:***@unix(/var/run/mysqld/mysqld.sock)


      Peter Zaitsev, CEO, Percona

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  pz Peter Zaitsev
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated: