How do I make my import not affect site visitors?

Two strategies:

1. Time it for low-traffic windows. Run via cron at 3-5am local time.
2. Restrict the parallel-worker count. Each SSI worker holds a MySQL connection that’s unavailable to web traffic. On a busy site with max_connections = 151, eight SSI workers steal ~5% of the connection pool. Tune workers down to 2-4 for production sites.

The opt-in enable_db_tuning session bumps ONLY affect the SSI worker’s connection; they don’t affect web traffic, even when SSI is running.

Further reading

Related products

Super Speedy ImportsEasy to use. Built for speed.

Written for Super Speedy Imports 2.96.0.