Disk full (/tmp/#sql_1a2838_1.MAI); waiting for someone to free some space

I get this message every morning,

Error: Disk full (/tmp/#sql_1a2838_1.MAI); waiting for someone to free some space… (errno: 28 “No space left on device”)

and then I have to restart MariaDB from the site.com:8090/serverstatus/services

screenshot of df -h command:

Filesystem Size Used Avail Use% Mounted on
udev 15G 0 15G 0% /dev
tmpfs 3.0G 692K 3.0G 1% /run
/dev/sda3 194G 21G 164G 11% /
tmpfs 15G 108M 15G 1% /dev/shm
tmpfs 5.0M 0 5.0M 0% /run/lock
tmpfs 15G 0 15G 0% /sys/fs/cgroup
/dev/loop0 1.5G 1.4G 0 100% /tmp
/dev/sda2 2.0G 144M 1.7G 8% /boot
tmpfs 3.0G 0 3.0G 0% /run/user/0

also I was changed Swapping Directory value in OpenLiteSpeed panel to :
Swapping Directory /dev/shm

but still have same problem and every morning /tmp folder is full

OS:Ubuntu 20.4
Panel: Cyberpanel 2.1.1 + Openlitespeed 1.7.14

my VPS:
8 vCPU Cores
200 GB NVMe

What kind of application you are hosting? Your /tmp me be made up of temporary session files from your web application?

@usmannasir Joomla4

also I changed /tmp to /dev/shm in openlitespeed panel :please see this image: Imgur: The magic of the Internet

Increase the size of /tmp

@usmannasir how can do it? I used Ubuntu 20.4
so thank you

Thats a basic linux skill, you can google it.


Please have a look to this thread. It might be helpful: Click here :link:

I also had same problem, After several studies I have found this is happening because of gzip compression.

After that I’have turned off gzip compression using OpenLiteSpeed dashboard. Issue will be fix.

Use cloudflare for gzip compression (bolti).

I forgot openlitespeed admin access

How can i get back?