Resources management

Server Config
1

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?

2

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:

http://xona.com/2004/07/22.html
http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/taskman_change_priority.mspx?mfr=true

3

I tried setting httpd and mysqld priorities below normal and above normal, no difference.
moreover, httpd-mpm.conf reads:

<IfModule mpm_winnt_module>
    ThreadsPerChild      150
    MaxRequestsPerChild    0
    #Win32DisableAcceptEx
</IfModule>

but it sounds like 149 threads have something else to do… :smiley: