[PHP-DB] 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: [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.sunder...@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
Re: [PHP-DB] mysql/php time out issue
these are the entire core values of mine try making a replica of the required.. i am able to send for 3 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.outputamp;amp; 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#FF#FF highlight.comment#FF8000#FF8000 highlight.default #BB#BB highlight.html#00#00 highlight.keyword#007700#007700 highlight.string#DD#DD 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.sunder...@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.in...@gmail.com Date: Fri, 09 Apr 2010 19:26:22 To: Stephen Sunderlinstephen.sunder...@verizon.net Cc: 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.sunder...@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
Re: [PHP-DB] mysql/php time out issue
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 3 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.outputamp; amp; asp_tagsOff Off auto_append_file/no value/ /no value/ auto_globals_jitOn 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_mimetypetext/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\extC:\xampp\php\ext file_uploadsOn On highlight.bg http://highlight.bg#FF #FF highlight.comment #FF8000 #FF8000 highlight.default #BB #BB highlight.html #00 #00 highlight.keyword #007700 #007700 highlight.string#DD #DD 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 10241024 magic_quotes_gpcOn On magic_quotes_runtimeOff 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 60006000 max_input_nesting_level 64 64 max_input_time 600 600 memory_limit128M128M open_basedir/no value/ /no value/ output_buffering/no value/ /no value/ output_handler /no value/ /no value/ post_max_size 128M128M precision 14 14 realpath_cache_size 16K 16K realpath_cache_ttl 120 120 register_argc_argv On On register_globalsOff Off register_long_arraysOff 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_errorsOff Off unserialize_callback_func /no value/ /no value/ upload_max_filesize 128M128M upload_tmp_dir C:\xampp\tmpC:\xampp\tmp user_dir/no value/ /no value/ user_ini.cache_ttl 300 300 user_ini.filename .user.ini .user.ini variables_order GPCSGPCS 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.sunder...@verizon.net mailto:stephen.sunder...@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.in...@gmail.com mailto:dr.virus.in...@gmail.com Date: Fri, 09 Apr 2010 19:26:22 To: Stephen Sunderlinstephen.sunder...@verizon.net mailto:stephen.sunder...@verizon.net 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.sunder...@verizon.net mailto:stephen.sunder...@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
Re: [PHP-DB] mysql/php time out issue
expose_php On On extension_dir C:\xampp\php\extC:\xampp\php\ext file_uploadsOn On highlight.bg http://highlight.bg#FF #FF highlight.comment #FF8000 #FF8000 highlight.default #BB #BB highlight.html #00 #00 highlight.keyword #007700 #007700 highlight.string#DD #DD 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 10241024 magic_quotes_gpcOn On magic_quotes_runtimeOff 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 60006000 max_input_nesting_level 64 64 max_input_time 600 600 memory_limit128M128M open_basedir/no value/ /no value/ output_buffering/no value/ /no value/ output_handler /no value/ /no value/ post_max_size 128M128M precision 14 14 realpath_cache_size 16K 16K realpath_cache_ttl 120 120 register_argc_argv On On register_globalsOff Off register_long_arraysOff 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_errorsOff Off unserialize_callback_func /no value/ /no value/ upload_max_filesize 128M128M upload_tmp_dir C:\xampp\tmpC:\xampp\tmp user_dir/no value/ /no value/ user_ini.cache_ttl 300 300 user_ini.filename .user.ini .user.ini variables_order GPCSGPCS 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.sunder...@verizon.net mailto:stephen.sunder...@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.in...@gmail.com mailto:dr.virus.in...@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.sunder...@verizon.net mailto:stephen.sunder...@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