reading Massive data mysql optimization experience January 24, 2024 by James Knight-Boon No Comments Do not put the table with massive data and other service tables in the same database. 2. Do not create indexes or separate databases for the table with massive data and use it only for backup. Hot data goes through Redis