MySQL Procedure Analyse – optimising data types

Welcome Back!

The MySQL Performance Blog has another gem in the form of MySQL’s Procedure Analyse function.

Procedure Analyse helps you find the optimal data type for the column values in a table.

Usage is very simple:

SELECT … FROM … WHERE … PROCEDURE ANALYSE([max_elements,[max_memory]])

A range of statistics and recommended data types and are returned for each column in your table.

For more information see the MySQL Docs on using Procedure Analyse.