database-optimizer

Risky tool definition detected

LIMIT 1000; RESET work_mem; ``` ### Maintenance Work Memory ```sql -- For VACUUM, CREATE INDEX, ALTER TABLE -- Recommended: 1-2GB for production systems ALTER SYSTEM SET maintenance_work_mem = '2GB'; -- Autovacuum workers use proportional amount ALTER SYSTEM SET autovacuum_work_mem = '512MB'; ``` ### Effective Cache Size ```sql -- Planner hint for available OS cache -- Recommended: 50-75% of total RAM -- For 16GB RAM: ALTER SYSTEM SET effective_cache_size = '12GB'; ``` ## Query Planner Settings

Risky tool definition detected

Risky tool definition detected

Description: VALUES IN ('cancelled', 'refunded') ); ``` ## Replication Optimization ### Binary Log Settings ```sql -- Binary log format SET GLOBAL binlog_format = 'ROW'; -- ROW, STATEMENT, or MIXED -- Binary log cache size SET GLOBAL binlog_cache_size = 1048576; -- 1MB per transaction -- Sync binary log (durability vs performance) SET GLOBAL sync_binlog = 1; -- Safest, sync after each commit -- sync_binlog = 0 -- Fastest, let OS handle flushing -- Expire binary logs after N days SET GLOBAL binlo