Problem description
RDS MySQL 8.0 "/tmp/#sql1a324 _1 f4 a_8b' is full" error occurs.
Solution
Alibaba Cloud reminds you that:
- Before you perform operations that may cause risks, such as modifying instance configurations or data, we recommend that you check the disaster recovery and fault tolerance capabilities of the instances to ensure data security.
- You can modify the configurations and data of instances including but not limited to Elastic Compute Service (ECS) and Relational Database Service (RDS) instances. Before the modification, we recommend that you create snapshots or enable RDS log backup.
- If you have authorized or submitted sensitive information such as the logon account and password in the Alibaba Cloud Management Console, we recommend that you modify such information in a timely manner.
The storage engine used by the RDS MySQL 8.0 temporary disk table is templateparable or MEMORY, which is determined by the internal_tmp_mem_storage_engine parameter, for more information, see MySQL official website.
Note: you can run the
SHOW GLOBAL VARIABLES LIKE 'internal_tmp_mem_storage_engine'statement on the database to check whether the parameter value is based on MEMORY. If the parameter value is, no modification is required.
- If this error occurs, you need to set the value of internal_tmp_mem_storage_engine to the MEMORY engine. For more information, see modify parameters to enable the MEMORY engine.
- If the memory size is small, we recommend that you use the templategroup engine. You can increase the value of the temptable_max_ram parameter. This parameter specifies the available memory size for the maximum temporary disk table.
Application scope
- ApsaraDB RDS for MySQL