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..