Hello I wrote a PHP script to inport a CSV file and run SQL updates for each lines. With a few lines the script works fine but for a 10000 lines CSV I get systematically a Gateway Timeout The gateway did not receive a timely response from the upstream server or application. Each time out occurs precisely at 300 seconds (in the browser network console) Currently I have the following PHP settings : date.timezone = Europe/Paris max_execution_time = 7200 max_input_time = 3000 memory_limit = 1024M post_max_size = 250M upload_max_filesize = 250M max_input_vars = 16000 request_terminate_timeout = 0 session.auto_start = Off magic_quotes_gpc = off short_open_tag = Off On MariaDB when I search for 300 seconds values I get : MariaDB [(none)]> show variables where VALUE like '300'; +------------------------------+-------+ | Variable_name | Value | +------------------------------+-------+ | aria_pagecache_age_threshold | 300 | | delayed_insert_timeout | 300 | | innodb_purge_batch_size | 300 | | key_cache_age_threshold | 300 | +------------------------------+-------+ 4 rows in set (0.003 sec) My database is located on a remote server. I don't know exactly the value(s) I'd need to change... Any idea ?
thank you for your reply I added default_socket_timeout = 7200 in ISPC website options, no changes., 504 timeout at 5 minutes
