Files
AzerothAI/deploy/classic/cache-storage.sql
2026-09-25 17:26:54 -07:00

6 lines
389 B
SQL

-- The upstream item-info builder already batches its writes in a transaction.
-- MyISAM ignores that transaction and syncs each statement to the binary log.
-- Use InnoDB so every restart retains full durability without per-row fsync.
-- Apply to the isolated Classic character database before starting mangosd.
ALTER TABLE ai_playerbot_item_info_cache ENGINE=InnoDB, ROW_FORMAT=DYNAMIC;