15,017
edits
Troubleshooting of PHP errors: Difference between revisions
Jump to navigation
Jump to search
m
→錯誤訊息: Allowed memory size of XXX bytes exhausted (out of memory)
| Line 116: | Line 116: | ||
** 增加 memory_limit<ref>[http://blog.xuite.net/chingwei/blog/30054402-%E3%80%90%E7%B3%BB%E7%B5%B1%E3%80%91PHP+-+Fatal+error%3A+Allowed+memory+size+of+xxx+bytes+exhausted 【系統】PHP - Fatal error: Allowed memory size of xxx bytes exhausted @ My Life :: 隨意窩 Xuite日誌] </ref> | ** 增加 memory_limit<ref>[http://blog.xuite.net/chingwei/blog/30054402-%E3%80%90%E7%B3%BB%E7%B5%B1%E3%80%91PHP+-+Fatal+error%3A+Allowed+memory+size+of+xxx+bytes+exhausted 【系統】PHP - Fatal error: Allowed memory size of xxx bytes exhausted @ My Life :: 隨意窩 Xuite日誌] </ref> | ||
** 跟檔案處理有關: (1) 減少每次讀取的資料行數，例如每次只讀取 50 行的資料筆數來做處理。 (2) 避免使用一次讀取全部檔案內容的 [http://php.net/manual/en/function.file-get-contents.php file_get_contents]、[http://php.net/manual/en/function.file-put-contents.php file_put_contents]等函數、 (3) 如果透過 MySQL 執行匯出資料表的 CSV 檔案，則可以不要選擇欄位名稱，而是選擇全部欄位直接匯出。原因:「Rather than attempting to build the object-tree, you could directly try to select the result into a file」<ref>[https://stackoverflow.com/questions/31471186/how-to-export-millions-of-rows-from-mysql-to-csv-via-php-without-exhausting-memo How to export millions of rows from MySQL to CSV via PHP without exhausting memory? - Stack Overflow]</ref> | ** 跟檔案處理有關: (1) 減少每次讀取的資料行數，例如每次只讀取 50 行的資料筆數來做處理。 (2) 避免使用一次讀取全部檔案內容的 [http://php.net/manual/en/function.file-get-contents.php file_get_contents]、[http://php.net/manual/en/function.file-put-contents.php file_put_contents]等函數、 (3) 如果透過 MySQL 執行匯出資料表的 CSV 檔案，則可以不要選擇欄位名稱，而是選擇全部欄位直接匯出。原因:「Rather than attempting to build the object-tree, you could directly try to select the result into a file」<ref>[https://stackoverflow.com/questions/31471186/how-to-export-millions-of-rows-from-mysql-to-csv-via-php-without-exhausting-memo How to export millions of rows from MySQL to CSV via PHP without exhausting memory? - Stack Overflow]</ref> | ||
** [http://php.net/manual/en/control-structures.foreach.php foreach] 時，與其寫入整個陣列到記憶體，可以改用 | ** [http://php.net/manual/en/control-structures.foreach.php foreach] 時，與其寫入整個陣列到記憶體，可以改用 [http://php.net/manual/en/language.generators.overview.php Generators] 或 [http://php.net/manual/en/function.fgets.php fgets] 寫法，節省記憶體的使用。 | ||
=== 錯誤訊息: It is not safe to rely on the system's timezone settings === | === 錯誤訊息: It is not safe to rely on the system's timezone settings === | ||