Hello all,



On my PHP5-APACHE webserver, I would like to run script requiring
MySQL queries. My problem is that when I launch this script, the MySQL
process uses about the entire ressource of the server.
So, when this script is running, i can not navigate in my website.

I have included the php function pcntl_fork() to launch my MySQL queries
on a child process, but MySQL is still using the whole ressources.
I have also reniced the MySQL priority to 20 but it still blocks
the httpd process.

How can I do to launch big MySQL scripts (via my web interface) and
keep using my website normally? It would not be a problem if this MySQL
script takes a long time to finish.

Any idea?

Dimitri.