Aikesheng Open Source Community
Oct 11, 2019 · Databases
Persisting MySQL 8.0 Configuration with SET PERSIST and SET PERSIST_ONLY
This article explains how MySQL 8.0 introduces the SET PERSIST and SET PERSIST_ONLY statements to modify configuration variables dynamically and persist them across restarts, demonstrates usage with both dynamic and static parameters, shows the generated mysqld-auto.cnf file, discusses required privileges, and illustrates how to query persisted settings via performance_schema tables.
Database AdministrationMySQLPerformance Schema
0 likes · 10 min read