Current location - Health Preservation Learning Network - Healthy weight loss - Why is mysql temporary tablespace full?
Why is mysql temporary tablespace full?
Mysql temporary tablespace is full for the following reasons.

1. According to official website's documentation, the temporary tablespace will be deleted when the initialization stops or it is shut down normally, and it will be recreated every time the server is started. Restart can free up space because the database is shut down normally, and the temporary tablespace will be deleted and re-created after restart, that is, restart will lead to the reconstruction and re-initialization of the temporary tablespace, so the reconstructed size is 12M.

2. Limit the size of temporary table space, allowing automatic growth, but the maximum capacity has an upper limit.