Procedure Analyse in MySQL to Check Types
, Sunday, June 7, 2009In MySQL there is command "procedure analyse". It can be used to find out if you're using the right types in a table. As an example you can call:
SELECT * FROM user procedure analyse()
It will output the types you use, min-max value and min-max length and some more information. This could give you some advices which file types you should check.
More detailed informations you'll find in the MySQL Performance Blog.
