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

今天在写采集时碰到两个问题
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就是永不过期。运行没有再出问题