Liangxu Linux

Feb 26, 2020 · Databases

Why Redirecting MySQL Imports Beats Piping by Up to 3× – A SystemTap Performance Study

This article compares two common MySQL import techniques—piping a large dump through cat versus using input redirection—by measuring execution time and tracing system calls with SystemTap, revealing that redirection can be roughly three times faster due to fewer reads and context switches.