Memperbaiki warning aneh Innodb_table_stats Has Length Mismatch

بِسْمِ اللهِ الرَّحْمٰنِ الرَّحِيْمِ

Jadi ketika lagi cek log mysql di SPLUNK ada warning kayak gini buanyaaak bat buseet:

[Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade

Gajelas si itu kenapa, terus nemu caranya tinggal jalanin aja mysql_upgrade tapi jangan lupa untuk full backup buat jaga-jaga kalo kalo yakaann.

nah kalo udh di backup langsung login ke server.

terus jalanin command ini:

# mysql_upgrade -u root -p

dan tadaaaa.. Warning aneh itu sudah lenyaap

Sumber: https://alltime.pp.ua/blog/how-to-fix-innodb_table_stats-and-innodb_index_stats-has-length-mismatch/

20 November 2020
20:36 WIB
Pogung Baru, Sleman
Yogyakarta

comments powered by Disqus