Comments - mysqld fills /tmp with file /tmp/#sql_26be_0.MAD

6 years, 11 months ago Jamie G


When you run certain ALTER or CREATE commands on an InnoDB table, a temporary table is created in mysql's tmpdir during the operation.The default value in my.cnf is /tmp.

When you are loading the data, /tmp is being filled. I would suggest you change the value of tmpdir in my.cnf to be on a disk with more space. Stop mysql first, change the value in my.cnf and start mysql.

Check the tmpdir value is correct by running:

show variables like "tmpdir";

then try loading your data.

If the value is not as you set it in my.cnf, make sure you have it in the correct section, [mysqld] or [mysqld-safe]

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.