Re: mysql/php time out issue

Chaitanya Look like you are using php 5.3 on a windows box. I don't have exit_on_timeout in 5.1. I've tried changing all the configurations and it still stop at 127 loops at about 27 seconds. The query executed separately is calling about 3500 emails. Maybe sendmail is timing out? I'm also using a dkim-filter. Could that be interfering? I also have /E/nvironment in variables_order which I see you don't have but I don't think that would be a cause. Here are the current configurations. Directive Local Value Master Value allow_call_time_pass_reference On On allow_url_fopen On On always_populate_raw_post_data Off Off arg_separator.input & & arg_separator.output & & asp_tags Off Off auto_append_file /no value/ /no value/ auto_globals_jit On On auto_prepend_file /no value/ /no value/ browscap /no value/ /no value/ default_charset /no value/ /no value/ default_mimetype text/html text/html define_syslog_variables Off Off disable_classes /no value/ /no value/ disable_functions /no value/ /no value/ display_errors Off Off display_startup_errors Off Off doc_root /no value/ /no value/ docref_ext /no value/ /no value/ docref_root /no value/ /no value/ enable_dl On On error_append_string /no value/ /no value/ error_prepend_string /no value/ /no value/ error_reporting 2047 2047 expose_php On On file_uploads On On highlight.bg #FFFFFF #FFFFFF highlight.comment #FF8000 #FF8000 highlight.default #0000BB #0000BB highlight.html #000000 #000000 highlight.keyword #007700 #007700 highlight.string #DD0000 #DD0000 html_errors On On ignore_repeated_errors Off Off ignore_repeated_source Off Off ignore_user_abort Off Off implicit_flush Off Off log_errors On On log_errors_max_len 1024 1024 magic_quotes_gpc On On magic_quotes_runtime Off Off magic_quotes_sybase Off Off mail.force_extra_parameters /no value/ /no value/ max_execution_time 6000 6000 max_input_nesting_level 64 64 max_input_time 600 600 memory_limit 128M 128M open_basedir /no value/ /no value/ output_buffering 4096 4096 output_handler /no value/ /no value/ post_max_size 8M 8M precision 14 14 realpath_cache_size 16K 16K realpath_cache_ttl 120 120 register_argc_argv Off Off register_globals On On register_long_arrays On On report_memleaks On On report_zend_debug On On safe_mode Off Off safe_mode_exec_dir /no value/ /no value/ safe_mode_gid Off Off safe_mode_include_dir /no value/ /no value/ sendmail_from /no value/ /no value/ sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i serialize_precision 100 100 short_open_tag On On SMTP localhost localhost smtp_port 25 25 sql.safe_mode Off Off track_errors Off Off unserialize_callback_func /no value/ /no value/ upload_max_filesize 2M 2M upload_tmp_dir /no value/ /no value/ user_dir /no value/ /no value/ variables_order EGPCS EGPCS xmlrpc_error_number 0 0 xmlrpc_errors Off Off y2k_compliance On On zend.ze1_compatibility_mode Off Off On 4/9/2010 10:57 AM, Chaitanya Yanamadala wrote:

these are the entire core values of mine try making a replica of the required.. i am able to send for 30000 mails. are u using an smtp sever to send mails.. allow_call_time_pass_reference On On allow_url_fopen On On allow_url_include On On always_populate_raw_post_data Off Off arg_separator.input & & arg_separator.output &amp; &amp; asp_tags Off Off auto_append_file /no value/ /no value/ auto_globals_jit On On auto_prepend_file /no value/ /no value/ browscap C:\xampp\php\extras\browscap.ini C:\xampp\php\extras\browscap.ini default_charset /no value/ /no value/ default_mimetype text/html text/html define_syslog_variables Off Off disable_classes /no value/ /no value/ disable_functions /no value/ /no value/ display_errors On On display_startup_errors On On doc_root /no value/ /no value/ docref_ext /no value/ /no value/ docref_root /no value/ /no value/ enable_dl On On error_append_string /no value/ /no value/ error_log /no value/ /no value/ error_prepend_string /no value/ /no value/ error_reporting 22519 22519 exit_on_timeout Off Off expose_php On On extension_dir C:\xampp\php\ext C:\xampp\php\ext file_uploads On On highlight.bg <http://highlight.bg> #FFFFFF #FFFFFF highlight.comment #FF8000 #FF8000 highlight.default #0000BB #0000BB highlight.html #000000 #000000 highlight.keyword #007700 #007700 highlight.string #DD0000 #DD0000 html_errors On On ignore_repeated_errors Off Off ignore_repeated_source Off Off ignore_user_abort Off Off implicit_flush Off Off include_path .;C:\xampp\php\PEAR .;C:\xampp\php\PEAR log_errors Off Off log_errors_max_len 1024 1024 magic_quotes_gpc On On magic_quotes_runtime Off Off magic_quotes_sybase Off Off mail.add_x_header Off Off mail.force_extra_parameters /no value/ /no value/ mail.log /no value/ /no value/ max_execution_time 6000 6000 max_input_nesting_level 64 64 max_input_time 600 600 memory_limit 128M 128M open_basedir /no value/ /no value/ output_buffering /no value/ /no value/ output_handler /no value/ /no value/ post_max_size 128M 128M precision 14 14 realpath_cache_size 16K 16K realpath_cache_ttl 120 120 register_argc_argv On On register_globals Off Off register_long_arrays Off Off report_memleaks On On report_zend_debug On On request_order /no value/ /no value/ safe_mode Off Off safe_mode_exec_dir /no value/ /no value/ safe_mode_gid Off Off safe_mode_include_dir /no value/ /no value/ sendmail_from /no value/ /no value/ sendmail_path /no value/ /no value/ serialize_precision 100 100 short_open_tag On On smtp_port 25 25 sql.safe_mode Off Off track_errors Off Off unserialize_callback_func /no value/ /no value/ upload_max_filesize 128M 128M upload_tmp_dir C:\xampp\tmp C:\xampp\tmp user_dir /no value/ /no value/ user_ini.cache_ttl 300 300 user_ini.filename .user.ini .user.ini variables_order GPCS GPCS xmlrpc_error_number 0 0 xmlrpc_errors Off Off y2k_compliance On On zend.enable_gc On On Chaitanya On Fri, Apr 9, 2010 at 8:20 PM, Stephen Sunderlin <stephen.sunderlin@verizon.net <mailto:stephen.sunderlin@verizon.net>> wrote:

    Set that to 6oo. Stopped after 125 loops in under a minute.

    _____________________________
    Stephen Sunderlin
    2162 Broadway, 4th Fl.
    New  York, NY 10024
    (212) 799-3753

    -----Original Message-----
    From: Chaitanya Yanamadala <dr.virus.india@gmail.com
    <mailto:dr.virus.india@gmail.com>>
    Date: Fri, 09 Apr 2010 19:26:22
    Cc: <php-db@lists.php.net <mailto:php-db@lists.php.net>>
    Subject: Re: [PHP-DB] mysql/php time out issue

    have u checked max_execution_time

    Chaitanya

    On Fri, Apr 9, 2010 at 7:17 PM, Stephen Sunderlin <
    stephen.sunderlin@verizon.net
    <mailto:stephen.sunderlin@verizon.net>> wrote:

I'm running php 5.1.6 with mysql 5.0.45 on CentOS 5.3 box

    trying to loop

through a while statement to send about 3000 email using

    phpmailer.  It's

worked well in the past but after an upgrade it seems to be

    timing out now

after 200-300 emails over 1 minute or two. I've added

    set_time_limit(30)

within the while loop to reset the time out. I've added a sleep(1) statement to throttle the program (I've tried sending with and

    without these

additions). I've altered several config files to see if it

    would send to

completion to no avail: mysql.connect_timeout = -1 memory_limit = 100M max_input_time = 60 max_input_time = 600 max_input_time = 0 and the following mysql config: key_buffer = 256M max_allowed_packet = 50M table_cache = 1024 sort_buffer_size = 1M read_buffer_size = 1M read_rnd_buffer_size = 4M myisam_sort_buffer_size = 64M thread_cache_size = 64 tmp_table_size = 40M join_buffer_size = 1M query_cache_limit = 12M query_cache_size= 32M query_cache_type = 1 max_connections = 60 thread_stack = 128K thread_concurrency = 4 Any where else I should be looking. Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php