Provides with PROCEDURE ANALYSE() to help us detect inconsistencies in our database design by suggesting for an optimal datatype and data length for columns.
http://satejkumar.blogspot.cz/2017/01/mysql-procedure-analyse-use.html
origin - http://www.pipiscrew.com/?p=6598 mysql-procedure-analyse-use