Hi, i am developing a PHP5/MySQL website and testing it on my local machine, on an Apache server. And I have a problem.
I have written a PHP script that does a lot of computing and MySQL queries. I start it from a link on one of the pages on the site and when it's complete, and when it's done it writes in the output a sort of a "OK, DONE" statement on the next page.
This script has a lot of loops and can take up to 15 minutes to complete. The problem is that, while it is running, it takes up all of my CPU power, and I can't browse/do other stuff on the site until it's over.
It's definitely CPU, not memory - i tried to change memory_limit but it doesn't help.
Is there any way that I can limit the amount of CPU available to a single script???
(I don't mind if the script takes longer to complete, as long as I can do other stuff on the page comfortably while it is running.)could you not just put apache php and mysql on a lower priority in taskmgr? (if you use windows)Yes, but then if I make other requests to the apache server, it would still not have any room left for it in the cpu.
I guess I will just use sleep() between loops to give space to other processes...
I have written a PHP script that does a lot of computing and MySQL queries. I start it from a link on one of the pages on the site and when it's complete, and when it's done it writes in the output a sort of a "OK, DONE" statement on the next page.
This script has a lot of loops and can take up to 15 minutes to complete. The problem is that, while it is running, it takes up all of my CPU power, and I can't browse/do other stuff on the site until it's over.
It's definitely CPU, not memory - i tried to change memory_limit but it doesn't help.
Is there any way that I can limit the amount of CPU available to a single script???
(I don't mind if the script takes longer to complete, as long as I can do other stuff on the page comfortably while it is running.)could you not just put apache php and mysql on a lower priority in taskmgr? (if you use windows)Yes, but then if I make other requests to the apache server, it would still not have any room left for it in the cpu.
I guess I will just use sleep() between loops to give space to other processes...