I was asked to help troubleshoot a site. It is written in php, in a Linux box, using the apache server and mysql, and I have never worked with them before (except maybe Linux at school).
I have fixed most of the fixes (most of the codes are really the same no matter what it is), however there is another page that will take time to process huge files. I am sure the problem is that the timeout is somewhere, but I don't know where all the php timeouts will be.
I adjusted max_execution_time, max_input_time, mysql.connect_timeout, default_socket_timeout and realpath_cache_ttl in php.ini, but it still disconnects after 10 minutes. What other settings are there that I could increase to fix this?
As an alert, I know that 10min is usually not advisable when processing a file, however this section of the site is used only by one person once or twice a week, and she does not mind completing the process as expected! and I really don't want to rewrite someone with bad coding in a language that I don’t understand, for a process that I don’t understand)
EDIT: The sql process ends in the background, namely the web page itself, from time to time.
source
share