Navicat For MariaDB

MySQL/MariaDB Table Options

Mariadb Management Tools
Mariadb Front End

Navicat for MariaDB provides a native environment for MariaDB database management and administration. It works with all MariaDB database servers from version 5.1 or higher and supports all types of MySQL objects. You can visually design database structures, execute SQL queries and scripts and manage MariaDB users and their privileges. MySQL/MariaDB Table Foreign Keys. A foreign key is a field in a relational table that matches the primary key column of another table. The foreign key can be used to cross-reference tables. In the Foreign Keys tab, just simply click a foreign key field for editing. By using the foreign key toolbar, you can create new, edit and delete the.

Engine
Define the engine of the table.

Character set
Define the type of the character set for table.

Collation
Choose the collation for the table.

Auto Increment
Set/Reset the Auto Increment value in the edit field. The auto increment value indicates the value for next record.

Checksum/Table Checksum(only for MyISAM and Aria tables)
Check this option if you want MySQL to maintain a live checksum for all rows.

Note: Aria table is supported from MariaDB 5.1 or later.

Page Checksum(only for Aria table)
Check this option if you want index and data use page checksums for extra safety.

Note: Support from MariaDB 5.1 or later.

Transactional(only for Aria table)
Check this option if you want crash-safe.

Note: Support from MariaDB 5.1 or later.

Row Format
Defines how the rows should be stored.

Avg. Row Length
An approximation of the average row length for your table. You need to set this only for large tables with variable-size rows.

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

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

Key Block Size
This option provides a hint to the storage engine about the size in bytes to use for index key blocks. The engine is allowed to change the value if necessary. A value of 0 indicates that the default value should be used.

Pack Keys(take effect only with MyISAM table)
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. Setting it to DEFAULT tells the storage engine to pack only long CHAR, VARCHAR, BINARY, or VARBINARY columns.

Delay Key Write(only for MyISAM table)
Check this option if you want to delay key updates for the table until the table is closed.

Data Directory
To specify where the MyISAM storage engine should put a table's data file.

Index Directory
To specify where the MyISAM storage engine should put a table's index file.

Union(only for MRG_MYISAM table)
UNION is used when you want to access a collection of identical MyISAM tables as one. This works only with MERGE tables. You must have SELECT, UPDATE, and DELETE privileges for the tables you map to a MERGE table.

Insert Method(only for MRG_MYISAM table)
If you want to insert data into a MERGE table, you must specify with INSERT_METHOD the table into which the row should be inserted. INSERT_METHOD is an option useful for MERGE tables only. Use a value of FIRST or LAST to have inserts go to the first or last table, or a value of NO to prevent inserts.

Connection(only for FEDERATED table)
To create the local table that will be federated to the remote table. You can create the local table and specify the connection string (containing the server name, login, password) to be used to connect to the remote table using the Connection edit box.

The CONNECTION string contains the information required to connect to the remote server containing the table that will be used to physically store the data. The connection string specifies the server name, login credentials, port number and database/table information.

The format the connection string is as follows:
scheme://user_name[:password]@host_name[:port_num]/db_name/tbl_name

Sample of connection strings:
CONNECTION='mysql://username:password@hostname:port/database/tablename'
CONNECTION='mysql://username@hostname/database/tablename'
CONNECTION='mysql://username:password@hostname/database/tablename'

Tablespace(only for ndbcluster table)
To specify the tablespace for the storage.

Note: Support from MySQL 5.1.6 or later.

Storage(only for ndbcluster table)
To specify type of storage used (disk or memory), and can be one of DISK, MEMORY, or DEFAULT.

Note: Support from MySQL 5.1.6 or later.

Stats Auto Recalc
Indicate whether to automatically recalculate persistent statistics for an InnoDB table.

Note: Support from MariaDB 10.0 or later.

Mariadb Management Tools

Stats Persistent
Indicate whether the InnoDB statistics created by ANALYZE TABLE will remain on disk or not.

Note: Support from MariaDB 10.0 or later.

Partition
Set the Partition options.

Note: Support from MySQL 5.1 or later.

Description
Partition By	Select the function that is used to determine the partition: HASH, KEY, LINEAR HASH, LINEAR KEY, RANGE and LIST.
Partitions	Set the partition number.
Subpartition By	Select the function that is used to determine the subpartition: Hash and Key.
Subpartitions	Set the subpartition number.
Partition Definition	Use or Partition to add or delete the partition. Use or Subpartition to add or delete the subpartition.
Values	For range partitioning, each partition must include a VALUES LESS THAN clause; for list partitioning, you must specify a VALUES IN clause for each partition. This is used to determine which rows are to be stored in this partition.
Engine	Select the storage engine for both partition and subpartition.
Data Directory	The directory where the data for this partition are to be stored.
Index Directory	The directory where the indexes for this partition are to be stored.
Max Rows	The maximum number of rows to be stored in the partition.
Min Rows	The minimum number of rows to be stored in the partition.
Tablespace	Designate a tablespace for the partition. Used for Falcon only.
Node Group	Set the Node Group.
Comment	Enter the comment for the partition.

Navicat for MySQL 15.0.17

Navicat for MySQL is the ideal solution for MySQL/MariaDB administration and development. It is a single application that allows you to connect to MySQL and MariaDB databases simultaneously. Compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud and Google Cloud. This all-inclusive frontend provides an intuitive and powerful graphical interface for database management, development, and maintenance.
Features:
Seamless Data Migration
Data Transfer, Data Synchronization and Structure Synchronization help you migrate your data easier and faster for less overhead. Deliver detailed, step-by-step guidelines for transferring data across databases. Compare and synchronize databases with Data and Structure Synchronization. Set up and deploy the comparisons in seconds, and get the detailed script to specify the changes you want to execute.
Diversified Manipulation Tool
Use Import Wizard to transfer data into a database from diverse formats, or from ODBC after setting up a data source connection. Export data from tables, views, or query results to formats like Excel, Access, CSV and more. Add, modify, and delete records with our spreadsheet-like Grid View together with an array of data editing tools to facilitate your edits. Navicat gives you the tools you need to manage your data efficiently and ensure a smooth process.
Easy SQL Editing

Visual SQL Builder will help you create, edit and run SQL statements without having to worry about syntax and proper usage of commands. Code fast with Code Completion and customizable Code Snippet by getting suggestions for keywords and stripping the repetition from coding.
Intelligent Database Designer
Create, modify and manage all database objects using our professional object designers. Convert your databases into graphical representations using a sophisticated database design and modeling tool so you can model, create, and understand complex databases with ease.
Increase your Productivity
Our powerful local backup/restore solution guides you through the backup process and reduces the potential for errors. Compile professional high-quality reports in minutes using an interactive design interface and efficient workflow, and set an automation for repeatable deployment process like report generation, database backup, and script execution at a specific time or day. No matter where you are, you can always get the job done.

Make Collaboration Easy
Synchronize your connection settings, models, queries and virtual groups to our Navicat Cloud service so you can get real-time access to them, and share them with your coworkers anytime and anywhere. With Navicat Cloud, you can leverage every minute of your day to maximize your productivity.
Advanced Secure Connection

Mariadb Front End

Establish secure connections through SSH Tunneling and SSL ensure every connection is secure, stable, and reliable. Support different authentication methods of database servers such as PAM authentication. Navicat provides more authentication mechanisms and high-performance environments so you never have to worry about connecting over an insecure network.
Only for V.I.P

Warning! You are not allowed to view this text.