Re: mysql/php time out issue

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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_referenceOnOn allow_url_fopenOnOn allow_url_includeOnOn
always_populate_raw_post_dataOffOff arg_separator.input&&
arg_separator.output&& asp_tagsOffOff auto_append_file*no value**no
value* auto_globals_jitOnOn auto_prepend_file*no value**no value* browscap
C:\xampp\php\extras\browscap.iniC:\xampp\php\extras\browscap.ini
default_charset*no value**no value* default_mimetypetext/htmltext/html
define_syslog_variablesOffOff disable_classes*no value**no value*
disable_functions*no value**no value* display_errorsOnOn
display_startup_errorsOnOn doc_root*no value**no value* docref_ext*no value*
*no value* docref_root*no value**no value* enable_dlOnOn error_append_string
*no value**no value* error_log*no value**no value* error_prepend_string*no
value**no value* error_reporting2251922519 exit_on_timeoutOffOff expose_php
OnOn extension_dirC:\xampp\php\extC:\xampp\php\ext file_uploadsOnOn
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_errorsOnOn ignore_repeated_errorsOffOff
ignore_repeated_sourceOffOff ignore_user_abortOffOff implicit_flushOffOff
include_path.;C:\xampp\php\PEAR.;C:\xampp\php\PEAR log_errorsOffOff
log_errors_max_len10241024 magic_quotes_gpcOnOn magic_quotes_runtimeOffOff
magic_quotes_sybaseOffOff mail.add_x_headerOffOff
mail.force_extra_parameters*no value**no value* mail.log*no value**no value*
max_execution_time60006000 max_input_nesting_level6464 max_input_time600600
memory_limit128M128M open_basedir*no value**no value* output_buffering*no
value**no value* output_handler*no value**no value* post_max_size128M128M
precision1414 realpath_cache_size16K16K realpath_cache_ttl120120
register_argc_argvOnOn register_globalsOffOff register_long_arraysOffOff
report_memleaksOnOn report_zend_debugOnOn request_order*no value**no value*
safe_modeOffOff safe_mode_exec_dir*no value**no value* safe_mode_gidOffOff
safe_mode_include_dir*no value**no value* sendmail_from*no value**no value*
sendmail_path*no value**no value* serialize_precision100100 short_open_tagOn
On


smtp_port2525 sql.safe_modeOffOff track_errorsOffOff
unserialize_callback_func*no value**no value* upload_max_filesize128M128M
upload_tmp_dirC:\xampp\tmpC:\xampp\tmp user_dir*no value**no value*
user_ini.cache_ttl300300 user_ini.filename.user.ini.user.ini variables_order
GPCSGPCS xmlrpc_error_number00 xmlrpc_errorsOffOff y2k_complianceOnOn
zend.enable_gcOnOn

Chaitanya



On Fri, Apr 9, 2010 at 8:20 PM, Stephen Sunderlin <
stephen.sunderlin@xxxxxxxxxxx> 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@xxxxxxxxx>
> Date: Fri, 09 Apr 2010 19:26:22
> To: Stephen Sunderlin<stephen.sunderlin@xxxxxxxxxxx>
> Cc: <php-db@xxxxxxxxxxxxx>
> Subject: Re:  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@xxxxxxxxxxx> 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
> >
> >
>
>

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux