[HELP] mysql server has gone away

Diskusi tentang Ubuntu Server baik webserver, database server, samba server dan service lainnya serta jaringan menggunakan Sistem Operasi Ubuntu.
User avatar
fafa
Posts: 10
Joined: 07 Oct 2012, 10:34
Location: madiun

[HELP] mysql server has gone away

Postby fafa » 10 Oct 2012, 06:44



koneksi client ke server terputus saat idle (diam) bbrp saat. kurang lebih 60 menit lalu muncul "mysql server has gone away" spt gambar diatas.

bagaimana setting supaya bisa selalu connect walaupun saat idle?
jd tidak perlu restart client atau bahkan restart Mysql service di server nya.

thx atas jawabannya
User avatar
fafa
Posts: 10
Joined: 07 Oct 2012, 10:34
Location: madiun

Re: [HELP] mysql server has gone away

Postby fafa » 11 Oct 2012, 08:13

[pertanyaan tambahan]

kenapa udah di tambahin di /etc/mysql/my.cnf

wait_timeout = 12960000
interactive_timeout = 12960000


tetap aja enggak bisa?
tetap aja waktu di cek lewat webmin configurasi nya tetap

wait_timeout = 28800
interactive_timeout = 28800


betul2 bikin puyeenggg....

help donk,,,, udah 2 hari 2 malam mikirin nya...

:cry: :cry: :cry:
User avatar
emre
Posts: 140
Joined: 28 May 2012, 11:00
Location: Cilegon, Indonesia

Re: [HELP] mysql server has gone away

Postby emre » 11 Oct 2012, 09:54

[quote=fafa][pertanyaan tambahan]

kenapa udah di tambahin di /etc/mysql/my.cnf

wait_timeout = 12960000
interactive_timeout = 12960000


Setelah rubah konfigurasi, apakah sudah di-restart mysql service nya?