:: DEVELOPER ZONE
MySQL Reference Manual :: 27.3.1 Procedure Analyse
Search the MySQL manual:
- 27.3 Adding New Procedures to MySQL
- 27.3.1 Procedure Analyse
- 27.3.2 Writing a Procedure
Additional languages
Additional formats
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 valuesanalysedoes notice per column. This is used byanalyseto check whether the optimal column type should be of typeENUM.max_memory(default 8192) is the maximum amount of memory thatanalyseshould allocate per column while trying to find all distinct values.
SELECT ... FROM ... WHERE ... PROCEDURE ANALYSE([max_elements,[max_memory]])
© 1995-2005 MySQL AB. All rights reserved.
User Comments
Warning: query failed: Unknown column 'user.firstname' in 'field list' in /data0/sites/live/web-main/lib/mysql-cxn.php on line 69
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /data0/sites/live/web-main/lib/docbook.php on line 245
Add your own comment.