how to increase directadmin tmp

[DutchProgrammer]

Hi,

Im running centos 7 with the latest directadmin version and today i get the following error message in mysql:
Disk full (/tmp/#sql_40e9_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

when i check my partitions i only see 1G for /tmp
/dev/mapper/vg_directadmin-lv_tmp 1014M 1014M 20K 100% /tmp

How can i increase this ?

Thanks for helping.

Danny

 

[Richard G]

You can also create another /tmp for directadmin for example in / that's how I do it.

I just create a directory called da_temp, chmod to 777.
Then in directadmin.conf change the tmpdir value to
tmpdir=../../../da_temp
restart directadmin and you should be fine. You can also choose another place where you have enough space.

 

[zEitEr]

Hello,

Disk full (/tmp/#sql_40e9_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

That's related to MySQL. To avoid such errors you can try either:

1. Increase the value of tmp_table_size and max_heap_table_size (MySQL/MariaDB), or
2. Change tmpdir - the directory used for temporary files and temporary tables (MySQL/MariaDB), or
3. Increase size of /tmp (System).

 

[DutchProgrammer]

The tmp dir is ../../../home/tmp and is empty so i dont think this will fix the problem

You can also create another /tmp for directadmin for example in / that's how I do it.

I just create a directory called da_temp, chmod to 777.
Then in directadmin.conf change the tmpdir value to
tmpdir=../../../da_temp
restart directadmin and you should be fine. You can also choose another place where you have enough space.

 

[DutchProgrammer]

I think option 3 is the only option

because it's not only mysql

when i type a few chars of a dir or file and press tab i get the following error:
bash: cannot create temp file for here-document: No space left on device

How can i increase my tmp partition ?

Hello,



That's related to MySQL. To avoid such errors you can try either:

1. Increase the value of tmp_table_size and max_heap_table_size (MySQL/MariaDB), or
2. Change tmpdir - the directory used for temporary files and temporary tables (MySQL/MariaDB), or
3. Increase size of /tmp (System).

 

[zEitEr]

Did you investigate what fills the /tmp partition? Even if you increase /tmp x2 - x4 times you might still have the issue.

You can increase it one of the following ways:

1. Extending a logical volume
2. Mount a new /tmp as tmpfs
3. Mount a new /tmp as partition file

 

[DutchProgrammer]

Yeah im building larges tables.
I got 1 mysql table with 13milion rows and another one was building up (is 100k and still increasing)


I've tried option1:
https://www.centos.org/docs/5/html/Cluster_Logical_Volume_Manager/lv_extend.html

This gives the following error:
lvextend -L+4G /dev/vg_directadmin/lv_tmp
Insufficient free space: 1024 extents needed, but only 0 available

----------------
lvdisplay
--- Logical volume ---
LV Path /dev/vg_directadmin/swap
LV Name swap
VG Name vg_directadmin
LV UUID qD1ib9-TAqx-gkKb-9ybC-Jg7g-653o-dDehoj
LV Write Access read/write
LV Creation host, time localhost.localdomain, 2015-07-08 15:02:22 +0200
LV Status available
# open 2
LV Size 1,00 GiB
Current LE 256
Segments 1
Allocation inherit
Read ahead sectors auto
- currently set to 8192
Block device 253:1

--- Logical volume ---
LV Path /dev/vg_directadmin/lv_tmp
LV Name lv_tmp
VG Name vg_directadmin
LV UUID ezqLis-CBQt-IiZK-7BjX-gvf5-b476-xxlkTe
LV Write Access read/write
LV Creation host, time localhost.localdomain, 2015-07-08 15:02:22 +0200
LV Status available
# open 1
LV Size 1,00 GiB
Current LE 256
Segments 1
Allocation inherit
Read ahead sectors auto
- currently set to 8192
Block device 253:2

--- Logical volume ---
LV Path /dev/vg_directadmin/lv_root
LV Name lv_root
VG Name vg_directadmin
LV UUID FfvRs5-bQav-72te-GxcF-wlan-hWoT-Ir3I36
LV Write Access read/write
LV Creation host, time localhost.localdomain, 2015-07-08 15:02:23 +0200
LV Status available
# open 1
LV Size 297,51 GiB
Current LE 76162
Segments 1
Allocation inherit
Read ahead sectors auto
- currently set to 8192
Block device 253:0
------------------------------

The vps is an preinstalled directadmin image from my hoster, it looks like every space is already in space so maybe i have to decrease /dev/vg_directadmin/lv_root to add +4G to /dev/vg_directadmin/lv_tmp ?

I just rebooted my VPS in the hope it will be fixed but now it only starts in emergency mode

Did you investigate what fills the /tmp partition? Even if you increase /tmp x2 - x4 times you might still have the issue.

You can increase it one of the following ways:

1. Extending a logical volume
2. Mount a new /tmp as tmpfs
3. Mount a new /tmp as partition file