Why would the 'show processlist' command speed up normally slow requests to my remote DB? (connected via VPN)
- by Hakan B.
I am running a local Django development server that connects to a remote MySQL server via a VPN (IPSec). Request times are awfully slow and I consistently see timeouts.
Attempting to diagnose the problem, I logged in to the remote database and ran:
show full processlist
Immediately, the local server went from idle to working. The page had not…