Fixed bug in CHECK TABLE ... EXTENDED

Added keyword MEDIUM to CHECK TABLE
New benchmarks results for Linux-alpha

1 files changed, 15 insertions, 1 deletions

diff --git a/Docs/manual.texi b/Docs/manual.texi
index 81d0a5708c4..c6eb5dac81e 100644
--- a/Docs/manual.texi
+++ b/Docs/manual.texi
@@ -18419,13 +18419,15 @@ running!
 @example
 CHECK TABLE tbl_name[,tbl_name...] [option [option...]]
 
-option = QUICK | FAST | EXTEND | CHANGED
+option = QUICK | FAST | MEDIUM | EXTEND | CHANGED
 @end example
 
 @code{CHECK TABLE} only works on @code{MyISAM} and @code{BDB} tables. On
 @code{MyISAM} tables it's the same thing as running @code{myisamchk -m
 table_name} on the table.
 
+If you don't specify any option @code{MEDIUM} is used.
+
 Checks the table(s) for errors. For @code{MyISAM} tables the key statistics
 is updated. The command returns a table with the following columns:
 
@@ -18451,9 +18453,14 @@ The different check types stand for the following:
 @item @code{QUICK} @tab Don't scan the rows to check for wrong links.
 @item @code{FAST}  @tab Only check tables which haven't been closed properly.
 @item @code{CHANGED} @tab Only check tables which have been changed since last check or haven't been closed properly.
+@item @code{MEDIUM} @tab Scan rows to verify that deleted links are ok. This also calculates a key checksum for the rows and verifies this with a calcualted checksum for the keys.
 @item @code{EXTENDED} @tab Do a full key lookup for all keys for each row.  This ensures that the table is 100 % consistent, but will take a long time!
 @end multitable
 
+For dynamic sized @code{MyISAM} tables a started check will always
+do a @code{MEDIUM} check. For static size rows we skip the row scan 
+for @code{QUICK} and @code{FAST} as the rows are very seldom corrupted.
+
 Note that for BDB tables the different check options doesn't affect the
 check in any way!
 
@@ -40396,6 +40403,13 @@ though, so Version 3.23 is not released as a stable version yet.
 @appendixsubsec Changes in release 3.23.31
 @itemize @bullet
 @item
+@code{SHOW TABLE STATUS} didn't show correct average row length for tables
+bigger than 4G.
+@item
+@code{CHECK TABLE .. EXTENED} didn't check row links for fixed size tables.
+@item
+Added option @code{MEDIUM} to @code{CHECK TABLE}.
+@item
 Fixed problem when using @code{DECIMAL()} keys on negative numbers.
 @item
 @code{HOUR()} on a @code{CHAR} column always returned @code{NULL}.