Mysql error : Can’t create new tempfile: *.TMD file
Got the following error while trying to repair a crashed DB: [crayon-5a2e79c934a02615560198/] You need to…
I recently experienced this error on a DigitalOcean node with 512MB ram. The full error below:
The log had the following errors logged
Turns out the VPS did not have enough RAM to allocate to the InnoDB plugin.
One fix is to disable InnoDB, because this was a test node and I really didn’t need InnoDB I was able to disable it by adding the following to my.cnf