You are in: Products > HoneyMonitor > Reference Manual > On-line Consultation >

41.2 Table Properties

The Table Properties Window allows you to view and edit the table properties (Fig. 41.14).

To open the window right click on a table in the ''Server Object List'' and select the ''Table Properties'' item from the popup menu. Also, you can open the Table Properties Window from the Information Tab of the Table Editor (sec. 41.4.7).

See Also:

41.1: Create Table Wizard
41.4.7: Table Editor, Information Tab
41.10: Table's Maintenance
41.11: Table's Utilities

**Figure 41.14:** The Table Properties Window.

41.2.1 General Tab

This Tab (Fig. 41.15) allows you to set the most common table properties.

**Figure 41.15:** Table Properties: General Tab

41.2.1.1 Name and Engine

You may rename the table or change its engine (Fig. 41.16).

A List of the Table Engines is reported in sec. 41.1.10.

**Figure 41.16:** Table Properties: name and engine.

41.2.1.2 Rows Options

For ''MyISAM'' or ''InnoDB'' tables you can set the ''Row Format'', that defines how the rows should be stored (Fig. 41.17).

''Max Rows'' is the maximum number of rows you plan to store in the table. This is not a hard limit, but rather an indicator that the table must be able to store at least this many rows.

''Min Rows'' is the minimum number of rows you plan to store in the table.

**Figure 41.17:** Table Properties: rows options.

41.2.1.3 Merge Options

For ''Merge'' (or ''MRG_MyISAM'') tables you can set a union tables list and the insert method (Fig. 41.18).

Please, refer to sec. 41.3 to get help on the ''Union Table List Window''. Also, note that the ''Merge Options'' frame is disabled if the engine of your table isn't ''Merge''.

**Figure 41.18:** Table Properties: merge options.

41.2.2 Advanced Tab

This tab (Fig. 41.19) allows you to set advanced options.

**Figure 41.19:** Table Properties: Advanced Tab

41.2.2.1 Charset

The ''Character Set'' frame allows you to set the table charset and collation (Fig. 41.20).

Please, note that a table and its database can have different charset; also a table and its columns can have different charset.

See Also:

6.3.1: Client, Results and Connection Charset and Collation
27.7: Server Charset and Collation
37.1: Database Charset and Collation
41.5.1: Columns Charset and Collation

MySQL^TM chooses the table character set and collation in the following manner:

If both CHARACTER SET X and COLLATE Y were specified, then character set X and collation Y.
If CHARACTER SET X was specified without COLLATE, then character set X and its default collation.
Otherwise, the database character set and collation.

**Figure 41.20:** Table Properties: charset and collation.

41.2.2.2 Other Options

This frame (Fig. 41.21) allows you to set more table options.

Options Description:

http://www.honeysoftware.com/products/honeymonitor/doc/images/checkbox.jpg

Auto Increment
The initial AUTO INCREMENT value for the table. This works for MyISAM only, for MEMORY as of MySQL^TM 4.1, and for InnoDB as of MySQL^TM 5.0.3.

Password
Encrypt the .frm file with a password. This option doesn't do anything in the standard MySQL^TM version.

Comment
A comment for your table, up to 60 or 80 (it depends by your server version) characters long.

Checksum
Set this to 1 if you want MySQL^TM to maintain a live checksum for all rows (that is, a checksum that MySQL^TM updates automatically as the table changes). This makes the table a little slower to update, but also makes it easier to find corrupted tables. The CHECKSUM TABLE statement reports the checksum (MyISAM only).

Pack Keys
Set this option to 1 if you want to have smaller indexes. This usually makes updates slower and reads faster. Setting the option to 0 disables all packing of keys.

Delay Key Writes
Set this to 1 if you want to delay key updates for the table until the table is closed (MyISAM only).

**Figure 41.21:** Table Properties: other options.

41.2.3 Storage Tab

This tab (Fig. 41.22) allows you to set the storage options for your tables.

**Figure 41.22:** Table Properties: Storage Tab

41.2.3.1 Storage Options

For MyISAM tables you can set the Data and Index directories; setting these directories you can specify where the MyISAM storage engine should put a table's data file and index file. The directory must be the full pathname to the directory, not a relative path (Fig. 41.23).

**Figure 41.23:** Table Properties: storage options.

41.2.3.2 Raid Options

If your MySQL^TM server version is lesser than 5.0 you may set the raid options (Fig. 41.24).

Note: MySQL^TM 5.1 introduces the table partitioning; so you may use the Partition Editor to manage table's partitions (sec. 41.9.2).

**Figure 41.24:** Table Properties: raid options.

<< Back

Contents

Next >>

Lingue Disponibili:

Inglese >>

Italiano >>

Risorse Disponibili:

Download >>	Acquista >>	HoneySoftware EULA >>
Supporto Tecnico >>

Ulteriori Risorse::

Richiesta CD >>

HoneySoftware

41.2 Table Properties