system variables

Aikesheng Open Source Community

Oct 8, 2023 · Databases

Why Adding foreign_key_checks to my.cnf Causes MySQL Startup Failure and How to Identify Non‑Configurable System Variables

This article investigates why inserting the foreign_key_checks system variable into MySQL's my.cnf prevents the server from starting, explains the underlying NO_CMD_LINE flag mechanism, and provides a simple command‑line method to distinguish variables that can or cannot be set via configuration files.

MySQLNO_CMD_LINEconfiguration

0 likes · 6 min read

Why Adding foreign_key_checks to my.cnf Causes MySQL Startup Failure and How to Identify Non‑Configurable System Variables

Aikesheng Open Source Community

Aug 8, 2023 · Databases

Why Adding foreign_key_checks to my.cnf Breaks MySQL Startup and How to Identify Non‑Configurable System Variables

This article investigates why inserting the foreign_key_checks variable into MySQL's my.cnf causes the server to fail to start, explains the underlying NO_CMD_LINE flag mechanism, and provides a simple command‑line method to distinguish variables that can or cannot be set via configuration files.

MySQLNO_CMD_LINEconfiguration

0 likes · 6 min read

Why Adding foreign_key_checks to my.cnf Breaks MySQL Startup and How to Identify Non‑Configurable System Variables

Aikesheng Open Source Community

Nov 18, 2020 · Databases

How to Persist Global System Variables in MySQL 8

This article explains MySQL 8's persisted system variables feature, showing how to use SET PERSIST and SET PERSIST_ONLY to make variable changes survive restarts, how to view and clear persisted settings, how to disable persistence, required privileges, and how to monitor persisted variables via performance_schema.

Database AdministrationMySQLSET PERSIST

0 likes · 7 min read

How to Persist Global System Variables in MySQL 8