Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.11.0
    • Component/s: PMM Client
    • Labels:
      None

      Description

      1. Set up max_slowlog_size:
        mysql> set global max_slowlog_size = 4096;
        Query OK, 0 rows affected (0.00 sec)
        
        mysql> SHOW GLOBAL VARIABLES LIKE '%slowlog_size%';
        +------------------+-------+
        | Variable_name    | Value |
        +------------------+-------+
        | max_slowlog_size | 4096  |
        +------------------+-------+
        1 row in set (0.00 sec)
        
      2. Add mysql with slow log to monitoring:
        nailya.kutlubaeva@bm-dell06-qanqa03:~$ sudo pmm-admin add mysql --retain-slow-logs=4
        [linux:metrics] OK, now monitoring this system.
        [mysql:metrics] OK, now monitoring MySQL metrics using DSN root:***@unix(/var/run/mysqld/mysqld.sock)
        [mysql:queries] OK, now monitoring MySQL queries from slowlog using DSN root:***@unix(/var/run/mysqld/mysqld.sock)
        

      Result: PMM changed max_slowlog_size to 0
      Expected result: PMM should change it only when --disable-slow-log option is passed

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  Unassigned
                  Reporter:
                  nailya.kutlubaeva Nailya Kutlubaeva
                • 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 - 0 minutes
                    0m
                    Logged:
                    Time Spent - 3 hours, 30 minutes
                    3h 30m