MariaDB filling up /tmp folder

J

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

cPanelLauren

Product Owner II
Staff member
Nov 14, 2017
13,274
1,291
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.
 
You must log in or register to reply here.
Thread starter Similar threads Forum Replies Date
E How to customize the version of MySQL or MariaDB used when installing cPanel for the first time Databases 2
C Major Issues Lately with MariaDB Upgrades and Updates via WHM Databases 27
grayloon Move MariaDB Databases 3
S Is a mixture of both MyISAM and InnoDB table types on the same MariaDB 10.3 database 'bad'? Databases 2
gdimi In Progress CPANEL-40434 - Cannot upgrade mariadb 10.0 to 10.1, repo is not found Databases 11
Similar threads
How to customize the version of MySQL or MariaDB used when installing cPanel for the first time
Major Issues Lately with MariaDB Upgrades and Updates via WHM
Move MariaDB
Is a mixture of both MyISAM and InnoDB table types on the same MariaDB 10.3 database 'bad'?
In Progress CPANEL-40434 - Cannot upgrade mariadb 10.0 to 10.1, repo is not found
Top Bottom