I have a problem that should be rather easy to troubleshoot
I have a php script that needs to run for 30 minutes, 1 hour or even several hours using intensively PHP and MySQL.
When this script is running, I can't access other pages/scripts. To clarify, it's like if there was only one apache thread running, or no resources were available to serve a new request.
The other page just keeps loading ( firefox tab loading )
httpd.exe uses ~40MB if memory, mysqld.exe ~30MB ( currently it's running on my own computer, windows + xampp, until it's ready and will be moved to a linux vps ).
I need this script to keep running as long as necessary, but some resources must remain available to serve other requests...which settings do I need to change?
I suppose you have to look into how you can change tasks priority in the OS you're using. I'd love to be able to help with actual instructions, but I haven't used Windows in a very long time.
Maybe one of these will do the trick for you:
I tried setting httpd and mysqld priorities below normal and above normal, no difference.
moreover, httpd-mpm.conf reads:
but it sounds like 149 threads have something else to do...