Forums

MySQL remote access and web workers

Hi,

I have a remote machine which has to do some pretty intense computation and update the results on my PA's MySQL instance using remote tunneling. Most of the time the database will be accessed from the remote machine very frequently. So will that use up web workers here on PA or can it affect the performance of web app?

If you're using tunneling via SSH then it won't affect the performance of your web workers directly -- though it will count against your CPU allowance to a certain degree, as the SSH process that's handling the PythonAnywhere side of your tunnel will be running as you.

Of course, if the amount of queries you're doing on the database use up a lot of its CPU, that may affect the performance of any queries that your web workers are doing, so that could slow them down.