MySQL Forums
Forum List  »  PHP

queries not executed at all because of max queries limit?
Posted by: Mark Dagger
Date: March 31, 2006 05:34AM

Hi to everybody,

I have a problem with MySQL queries executed from within PHP; I execute, in the same script, thousands of SELECT/UPDATE queries, but nearly 3000 are NOT EXECUTED AT ALL, nor they return a mysql error like "you've made too many queries and you were blocked by the mysql server". Queries are correct, meaning I print them to screen and execute them via phpmyadmin and they work correctly. The PHP script runs correctly, I had to put set_time_limit(0) in order to wait until the end but no PHP error is returned either.

Does anybody know if there's a MySQL (or PHP) parameter regarding the max number of queries per script (like, 10.000), or the maximum execution time for a connection, after which no error is returned and the connection is simply broken?

Thanks to all

Options: ReplyQuote


Subject
Written By
Posted
queries not executed at all because of max queries limit?
March 31, 2006 05:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.