CODEWITHSUNDEEP
mysqlsqlmariadb
Yurii Kosiak
Yurii Kosiak

Reputation: 410

MariaDB creates unnecessary temp files after upload data into table

MariaDB version 10.3.

MariaDB creates unnecessary temp files like "0.00000n" while I upload huge file to database. How to automatically remove these files or not add to folder at all?

enter image description here

With MySQL 5.7 the same operations worked fine.

Upvotes: 0

Views: 615

Answers (2)

Yurii Kosiak
Yurii Kosiak

Reputation: 410

I hope this answer will help someone to save time. It's not easy to find answer by standard requests like "MariaDB creates huge temp files|MariaDB temp zero files" etc.

Just comment the line in MariaDB settings to disable binary logging:

#log-bin = mysql-bin

More detail there: https://dba.stackexchange.com/questions/45474/huge-0-000001-and-0-000002-files-and-so-on-in-mysql-data-folder

Upvotes: 0

Georg Richter
Georg Richter

Reputation: 7516

These files aren't temporary files and they aren't unnecessary. These are binary logs which are used for replication (but also can be used for data recovery).

The filename 0 indicates, that you tried to disable this option in your configuration file by specifying log-bin=0. This doesn't disable the option but uses the filename 0.* instead.

To disable this option remove this entry (or add a comment in front of it).

Upvotes: 1

Related Questions