(mysql.info) procedure-analyse

 
 24.3.1 Procedure Analyse
 ------------------------
 
 `analyse([MAX_ELEMENTS,[MAX_MEMORY]])'
 
 This procedure is defined in the `sql/sql_analyse.cc'. This examines the
 result from your query and returns an analysis of the results:
 
    * MAX_ELEMENTS (default 256) is the maximum number of distinct
      values `analyse' does notice per column. This is used by `analyse'
      to check whether the optimal data type should be of type `ENUM'.
 
    * MAX_MEMORY (default 8192) is the maximum amount of memory that
      `analyse' should allocate per column while trying to find all
      distinct values.
 
      SELECT ... FROM ... WHERE ... PROCEDURE ANALYSE([MAX_ELEMENTS,[MAX_MEMORY]])

Info Catalog

(mysql.info) adding-procedures

(mysql.info) writing-a-procedure

automatically generated byinfo2html