[PHP-DB] phpmailer/mysql/ timout issues
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 severals config files to see if it would send to completion to no avail: mysql.connect_timeout = -1 max_execution_time = 600 max_input_time = 600 memory_limit = 100M 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
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_tagsOff Off auto_append_file/no value/ /no value/ auto_globals_jitOn On auto_prepend_file /no value/ /no value/ browscap/no value/ /no value/ 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 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 20472047 expose_php On On file_uploadsOn On 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 log_errors On On log_errors_max_len 10241024 magic_quotes_gpcOn On magic_quotes_runtimeOff Off magic_quotes_sybase Off Off mail.force_extra_parameters /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_buffering40964096 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_globalsOn On register_long_arraysOn 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 SMTPlocalhost localhost smtp_port 25 25 sql.safe_mode Off Off track_errorsOff 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 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
[PHP-DB] include_path in appache.conf
This may be an apache question but I'd like to find the php answer first if one exists. I have several virtual hosts on a dedicated server. In a IFmodule mod_php5c container in an httpd.conf include file I have the following to create a unique include path for each virtual host: IfModule mod_php5.c php_value include_path .:/home/virtual/site#/path/to/include php_admin_flag safe_mode off /IfModule For one of the virtual hosts I've set up a dev site in a subdomain at dev.site#.com for development. In the root directory of this development site I have an .htacces file to create another unique include_path solely for this development subdomain. php_value include_path .:/home/virtual/site#/path/to/dev/includes Also in the httpd.conf I have Directory /home/virtual/site#/path/to/dev/root/ Allow from all AllowOverride All Order allow,deny /Directory The configuration is CentOS 5.3, Apache/2.2.3, PHP 5.1.6 I recently upgraded the OS from FC6 and the PHP version and I have not been able to get the include_path to change for this dev.subdomain. Even after restarting apache it PHPinfo tells me it is reading the server php.ini and the virtual host include path for the httpd.conf but it is ignoring the .htaccess file. I've even tried putting the php.ini with specific settings in the /home/virtual/site#/root directory to no avail. Any ideas how to make this work or even a better set up? Thanks in advance. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] include_path in appache.conf
Thanks Niel. Niel Archer wrote: Try asking on the general list. This is not Db related at all, so your chances of getting answers here are pretty slim. This may be an apache question but I'd like to find the php answer first if one exists. I have several virtual hosts on a dedicated server. In a IFmodule mod_php5c container in an httpd.conf include file I have the following to create a unique include path for each virtual host: IfModule mod_php5.c php_value include_path .:/home/virtual/site#/path/to/include php_admin_flag safe_mode off /IfModule For one of the virtual hosts I've set up a dev site in a subdomain at dev.site#.com for development. In the root directory of this development site I have an .htacces file to create another unique include_path solely for this development subdomain. php_value include_path .:/home/virtual/site#/path/to/dev/includes Also in the httpd.conf I have Directory /home/virtual/site#/path/to/dev/root/ Allow from all AllowOverride All Order allow,deny /Directory The configuration is CentOS 5.3, Apache/2.2.3, PHP 5.1.6 I recently upgraded the OS from FC6 and the PHP version and I have not been able to get the include_path to change for this dev.subdomain. Even after restarting apache it PHPinfo tells me it is reading the server php.ini and the virtual host include path for the httpd.conf but it is ignoring the .htaccess file. I've even tried putting the php.ini with specific settings in the /home/virtual/site#/root directory to no avail. Any ideas how to make this work or even a better set up? Thanks in advance. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Niel Archer niel.archer (at) blueyonder.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php