MariaDB filling up /tmp folder

Jahn

Registered
Aug 31, 2018
4
0
1
Chennai
cPanel Access Level
Root Administrator
I have a large forum database with 3 million posts. It was on a VPS that used MySQL and I didn't have any problems. Recently I moved it to a VPS that has MariaDB pre installed. Immediately I am noticing a couple times a day the /tmp folder (which is 4GB) is becoming filled 100% (causing the server to fail) when ever someone does forum searches.

1) Is it possible to specify an alternate /tmp folder for MariaDB?

2) Could this be avoided by providing more RAM to MariaDB so that it didn't have to write to the /tmp folder?
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,296
1,252
313
Houston
What I would suggest before doing anything is running something like MySQL Tuner - it's likely your old server had configuration changes done to MySQL to optimize performance. In fact if you still have the file at /etc/my.cnf it's likely that can be transitioned to the new server as well.