This section provides configuration options that affect the Modeling functionality in MySQL Workbench.
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.
Set default values for various modeling object names.
The following tables show the object names and their default values.
|Object Name||Default Value|
Foreign Key/Relationship Defaults
|Object Name||Default Value|
This enables you to set model related options specific to your MySQL version.
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
TIMESTAMP, automatic initialization 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
[ ] 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
[ ] Show Column Flags:
Max. Number of Columns to Display:
30] Larger tables will be
Trim Routine Names Longer Than:
Relationships / Connections
[ ] Draw Line Crossings (slow in large diagrams):
[ ] Hide Captions: Enabled by default.
[ ] Center Captions Over Line:
Use this tab to set the available colors for the objects that appear on an EER diagram canvas. You can also add colors if you wish.
For related information, see Section 3.1, “User Accessibility Options”.
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.