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 yet completely loaded, but progress had been made (debug logs confirm this). When I ran 'show full processlist' several times more in succession, the request completed quickly.
I can currently reproduce this - unless I run 'show full processlist' over and over on the remote server, my local request usually times out.
Does anyone have any idea why this would happen? I'm running Django 1.3 and OS X 10.7.
Note: I realize this may be entirely not be a question with a clear-cut answer and is probably my fault, but it is odd and reproducable, so I hope someone can at least point me the right direction. Thanks in advance.