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
Leave a Reply