fastcgi超时

upstream timed out (110: Connection timed out) while reading response header from upstream

帮朋友网站搬家,但是数据库导入很慢,经常超时,才找到这个的解决办法

nginx默认fastcgi的超时时间是六十秒,找了好久才找到原因

location ~ \.php$ {
root /data/bbs;
fastcgi_pass 127.0.0.1:9000;
fastcgi_read_timeout 1800;
fastcgi_index index.php;
fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
include fastcgi_params;
}