首页 > 代码库 > MySQL server has gone away和Maximum execution time of 120 seconds exceeded

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就是永不过期。运行没有再出问题

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