Flush table: This must be done when there have been lots of connection
errors and the MySQL server blocks further connections. Flushing will clear
some internal caches and allow normal operations to resume.
Defragment table: Random insertions or deletions in an InnoDB table
fragment its index. The table should be periodically defragmented for faster
data retrieval.
The operations are based on the underlying MySQL queries
available??”phpMyAdmin is only calling those queries.
Changing Table Attributes
Table attributes are the various properties of a table. This section discusses the
settings for some of them.
???
???
???
???
???
???
Chapter 10
[ 163 ]
Table Type
The first attribute we can change is called Table storage engine:
This controls the whole behavior of the table: its location (on-disk or in-memory),
the index structure, and whether it supports transactions and foreign keys. The
drop-down list may vary depending on the table types supported by our
MySQL server.
Changing the table type may be a long operation if the number of rows
is large.
Table Comments
This allows us to enter comments for the table.
Table and Database Operations
[ 164 ]
These comments will be shown at appropriate places (for example, in the left panel,
next to the table name in the Table view and in the export file). Here is what the left
panel looks like when the $cfg['ShowTooltip'] parameter is set to its default
value of TRUE:
The default value of $cfg['ShowTooltipAliasDB'] and $cfg['ShowTooltipAlias
TB'] (FALSE) produces the behavior we have seen earlier: the true database and table
names are displayed in the left panel and in the Database view for the Structure
sub-page.
Pages:
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164