-- env cat /etc/*release Oracle Linux Server release 7.1 NAME="Oracle Linux Server" VERSION="7.1" ID="ol" VERSION_ID="7.1" PRETTY_NAME="Oracle Linux Server 7.1" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:oracle:linux:7:1" HOME_URL="https://linux.oracle.com/" BUG_REPORT_URL="https://bugzilla.oracle.com/" ORACLE_BUGZILLA_PRODUCT="Oracle Linux 7" ORACLE_BUGZILLA_PRODUCT_VERSION=7.1 ORACLE_SUPPORT_PRODUCT="Oracle Linux" ORACLE_SUPPORT_PRODUCT_VERSION=7.1 Red Hat Enterprise Linux Server release 7.1 (Maipo) Oracle Linux Server release 7.1 -- 93881.cnf [mysqld] innodb_buffer_pool_size=2G innodb_buffer_pool_instances=4 rm -rf 93881/ bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/93881 --log-error-verbosity=3 bin/mysqld_safe --defaults-file=./93881.cnf --basedir=$PWD --datadir=$PWD/93881 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/93881/log.err --log-error-verbosity=3 2>&1 & bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 8.0.14 MySQL Community Server - GPL Copyright (c) 2000, 2019, 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> show variables like 'innodb_buffer%'; +-------------------------------------+----------------+ | Variable_name | Value | +-------------------------------------+----------------+ | innodb_buffer_pool_chunk_size | 134217728 | | innodb_buffer_pool_dump_at_shutdown | ON | | innodb_buffer_pool_dump_now | OFF | | innodb_buffer_pool_dump_pct | 25 | | innodb_buffer_pool_filename | ib_buffer_pool | | innodb_buffer_pool_in_core_file | ON | | innodb_buffer_pool_instances | 4 | | innodb_buffer_pool_load_abort | OFF | | innodb_buffer_pool_load_at_startup | ON | | innodb_buffer_pool_load_now | OFF | | innodb_buffer_pool_size | 2147483648 | +-------------------------------------+----------------+ 11 rows in set (0.01 sec) mysql> set persist innodb_buffer_pool_size = default; Query OK, 0 rows affected (0.00 sec) mysql> RESTART; Query OK, 0 rows affected (0.00 sec) mysql> mysql> Restarting mysqld... 2019-01-26T07:27:52.476290Z mysqld_safe Number of processes running now: 0 2019-01-26T07:27:52.480263Z mysqld_safe mysqld restarted mysql> 2019-01-26T07:27:53.492517Z mysqld_safe Number of processes running now: 0 2019-01-26T07:27:53.496399Z mysqld_safe mysqld restarted mysql> 2019-01-26T07:27:55.129772Z mysqld_safe Number of processes running now: 0 2019-01-26T07:27:55.134043Z mysqld_safe mysqld restarted 2019-01-26T07:27:56.799116Z mysqld_safe Number of processes running now: 0 2019-01-26T07:27:56.803116Z mysqld_safe mysqld restarted 2019-01-26T07:27:58.431666Z mysqld_safe Number of processes running now: 0 2019-01-26T07:27:58.435990Z mysqld_safe mysqld restarted 2019-01-26T07:28:00.065763Z mysqld_safe Number of processes running now: 0 . . . 2019-01-26T07:28:43.184678Z mysqld_safe Number of processes running now: 0 2019-01-26T07:28:43.188903Z mysqld_safe mysqld restarted 2019-01-26T07:28:44.847105Z mysqld_safe Number of processes running now: 0 2019-01-26T07:28:44.851403Z mysqld_safe mysqld restarted ## As noted later by reporter mysql> set persist innodb_buffer_pool_size = 128*1024*1024; ERROR 1231 (42000): Variable 'innodb_buffer_pool_size' can't be set to the value of '134217728' mysql> mysql> set persist innodb_buffer_pool_size = default; Query OK, 0 rows affected (0.00 sec) -- extract from error log 2019-01-26T07:28:46.409239Z 5 [ERROR] [MY-011268] [Server] Configuring persisted options failed: "Variable 'innodb_buffer_pool_size' can't be set to the value of '134217728'". 2019-01-26T07:28:46.409292Z 0 [ERROR] [MY-010175] [Server] Setting persistent options failed.