Question
ProxySQL main, runtime, and disk configuration: how do their roles differ?
Answer
Main tables are editable configuration state. Runtime tables drive live behavior. Disk persists configuration across restart. Load changes into runtime, then save validated configuration to disk. Applies to MySQL and MariaDB.