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

Percona Server is not detected appropriately, log_slow_* variables improperly detected

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Done
    • Affects Version/s: 1.1.4
    • Fix Version/s: 1.2.2
    • Component/s: QAN App
    • Labels:
    • Sprint:
      28W2017Y (07/10-07/16 ) R, 29W2017Y (07/17-07/23)

      Description

      Hi,

      Seeing this image in QAN2 settings in PMM 1.1.4

      As you can see it recommends me to install Percona Server to enable them. This page probably needs to be redone more as we're relaying on user to configure logging appropriately in PMM not changing settings for them if I understand correctly.

      This page also does not show settings properly:

      mysql> show variables like "%log_slow%";
      ------------------------------------------------------+
      Variable_name	Value
      ------------------------------------------------------+
      log_slow_admin_statements	ON
      log_slow_filter	 
      log_slow_rate_limit	100
      log_slow_rate_type	query
      log_slow_slave_statements	ON
      log_slow_sp_statements	ON
      log_slow_verbosity	microtime,query_plan,innodb
      ------------------------------------------------------+
      7 rows in set (0.00 sec)

      As you can see the log_slow_admin_statements and {{log_slow_slave_statements }}are shown as OFF while both are enabled.


      Peter Zaitsev, CEO, Percona
      Tel: +1 888 401 3401 ext 7360 Skype: peter_zaitsev

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                nailya.kutlubaeva Nailya Kutlubaeva
                Reporter:
                pz Peter Zaitsev
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: