Showing posts with label Recalculation of persistent statistics requested for table. Show all posts
Showing posts with label Recalculation of persistent statistics requested for table. Show all posts

Wednesday, 28 December 2016

[Warning] InnoDB: Cannot open table mysql/innodb_index_stats || InnoDB error for MySQL5.6 in MAMP

I did the procedure on a clean installed MAMP (with MySQL5.6 latest till now date) and it worked for me, atleast it gets rid from errors in the "/Applications/MAMP/logs/mysql_error_log.err" and use of transient tables and yes it would be a temporary fix so do it as your own risk

 Steps to be follow:

 -> Drop below tables from mysql database: innodb_index_stats, innodb_table_stats, slave_master_info, slave_relay_log_info, slave_worker_info
 i.e DROP TABLE if exists <TABLE_NAME>

-> Delete all .frm and.ibd of the tables above i.e rm "/Applications/MAMP/db/mysql56/mysql"/ <TABLE_NAME.frm>

-> run/download five tables to create tables above again, either run SQL or import SQL

-> restart MAMP (basically we need to restart mysql server only)

Cheers!