+- Hack Forums (https://hackforums.net)
+-- Forum: Tech (https://hackforums.net/forumdisplay.php?fid=444)
+--- Forum: Coding (https://hackforums.net/forumdisplay.php?fid=151)
+---- Forum: Web Development (https://hackforums.net/forumdisplay.php?fid=183)
+---- Thread: [PHP] MySQL - Killed my MySQL? (/showthread.php?tid=5768765)
MySQL - Killed my MySQL? - Skidy - Dec 15, 2017
So, I added 10,000 results to my remote SQL server, and it just caused it to break. I reinstalled everything and it works but AS SOON as I enter the 10,000 records mySQL server crashes and I can't restart it.
the error:
![[Image: af9c0a2fc31a26d783c3852b4a8701ff.png]](https://i.gyazo.com/af9c0a2fc31a26d783c3852b4a8701ff.png)
Does anyyone have any ideas?
![[Image: 4105f3b73d404e57c9585b9a4d2053c4.png]](https://i.gyazo.com/4105f3b73d404e57c9585b9a4d2053c4.png)
This is my error log
Something to do with InnoDB: Cannot allocate memory for the buffer pool?
https://stackoverflow.com/questions/25965638/mysql-fatal-error-cannot-allocate-memory-for-the-buffer-pool/32932601
It would appear mySQL is out of memory? I have a 20GB ssd. How is this possible?
http://www.webtrafficexchange.com/solved-mysql-crash-fatal-error-cannot-allocate-memory-buffer-pool
Make sure you change 512M to 512K.
Fixed.
RE: MySQL - Killed my MySQL? - Quad - Dec 16, 2017
(Dec 15, 2017 07:08 AM)Skidy Wrote: It would appear mySQL is out of memory? I have a 20GB ssd. How is this possible?
Memory = RAM
Storage = SSD
RE: MySQL - Killed my MySQL? - Skidy - Dec 16, 2017
(Dec 16, 2017 04:40 AM)Quad Wrote: Memory = RAMYeah at first I thought it was storage, then I realised it was RAM.
Storage = SSD
RE: MySQL - Killed my MySQL? - CryptoJeeb - Dec 17, 2017
Your setup can't handle the size of the file you're uploading - break it up into smaller chunks (e.g. 2k records at a time) and try that way