Peter Zaitsev posted a very interesting test on how PHP and Apache handle runaway PHP scripts.
I’m sure all of us have had a long executing SQL script or at least a runaway script, and he points out even with ignore_user_abort
set to FALSE and max execution times set both in PHP and Apache, a runaway SQL query can execute beyond the timeouts, even when aborted by the user (stop button on the browser).
Even using the function connection_aborted()
to check for a user abort fails.
However, the script will cease on a user abort if it performs regular ob_flush(); flush();
commands. For example:
1 2 3 4 5 6 7 8 9 |
|
Just one more reason why I love the MySql Performance Blog.