As you said, this issue is often generated by a lack of space in the temporal directory of mysql. Due to this, mysql can perform the
ALTER TABLE as it has 2 copes of that table in the temporal directory.
The solution for this would be to increase the size of the persistent disk of your instance or attach a new volume and point to that volume the temporal directory of mysql.
If you didn't change anything related to the mysql configuration (the config file is in
/opt/bitnami/mysql/my.cnf) it should point the temporal directory to
So, you can follow this guide of Google to resize the disk you have attached to your instance or mount another disk.
If you follow the second option (mount another disk) do not forget to follow these steps:
- Stop mysql and the services with:
sudo /opt/bitnami/ctlscript.sh stop
- Perform the desired changes in the
- Start again the services with
sudo /opt/bitnami/ctlscript.sh start
I hope this information is useful for you.
Thank you and best regards,
Was my answer helpful? Click on