Table and Database Operations - Mastering phpMyAdmin 2.8 for Effective MySQL Management - page 149

After the sort has been done on author_id , topics for author 1 will be displayed
irst, followed by the topics for author 2 , and so on. (We are talking about a default
browsing of the table without explicit sorting.) We can also specify the sort order:
Ascending or Descending .

If we insert another row, describing a new book from author 1 , and then click
Browse , the topic will not be displayed along with the other topics for this author
because the sort was done before the insertion.

Table Options
Other attributes that influence the table's behavior may be specified using the Table
options dialog:

The options are:

• pack_keys : Setting this attribute results in a smaller index; this can be read

faster but takes more time to update. Available for MyISAM and ISAM
table types.
checksum : This makes MySQL compute a checksum for each row. This
results in slower updates, but easier finding of corrupted tables. Available for
MyISAM only.
delay_key_write : This instructs MySQL not to write the index updates
immediately but to queue them for later, which improves performance.
Available for MyISAM only.

•

•