tmp_table_size

I have below errors in MySQL log today, is it need to increase "tmp_table_size" in "my.cnf"?

2016-02-05 17:47:23 28254 [ERROR] /usr/sbin/mysqld: Sort aborted: Error writing file '/tmp/MYWJj6hn' (Errcode: 28 - No space left on device)
2016-02-05 17:47:24 28254 [ERROR] /usr/sbin/mysqld: Sort aborted: Error writing file '/tmp/MYw9IoMn' (Errcode: 28 - No space left on device)
2016-02-05 17:47:27 28254 [ERROR] /usr/sbin/mysqld: Sort aborted: Error writing file '/tmp/MYxc5hpS' (Errcode: 28 - No space left on device)
2016-02-05 17:47:27 28254 [ERROR] /usr/sbin/mysqld: Sort aborted: Error writing file '/tmp/MYzyXCAk' (Errcode: 28 - No space left on device)
2016-02-05 17:47:27 28254 [ERROR] /usr/sbin/mysqld: Sort aborted: Error writing file '/tmp/MYTBwc5v' (Errcode: 28 - No space left on device)
2016-02-05 17:47:27 28254 [ERROR] /usr/sbin/mysqld: Sort aborted: Error writing file '/tmp/MYQdsYIF' (Errcode: 28 - No space left on device)

will you pls help me to point a domain to specific ip address

Infopro

February 05, 2016 14:09

You might want to open another thread on that issue.

cPanelMichael

February 05, 2016 14:43

Hello :) Check to see if there's available disk space and inodes on your tmp directory. EX:

df -h
df -i

Thank you.

Masimo

February 06, 2016 10:45

Its looking fine, any more idea? [root@static tools]# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda5 995G 31G 914G 4% / tmpfs 5.9G 0 5.9G 0% /dev/shm /dev/sda1 2.0G 63M 1.8G 4% /boot /dev/sda3 3.9G 13M 3.7G 1% /tmp

SysSachin

February 06, 2016 11:21

Hi, Please check inodes uses. Might be inodes uses is 100 %. run the below command. df -i

February 06, 2016 14:33

Its ok! [root@static tools]# df -i Filesystem Inodes IUsed IFree IUse% Mounted on /dev/sda5 66191360 157618 66033742 1% / tmpfs 1524782 1 1524781 1% /dev/shm /dev/sda1 131072 46 131026 1% /boot /dev/sda3 262144 20 262124 1% /tmp

February 08, 2016 18:07

Hello :) You can also try the instructions on this post: Drive Critical: /dev/loop0 (/var/tmp) is 97% full Thank you.

tmp_table_size

Comments

Didn't find what you were looking for?