Description:
PERSISTED_ONLY statement set the wrong path in variables_info with non-dynamic variables.
8.0.13>SET PERSIST_ONLY back_log=2;
Query OK, 0 rows affected (0.00 sec)
8.0.13>
8.0.13>SET PERSIST_ONLY innodb_log_file_size= 1024 * 1024 * 1024;
Query OK, 0 rows affected (0.00 sec)
8.0.13>
8.0.13>select VARIABLE_NAME,VARIABLE_SOURCE,VARIABLE_PATH from performance_schema.variables_info where variable_source='PERSISTED';
+-------------------------+-----------------+-------------------------------------------------------+
| VARIABLE_NAME | VARIABLE_SOURCE | VARIABLE_PATH |
+-------------------------+-----------------+-------------------------------------------------------+
| back_log | PERSISTED | /dev/shm/qa/ms80/data/mysqld-auto.cnf/mysqld-auto.cnf |
| innodb_buffer_pool_size | PERSISTED | /dev/shm/qa/ms80/data/mysqld-auto.cnf |
| innodb_log_file_size | PERSISTED | /dev/shm/qa/ms80/data/mysqld-auto.cnf/mysqld-auto.cnf |
| innodb_undo_tablespaces | PERSISTED | /dev/shm/qa/ms80/data/mysqld-auto.cnf |
| max_connections | PERSISTED | /dev/shm/qa/ms80/data/mysqld-auto.cnf |
+-------------------------+-----------------+-------------------------------------------------------+
5 rows in set (0.00 sec)
8.0.13>
How to repeat:
1) Change non-dynamic variables with the SET PERSIST_ONLY statement.
SET PERSIST_ONLY innodb_log_file_size= 1024 * 1024 * 1024;
2) restart server
3) Check the non-dynamic variable info in performance_schema.variables_info table.
select VARIABLE_NAME,VARIABLE_SOURCE,VARIABLE_PATH from performance_schema.variables_info where variable_source='PERSISTED';
