Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-6925

Correct mismatched default socket values for mysqld and mysqld_safe

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 5.7.29-32
    • Fix Version/s: 5.7.30-33
    • Component/s: Packaging
    • Labels:
      None

      Description

      After install Percona Server 5.7 via yum repos, the cnf files look like:

       

      [root@marcos-albe-centos7-001 ~]# tail -n +1 /etc/percona-server.conf.d/*
      ==> /etc/percona-server.conf.d/mysqld.cnf <==
      # Percona Server template configuration
      [mysqld]
      #
      # Remove leading # and set to the amount of RAM for the most important data
      # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
      # innodb_buffer_pool_size = 128M
      #
      # Remove leading # to turn on a very important data integrity option: logging
      # changes to the binary log between backups.
      # log_bin
      #
      # Remove leading # to set options mainly useful for reporting servers.
      # The server defaults are faster for transactions and fast SELECTs.
      # Adjust sizes as needed, experiment to find the optimal values.
      # join_buffer_size = 128M
      # sort_buffer_size = 2M
      # read_rnd_buffer_size = 2M
      datadir=/var/lib/mysql
      socket=/var/lib/mysql/mysql.sock
      # Disabling symbolic-links is recommended to prevent assorted security risks
      symbolic-links=0
      log-error=/var/log/mysqld.log
      pid-file=/var/run/mysqld/mysqld.pid
      ==> /etc/percona-server.conf.d/mysqld_safe.cnf <==
      #
      # The Percona Server 5.7 configuration file.
      #
      # One can use all long options that the program supports.
      # Run program with --help to get a list of available options and with
      # --print-defaults to see which it would actually understand and use.
      #
      # For explanations see
      # http://dev.mysql.com/doc/mysql/en/server-system-variables.html
      [mysqld_safe]
      pid-file = /var/run/mysqld/mysqld.pid
      socket = /var/run/mysqld/mysqld.sock
      nice = 0
      

      Notice how socket paths differ (/var/lib/mysql/mysql.sock vs /var/run/mysqld/mysqld.sock).

      In a systemd linux it took the one under [mysqld]

       

      [root@marcos-albe-centos7-001 ~]# mysql
      Welcome to the MySQL monitor. Commands end with ; or \g.
      Your MySQL connection id is 4
      Server version: 5.7.29-32 Percona Server (GPL), Release 32, Revision 56bce88
      Copyright (c) 2009-2020 Percona LLC and/or its affiliates
      Copyright (c) 2000, 2020, 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> select @@socket;
      +---------------------------+
      | @@socket |
      +---------------------------+
      | /var/lib/mysql/mysql.sock |
      +---------------------------+
      1 row in set (0.00 sec)
       
      

       

       

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              illia.pshonkin Illia Pshonkin
              Reporter:
              marcos.albe Marcos Albe
              Votes:
              0 Vote for this issue
              Watchers:
              4 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 - 1 hour
                  1h