Optimize- to write computer programming
instructions for a task in as few lines as possible to maximize the speed and
efficiency of program execution. From the definition itself, optimizing the
table is to optimize the table. It is to give the high quality of the table. When you delete lot of rows from a table, optimizing
it helps to get the unused space and defragment the data file. This might
improve performance on huge tables that has gone through several updates. The command for optimizing the table: optimize table [table_name].
Checking a table
It is for checking the tables for error.
The command for checking the table: check
table [table_name]. It is a default operation. It can also check views for
problems, such as tables that are referenced in the view definition that no
longer exist. It is also supported for partitioned tables. There are types of
check: quick, fast, changed, medium, and extended. It also changes the table if
there is an error.
Repairing a table
The advantage or benefit of repairing a
table is fixing the table except the unique keys that are not unique. The
command for repairing a table: repair
table [table_name]. It is for repairing the table for the possible corrupt
table. The repair table statement might produce many rows of information for each
repaired table. Repairing the table also checks the table to see whether an
upgrade is required.
Analyzing a table
Analyzing tables
improves performance by updating the index information for a table so that
MySQL can make a better decision on how to join tables. While mysqlcheck is
executing, the analyze command the table is locked and available for other
process only in the read mode.
Analyzing the table analyzes and stores the
key distribution for a table. The command for analyzing the table:analyze table [table_name].
No comments:
Post a Comment