i have a process that runs, but stops after about 3 minutes. It only processes some of the information (65 entries out of 500). i modified the php.ini, thinking this was the case. The process takes data from a mysql database and writes them to a file.


register_globals = off
allow_url_fopen = off

magic_quotes_gpc = off
magic_quotes_runtime = off

expose_php = Off
max_input_time = 0
max_execution_time = 0
mysql.connect_timeout = 999999999999999999999999999999999999
session.gc_maxlifetime = 999999999999999999999999999999999999
default_socket_timeout = 999999999999999999999999999999999999
post_max_size = 500M
upload_max_filesize = 500M
max_file_uploads = 999999999999
max_input_nesting_level = 9999999999999
memory_limit = 800M
session.gc_maxlifetime = 99999999999999999999999999999
session.cache_expire = 999999999999999999999
realpath_cache_size = 999999999999999999999999
variables_order = "EGPCS"
extension_dir = ./
upload_tmp_dir = /tmp
precision = 12
SMTP = relay-hosting.secureserver.net
url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=,fieldset="

[Zend]
zend_extension=/usr/local/zo/ZendExtensionManager.so
zend_extension=/usr/local/zo/4_3/ZendOptimizer.so


im not sure if i missed something in the php.ini file that would cause a script to stop and not finish. Any ideas. anything in the mysql database i need to modify

This might be due to low wait_timeout of MySQL value. What is the value of wait_timeout? To know the value of wait_timeout run this in MySQL

SHOW GLOBAL VARIABLES LIKE 'wait_timeout';

Increase the value by running this query e.g.

SET GLOBAL wait_timeout=5000

This might be due to low wait_timeout of MySQL value. What is the value of wait_timeout?

Default value should be 180 seconds, so I think you are correct. It matches the three minute limitation mentioned.

A script that takes three minutes to process 65 entries???
What on earth is it doing in all that time?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.