(mysql.info.gz) procedure analyse

Info Catalog

(mysql.info.gz) Adding procedures

(mysql.info.gz) Adding procedures

(mysql.info.gz) Writing a procedure

 
 25.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' will notice per column.  This is used by
      `analyse' to check whether the optimal column type should be of
      type `ENUM'.
 
    * `max memory' (default 8192) is the maximum memory `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.gz) Adding procedures

(mysql.info.gz) Adding procedures

(mysql.info.gz) Writing a procedure