- Create a localized systemd configuration file:
shell> sudo mkdir -pv /etc/systemd/system/mysqld.service.d
- Create/open the conf file:
shell> sudo vi /etc/systemd/system/mysqld.service.d/override.conf
- Enter the following:
[Service]LimitNOFILE=max_open_files (ex: 102400)PIDFile=/path/to/pid/file (ex: /var/lib/mysql/mysql.pid)Nice=nice_level (ex: -10)Environment="LD_PRELOAD=/path/to/malloc/library" Environment="TZ=time_zone_setting"
- Reload systemd:
shell> sudo systemctl daemon-reload
- For temporary changes, you can reload without editing the conf file:
shell> sudo systemctl set-environment MYSQLD_OPTS="--general_log=1"or unset usingshell> sudo systemctl unset-environment MYSQLD_OPTS
- After modifying the systemd environment, ...