"The MySQL® server is currently offline" 3 hari berturut-turut..HELP...!!

1stserver · 7 Jan 2012

herisetiyawan said:
Setelah aman2 aja 1 minggu hari ini penyakit lama kumat lagi..hehehe Website eror..di cpanel keluar pesan error "The MySQL® server is currently offline"..Gimana nih bos..?
oya ..soal saran anda.."coba copy paste config pada /etc/my.cnf dan log error mysql nya ( tail -f /var/lib/mysql/`hostname`.err )"..itu gimana caranya..? hehehe maklum saya awam banget..itu perintah di SSH ya..? Mohon bantuannya bos...

diblok saja pakai mouse yg mau dicopy lalu tekan ctrl+c lalu paste di sini

galuh82 · 7 Jan 2012

selain resource ram/cpu dicek juga apakah spacenya terutama untuk data dan log. biasanya bisa terjadi juga karena log sudah full. CMIIW

salam,

indonic · 7 Jan 2012

herisetiyawan said:
Setelah aman2 aja 1 minggu hari ini penyakit lama kumat lagi..hehehe Website eror..di cpanel keluar pesan error "The MySQL® server is currently offline"..Gimana nih bos..?
oya ..soal saran anda.."coba copy paste config pada /etc/my.cnf dan log error mysql nya ( tail -f /var/lib/mysql/`hostname`.err )"..itu gimana caranya..? hehehe maklum saya awam banget..itu perintah di SSH ya..? Mohon bantuannya bos...

iya itu perintah di SSH, dan apabila akses pake putty tuk SSH nya tinggal jalanin perintah ini saja:
# cat /etc/my.cnf
--> select dengan mouse hasilnya dan paste ke notepad dulu aja hasilnya

# tail /var/lib/mysql/`hostname`.err
--> select dengan mouse hasilnya dan paste ke notepad dulu jg hasilnya

Setelah itu dari notepad tadi di atas, di copy paste ke thread di forum ini...

herisetiyawan · 9 Jan 2012

indonic said:
iya itu perintah di SSH, dan apabila akses pake putty tuk SSH nya tinggal jalanin perintah ini saja:
# cat /etc/my.cnf
--> select dengan mouse hasilnya dan paste ke notepad dulu aja hasilnya

# tail /var/lib/mysql/`hostname`.err
--> select dengan mouse hasilnya dan paste ke notepad dulu jg hasilnya

Setelah itu dari notepad tadi di atas, di copy paste ke thread di forum ini...

Thanks reply-nya bos..
Ini hasilnya :

max_connections = 800
max_user_connections = 800
key_buffer = 36M
myisam_sort_buffer_size = 64M
join_buffer_size = 2M
read_buffer_size = 2M
sort_buffer_size = 3M
table_cache = 1024
thread_cache_size = 286
interactive_timeout = 25
wait_timeout = 1800
connect_timeout = 10
max_allowed_packet = 1M
max_connect_errors = 999999
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
tmp_table_size = 32M

120109 8:51:18 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:20 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:20 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:20 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:20 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:20 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:20 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:20 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:20 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:21 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:21 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:21 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:21 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:23 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:25 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:26 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:27 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:28 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:29 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:30 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:30 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:30 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:30 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:30 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:30 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:30 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:30 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired

bingung saya..gaktau apa maksudnya..?
eya..kemarin itu setelah error seperti itu saya coba restart VPs ternyata bisa sampe sekarang...Gimana tuh bos..?
Yang ingin saya tahu..
1. Apa penyebab error tsb.. dan
2. Apa yang harus saya lakukan untuk mencegah/mengatasi error tersebut
Trims banyak sebelumnya..

herisetiyawan · 9 Jan 2012

galuh82 said:
selain resource ram/cpu dicek juga apakah spacenya terutama untuk data dan log. biasanya bisa terjadi juga karena log sudah full. CMIIW

salam,

space-nya 30% bos..

indonic · 10 Jan 2012

herisetiyawan said:
Thanks reply-nya bos..
Ini hasilnya :

max_connections = 800
max_user_connections = 800
key_buffer = 36M
myisam_sort_buffer_size = 64M
join_buffer_size = 2M
read_buffer_size = 2M
sort_buffer_size = 3M
table_cache = 1024
thread_cache_size = 286
interactive_timeout = 25
wait_timeout = 1800
connect_timeout = 10
max_allowed_packet = 1M
max_connect_errors = 999999
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1
tmp_table_size = 32M

120109 8:51:18 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:20 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:20 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:20 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:20 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:20 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:20 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:20 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:20 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:21 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:21 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:21 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:21 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:23 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:25 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:26 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:27 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:28 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:29 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:30 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:30 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:30 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:30 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:30 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:30 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:30 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:30 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired
120109 8:51:31 [ERROR] /usr/sbin/mysqld: Table './rajaikla_aq/wp_postmeta' is marked as crashed and should be repaired

bingung saya..gaktau apa maksudnya..?
eya..kemarin itu setelah error seperti itu saya coba restart VPs ternyata bisa sampe sekarang...Gimana tuh bos..?
Yang ingin saya tahu..
1. Apa penyebab error tsb.. dan
2. Apa yang harus saya lakukan untuk mencegah/mengatasi error tersebut
Trims banyak sebelumnya..

sepertinya database rajaikla_aq, terdapat table corrupt atau rusak...sebenarnya bisa di perbaiki dengan optimized/repair database. Dan bisa di lakukan dengan command ini tuk mengatasinya:
mysqlcheck --all-databases -r #repair
mysqlcheck --all-databases -a #analyze
mysqlcheck --all-databases -o #optimize

twistedshells · 11 Jan 2012

@TS: selain melakukan yang disarankan oleh rekan diatas, coba backup data Anda ke server lain, lalu minta provider Anda melakukan pengecekan HD Anda

Ada kemungkinan masalah bad HD juga...

latanweb · 5 Feb 2012

coba restart om vpsnya sapa tau efek ><

"The MySQL® server is currently offline" 3 hari berturut-turut..HELP...!!

1stserver

Hosting Guru

galuh82

Hosting Guru

indonic

Apprentice 1.0

herisetiyawan

New Member

herisetiyawan

New Member

indonic

Apprentice 1.0

twistedshells

Apprentice 1.0

latanweb

Beginner 1.0