[Skidy]

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:


Does anyyone have any ideas?

---

This is my error log

---

Something to do with InnoDB: Cannot allocate memory for the buffer pool?

---

https://stackoverflow.com/questions/2596...l/32932601

It would appear mySQL is out of memory? I have a 20GB ssd. How is this possible?

---

http://www.webtrafficexchange.com/solved...uffer-pool

Make sure you change 512M to 512K.

Fixed.

[Quad]

It would appear mySQL is out of memory? I have a 20GB ssd. How is this possible?

Memory = RAM
Storage = SSD

[Skidy]

Memory = RAM
Storage = SSD

Yeah at first I thought it was storage, then I realised it was RAM.

[CryptoJeeb]

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