Question 1
Which of the following statements accurately describes the difference between dynamic and non-dynamic variables in a MySQL HeatWave configuration?
graph TD
A[Configuration Change] --> B{Restart Required?}
B -->|Yes| C[Non-Dynamic Variable]
B -->|No| D[Dynamic Variable]
C --> E[Change applied after DB System restart]
D --> F[Change applied immediately]
Answer and explanation
Correct answer: D
In MySQL, system variables are categorized as either dynamic or non-dynamic. A change to a dynamic variable takes effect immediately while the server is running. A change to a non-dynamic variable, which often affects fundamental aspects like storage engine configuration or buffer sizes, requires the MySQL server instance (the DB System) to be restarted before the new value is applied.
