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

Removing PMM-Client package(pmm1 client) silently disabling slow_query log on mysql server

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: High
    • Resolution: Unresolved
    • Affects Version/s: 1.17.3
    • Fix Version/s: None
    • Component/s: Documentation
    • Labels:
      None

      Description

      I*ssue:* Removing PMM-Client(pmm1 client) silently disabling slow_query log of mysql server.

      Ref: https://forums.percona.com/discussion/comment/56169

      Steps:

       

      1. mysql/ps server with slow log enabled
      
      # pmm-admin add mysql ps57 --user=msandbox --password=msandbox --socket=/tmp/mysql_sandbox5730.sock --query-source slowlog
      [linux:metrics] OK, now monitoring this system.
      [mysql:metrics] OK, now monitoring MySQL metrics using DSN msandbox:***@unix(/tmp/mysql_sandbox5730.sock)
      [mysql:queries] OK, now monitoring MySQL queries from slowlog using DSN msandbox:***@unix(/tmp/mysql_sandbox5730.sock)
      root@lalit-ThinkPad-T480:~#
      
      mysql [localhost] {msandbox} ((none)) > show variables like 'slow_query_log';
      +----------------+-------+
      | Variable_name | Value |
      +----------------+-------+
      | slow_query_log | ON |
      +----------------+-------+
      
      # pmm-admin list
      pmm-admin 1.17.3
      PMM Server | 172.17.0.2:80 
      Client Name | lalit-ThinkPad-T480
      Client Address | 172.17.0.1 
      Service Manager | linux-systemd
      -------------- ----- ----------- -------- ----------------------------------------------- --------------------------------------------------------------------------------------
      SERVICE TYPE NAME LOCAL PORT RUNNING DATA SOURCE OPTIONS 
      -------------- ----- ----------- -------- ----------------------------------------------- --------------------------------------------------------------------------------------
      mysql:queries ps57 - YES msandbox:***@unix(/tmp/mysql_sandbox5730.sock) query_source=slowlog, query_examples=true, slow_log_rotation=true, retain_slow_logs=1 
      linux:metrics ps57 42000 YES - 
      mysql:metrics ps57 42002 YES msandbox:***@unix(/tmp/mysql_sandbox5730.sock)
      
      # apt-get remove pmm-client 
      Reading package lists... Done
      Building dependency tree 
      Reading state information... Done
      The following packages will be REMOVED:
       pmm-client
      0 upgraded, 0 newly installed, 1 to remove and 72 not upgraded.
      After this operation, 70.1 MB disk space will be freed.
      Do you want to continue? [Y/n] y
      (Reading database ... 253355 files and directories currently installed.)
      Removing pmm-client (1.17.3-1.bionic) ...
      OK, 3 services were removed.
      Uninstall complete.
      
      mysql [localhost] {msandbox} ((none)) > show variables like 'slow_query_log';
      +----------------+-------+
      | Variable_name | Value |
      +----------------+-------+
      | slow_query_log | OFF |
      +----------------+-------+
      1 row in set (0.01 sec)
      
      
      
      OR
      # apt-get install pmm2-client
      Reading package lists... Done
      Building dependency tree 
      Reading state information... Done
      The following packages will be REMOVED:
       pmm-client
      The following NEW packages will be installed:
       pmm2-client
      0 upgraded, 1 newly installed, 1 to remove and 72 not upgraded.
      Need to get 0 B/61.8 MB of archives.
      After this operation, 94.8 MB of additional disk space will be used.
      Do you want to continue? [Y/n] y
      (Reading database ... 253355 files and directories currently installed.)
      Removing pmm-client (1.17.3-1.bionic) ...
      OK, 3 services were removed.
      Uninstall complete.
      Selecting previously unselected package pmm2-client.
      (Reading database ... 253340 files and directories currently installed.)
      Preparing to unpack .../pmm2-client_2.7.0-6.bionic_amd64.deb ...
      Unpacking pmm2-client (2.7.0-6.bionic) ...
      Setting up pmm2-client (2.7.0-6.bionic) ...
      mysql [localhost] {msandbox} ((none)) > show variables like 'slow_query_log';
      +----------------+-------+
      | Variable_name | Value |
      +----------------+-------+
      | slow_query_log | OFF |
      +----------------+-------+
      1 row in set (0.01 sec)
      

       

       

      There is no documentation on this behavior in,

      https://www.percona.com/doc/percona-monitoring-and-management/deploy/index.html#deploy-pmm-client-removing

       

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              lalit.choudhary Lalit Choudhary
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated: