MySQL server has gone away和Maximum execution time of 120 seconds exceeded

標籤：php   code   exe   strong   pac   cut   mysq   程式   seconds   

今天在寫採集時碰到兩個問題
1、MySQL server has gone away
2、Maximum execution time of 120 seconds exceeded

採集程式寫好運行大概一分鐘後出現MySQL server has gone away，發現mysql裡面的max_allowed_packet = 1M，這裡改成了10M，運行兩分鐘後出現Maximum execution time of 120 seconds exceeded，這裡是因為php.ini裡設定了max_execution_time=120，把這裡的120改成0就是永不到期。運行沒有再出問題

MySQL server has gone away和Maximum execution time of 120 seconds exceeded