I have a file, let's call it a.php, which executes a long cycle of iterations, each one of them makes some queries to the database. To complete the cycle, it takes quite some time (some hours).
My problem is that, while a.php is being processed, if I open a completely different page (b.php) that has just one Mysql query, it hangs on loading until a.php is done.
So my question is: how can I prevent this? I want a.php being processed and the ability to open different pages that also require Mysql.
The maximum 'thread_connected' I got from Mysql, with a.php being executed, is 10, and the 'max_connections' value is set to 151.