One of my client website has very large database booking system. Currently my server need more than 2 minute to load all the bookings from many years. I’ve tried to change the setting in my PHP & Apache. It doesnt work. However it was my fault, because VestaCP is using Nginx as proxy.
So I have to change in PHP and also in Nginx configuration.
You have to change some setting in /etc/nginx/nginx.conf
large_client_header_buffers 4 8k;
keepalive_timeout 120 120;
# Proxy settings
proxy_set_header Host $host;
proxy_set_header X-Real-IP $remote_addr;
proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
proxy_buffers 32 4k;
You just change the value in this parameter to fit with your situation and don’t forget to change also in your php configuration setting. ( /home/user/domain/conf/web/apache.conf )