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

Cannot configure flush_caches on PS 5.7 using systemd

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Pending Release
    • Priority: Medium
    • Resolution: Reopened
    • Affects Version/s: 5.7
    • Fix Version/s: 5.7.23-23
    • Component/s: Packaging
    • Labels:
      None

      Description

      Hi guys,

             While testing I noticed that flush_caches cannot be configured on PS 5.7 instance where on systems using systemd. This is due to the fact that mysql_safe script is not installed I think. The following message is dispayed

      mysqld_safe wont be installed on platforms that use systemd to manage MySQL

      These messages are helpful as well:

      systemd starts two scripts https://github.com/percona/percona-server/blob/5.7/build-ps/ubuntu/percona-server-server-5.7.mysql.service :
      ExecStartPre=/usr/share/mysql/mysql-systemd-start pre
      ExecStartPre=/usr/bin/ps_mysqld_helper

      First could be found at https://github.com/percona/percona-server/blob/5.7/build-ps/ubuntu/extra/mysql-systemd-start and it fixes THP settings
      second is also related to THP and enables jemalloc: https://github.com/percona/percona-server/blob/5.7/scripts/ps_mysqld_helper.sh

      report a bug and ask to support flush caches as well in these helper script for correct large pages work.

      Can flush_caches be supported on systemd 

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                evgeniy.patlan Evgeniy Patlan
                Reporter:
                vishal.kasle Vishal Kasle (Inactive)
              • 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 - 6 hours
                  6h