I've recently upgraded mysql version on one of the systems from mysql 5.5.28 to 5.7.12 after upgrading binaries I've also upgraded schema of tables using
$sudo mysql_upgrade --force
which executed successfully without any error.
I was trying to check if there are any crashed tables using following query
mysql> select table_schema,table_name from information_schema.tables where index_length is NULL or data_length is NULL;
(since this is now allowing me to post complete info regarding my query I am going to add link to my post of other forums. Hope I will be able to put data in multiple posts.Kindly follow the link:- http://www.linuxquestions.org/questions/showthread.php?p=5582807#post5582807)