Menambah Ukuran /tmp cPanel Lebih dari 4 GB

Kadang mysql bisa tinggi sekali penggunaannya dan menyebabkan server load. Penyebab usage mysql tinggi bisa macam-macam, salah satunya karena folder “/tmp” penuh

Gimana cek penyebab mysql loadnya lambat/error?

Lakukan, command berikut

root@s1 [~]# cat /var/lib/mysql/hostnameserveranda.err

Kalau muncul begini, berati ukuran /tmp perlu diperbesar, default maksimal dari cPanel adalah 4 GB

2016-01-20 21:40:00 20207 [ERROR] /usr/sbin/mysqld: Sort aborted: Error writing file '/tmp/MYBFjrjO' (Errcode: 28 - No space left on device)
2016-01-20 21:40:00 20207 [ERROR] /usr/sbin/mysqld: Sort aborted: Error writing file '/tmp/MYq8JhXX' (Errcode: 28 - No space left on device)
2016-01-20 21:40:00 20207 [ERROR] /usr/sbin/mysqld: Sort aborted: Error writing file '/tmp/MYXOcfgE' (Errcode: 28 - No space left on device)
2016-01-20 21:40:00 20207 [ERROR] /usr/sbin/mysqld: Sort aborted: Error writing file '/tmp/MYsBdST8' (Errcode: 28 - No space left on device)
2016-01-20 21:40:00 20207 [ERROR] /usr/sbin/mysqld: Sort aborted: Error writing file '/tmp/MYc02XxL' (Errcode: 28 - No space left on device)

Cara perbesarnya, misalkan ingin kita ubah jadi 8 GB

backup /scripts/securetmp menjadi /scripts/securetmp.bak (duplikat beda nama untuk arsip)

   mv /scripts/securetmp /scripts/securetmp.bak

atau aslinya begini,

   mv /usr/local/cpanel/scripts/securetmp /usr/local/cpanel/scripts/securetmp.bak

lalu edit /scripts/securetmp

Ubah $tmpdsksize,

     $tmpdsksize = 8388608; # 1024 * 1024 * 8

Ubah ini (ukuran RAM),

    my $FOUR_GIG_k = ( 1024 * 1024 * 4 );
    if ( $tmpdsksize > $FOUR_GIG_k ) {
        $tmpdsksize = $FOUR_GIG_k;
    }

jadi begini

    my $FOUR_GIG_k = ( 1024 * 1024 * 8 );
    if ( $tmpdsksize > $FOUR_GIG_k ) {
        $tmpdsksize = $FOUR_GIG_k;
    }

Selanjutnya, restart server.

Kalau 8 GB masih kurang, naikkan jadi 12 GB, 16 GB, dst