dbrowse

Table Metadata

This node is informative, descriptive, functional and terminating.
[definitions]

Query Path

Interactive Path

Synopsis

This is a detailed view of all metadata for the active table in the current database.

Node/View

[skip to the dbrowse Navigation information]

Description of Results

Since the fields shown in the top portion of the results in this node have already been documented in the previous view, I will not reiterate them here. However, the additional highlighted fields listed here are described below.

For detailed documentation regarding the information displayed on this page, visit the MySQL Reference Manual section on Show Table Status. Brief descriptions are listed below, some of which have links to more specific sections of the manual.

MySQL Terms

Maximum Data File Size

The largest size that the data file may grow to in gigibytes. This is generally a function of the platform and OS that the MySQL server is running under, and the installed filesystem. This information is generally for novelty purposes only, as any table that grows anywhere near this size is going to have some pretty serious preformance problems. See also How Big Tables Can Be in the MySQL Reference Manual.

Allocated Free Space

The allocated free space occupied by the table. Certain Storage Engines, e.g. Memory (Heap) tables reserve, usually large, amounts of space for efficiency reasons. This field does not normally apply to disk-based engines such as MyISAM tables.

Next Auto Increment Value

For tables that have auto_increment column types, this field indicates the value that was used on the last INSERT or UPDATE statement performed on the table. See mysql_insert_id(), and how to Get the Unique ID for the last inserted row, for more information.

Table Creation Timestamp

When the table was created.

Table Modification Timestamp

When the table was last updated. This could be any number of different modifications to the table including, but not limited to, inserting new records, deleting records, repairing a corrupted table, and so on. This value does no reflect access time, such as when the last selection was performed or other read-only queries such as the view you are now studying.

Table Error Check Timestamp

The last time the table was checked for errors. See for more information.

Other Create Table Options

Additional options used when the table was initially built. See Create Table Syntax for many, many details on creating MySQL tables.

Additional Table Notes

Comments stored with the table when it was created. MySQL will sometimes use this field for other notations regarding the table.

Note: Regarding the three date values in this (and possibly other) view(s): I have formatted them according to my server’s local time and according to my Language preference. This is easily modified if you wish to use or adapt this application for your own purposes.

Navigation

This is a terminating view in one query path for the active database. You may use your Web browser to return to the previous view for other routes to follow. Or give the interactive path a try.