dbaplus Community

May 30, 2025 · Databases

Why Does MySQL SHOW PROFILE Show “System lock” for Tablespace Import?

This article examines a MySQL case where importing a 4 GB tablespace takes 13 minutes, explains why SHOW PROFILE reports most of the time in the System lock stage, and dives into the internal implementation of SHOW PROFILE, data collection, calculation, and the tablespace import code path.