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

Cannot configure flush_caches on PS 5.7 using systemd

    Details

    • Type: Bug
    • Status: Done
    • 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 

        Smart Checklist

          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