MySQL Workbench Manual  /  ...  /  Modeling Preferences

3.2.4 Modeling Preferences

This section provides configuration options that affect the Modeling functionality in MySQL Workbench (see the figure that follows).

Preferences: Modeling: Main

Figure 3.11 Preferences: Modeling

Content is described in the surrounding text.

EER Modeler

  • Automatically reopen previous model at start: Check this if you want the model on which you previously worked to be automatically reopened when you start MySQL Workbench.

  • Force use of software based rendering for EER diagrams: MySQL Workbench will use OpenGL for rendering when available. However, due to faulty drivers, problems do occasionally occur. These issues can be resolved by selecting the software rendering option here.

  • Model undo history size: You can limit the size of the undo history here. Set this value to 0 to have an unlimited undo history.

  • Auto-save model interval: An open model that has not been saved will automatically be saved after this period. On loading a model file, MySQL Workbench will notify the user if the file was not previously saved correctly, due to a crash or power failure. MySQL Workbench can then attempt to recover the last auto-saved version. For automatic recovery to be available for a new file, it will have to have been saved at least once by the user.

Preferences: Modeling: Defaults

Sets default values for modeling object names (see the figure that follows).

Figure 3.12 Preferences: Modeling: Defaults

Content is described in the surrounding text.

The following tables show the object names and their default values.

Column Defaults

Object Name Default Value
PK Column Name id%table%
PK Column Type INT
Column Name %table%col
Column Type VARCHAR(45)

Foreign Key/Relationship Defaults

Object Name Default Value
FK Name fk%stable_%dtable%
Column Name %table%_%column%
Associative Table Name %stable%_has_%dtable%

Preferences: Modeling: MySQL

This preference group enables you to set model-related options specific to your MySQL version (see the figure that follows).

Figure 3.13 Preferences: Modeling: MySQL

Content is described in the surrounding text.


  • Default Target MySQL Version: A limited subset of validation procedures and table editor options are affected by this MySQL version number.

    Supported MySQL Server 5.6 features include fraction seconds support for TIME, DATETIME, and TIMESTAMP, automatic initialization and updates for TIMESTAMP and DATETIME (for example, setting them to CURRENT_TIMESTAMP), and FULLTEXT index types with the InnoDB engine.

Model Table Defaults

  • Default Storage Engine: Tables created in MySQL Workbench will be defined using this default storage engine.

Forward Engineering and Synchronization

  • SQL_MODE to be used in generated scripts: Defaults to "TRADITIONAL,ALLOW_INVALID_DATES", this defines the SQL_MODE used by Forward Engineering and Synchronization.

Preferences: Modeling: Diagram

The following figure shows the preference options that apply to model-related diagrams.

Figure 3.14 Preferences: Modeling: Diagram

Content is described in the surrounding text.

All Objects

  • [ ] Expand New Objects: Enabled by default.

  • [ ] Propagate Object Color Changes to All Diagrams: Enabled by default.


  • [ ] Show Column Types: Enabled by default.

  • [ ] Show Schema Name:

  • Max. Length of ENUMs and SETs to Display: [20]

  • [ ] Show Column Flags:

  • Max. Number of Columns to Display: [30] Larger tables will be truncated.


  • Trim Routine Names Longer Than: [20] characters.

Relationships / Connections

  • [ ] Draw Line Crossings (slow in large diagrams):

  • [ ] Hide Captions: Enabled by default.

  • [ ] Center Captions Over Line:

Preferences: Modeling: Appearance

Use this preference group to set the available colors for the objects that appear on an EER diagram canvas. As the following figure shows, you can also add colors as needed.

For related information, see Section 3.1, “User Accessibility Options”.

Figure 3.15 Preferences: Modeling: Appearance

Content is described in the surrounding text.

Color Presets

These are the available colors used while modeling, and they are divided into two sections. First, the colors used when creating tables and views. The second section are available colors for items such as layers and notes.


These define the fonts and font sizes used while modeling.