mysql/php time out issue

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

Re: mysql/php time out issue

--0016363b806c467b850483ce2aa9
Content-Type: text/plain; charset=UTF-8

have u checked max_execution_time


Chaitanya



On Fri, Apr 9, 2010 at 7:17 PM, Stephen Sunderlin <
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
>
>

--0016363b806c467b850483ce2aa9--

Re: mysql/php time out issue

--00163630f1618923c90483cf0696
Content-Type: text/plain; charset=UTF-8

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@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
> Date: Fri, 09 Apr 2010 19:26:22
> To: Stephen Sunderlin
> Cc:
> 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> 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
> >
> >
>
>

--00163630f1618923c90483cf0696--

Re: mysql/php time out issue

--Boundary_(ID_oIQSYBk2PfMl/yt04LWDpw)
Content-type: text/plain; CHARSET=US-ASCII; format=flowed
Content-transfer-encoding: 7BIT

Thanks Chaitanya.

I've tried both Sendmail and SMTP.

I'll let you know how this works out.

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 & &
> 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 #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
> >
> 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 > >
> Date: Fri, 09 Apr 2010 19:26:22
> To: Stephen Sunderlin > >
> Cc: >
> 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
> > 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
> >
> >
>
>


--
*Stephen Sunderlin*
Artistic Director
Vital Theatre Company
2162 Broadway, 4th Floor
New York, NY 10024

Web: vitaltheatre.org
Email: ad@vitaltheatre.org
Phone: (212) 579-0528
Fax: (212) 578-0646
Cell: (212) 799-3753
logo

--Boundary_(ID_oIQSYBk2PfMl/yt04LWDpw)
Content-type: multipart/related; boundary="Boundary_(ID_4MvKGsA1iEUjjvND23DtFQ)"


--Boundary_(ID_4MvKGsA1iEUjjvND23DtFQ)
Content-type: text/html; charset=UTF-8
Content-transfer-encoding: 8BIT







Thanks Chaitanya.



I've tried both Sendmail and SMTP.



I'll let you know how this works out.



On 4/9/2010 10:57 AM, Chaitanya Yanamadala wrote:
cite="mid:n2u6e124171004090757mc6ea2643h839ff4df762c9584@mai l.gmail.com"
type="cite">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..

--

Stephen Sunderlin


Artistic Director


Vital Theatre Company


2162 Broadway, 4th Floor


New York, NY 10024




Web:


Email:


Phone: (212) 579-0528


Fax: (212) 578-0646


Cell: (212) 799-3753


src="cid:part1.05030407.04080907@verizon.net" alt="logo">

Re: mysql/php time out issue

--Boundary_(ID_CIGFddDVFsurYV3ARLHkTQ)
Content-type: text/plain; CHARSET=US-ASCII; format=flowed
Content-transfer-encoding: 7BIT

Thanks Chaitanya.

I've tried both Sendmail and SMTP.

I'll let you know how this works out.

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 & &
> 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 #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
> >
> 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 > >
> Date: Fri, 09 Apr 2010 19:26:22
> To: Stephen Sunderlin > >
> Cc: >
> 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
> > 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
> >
> >
>
>


--Boundary_(ID_CIGFddDVFsurYV3ARLHkTQ)--

Re: mysql/php time out issue

--Boundary_(ID_lBQUBIzJJEWVExtjU2K1Pw)
Content-type: text/plain; CHARSET=US-ASCII; format=flowed
Content-transfer-encoding: 7BIT

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 & &
> 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 #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
> >
> 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 > >
> Date: Fri, 09 Apr 2010 19:26:22
> Cc: >
> 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
> > 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
> >
> >
>
>


--Boundary_(ID_lBQUBIzJJEWVExtjU2K1Pw)--