Database Reference
In-Depth Information
Figure 13.8
Optimizing a table.
CHECK TABLE
The CHECK TABLE command allows you to check one or a series of your tables for errors.
The command is used as follows:
CHECK TABLE tablename, tablename, tablename, … options
Use as many
tablenames
as you like separated with commas.
options
can be one of the following:
•
QUICK does not check for wrong links.
•
FAST just checks tables which have not been closed in the correct way.
•
CHANGED checks rows as above and tables that have changed since the last time that
CHECK TABLE was run.
•
MEDIUM checks the rows in the table for correct deleted links, generates a checksum
for the rows and verifies this from the key checksums.
•
EXTENDED ensures that the table is 100% correct and can take some time to run.
The CHECK TABLE command will return a table with the results of the check in it. A
sample output for some of the tables we have used in this topic is shown in Figure 13.9.
You will notice that the output provides the name of the table, the operation, which is
always check, a message type and the text of the message.
The message type can be either:
•
status
•
error
•
info, or
•
warning.
Search WWH ::
Custom Search