Search Results
https://dev.mysql.com/doc/refman/9.7/en/multiple-key-caches.html
This feature enables you to assign different table indexes to different key caches. Where there are multiple key caches, the server must know which cache to use when processing queries for a given MyISAM table. By default, all MyISAM table indexes ... Note As of MySQL 9.7, the compound-part structured-variable syntax discussed here for referring to multiple MyISAM key caches is ...
https://dev.mysql.com/doc/mysql-router/9.7/en/mysql-router-conf-options.html
The following tables are separated by section, and summarize the MySQL Router options defined in a MySQL Router configuration file. Detailed information about each of these options, such as descriptions and allowed values, is documented below these ... When started, MySQL Router reads a list of configuration files that together make up the configuration of the ...
https://dev.mysql.com/doc/workbench/en/wb-eer-color-key.html
Color connection lines within EER diagrams provide quick visual information about how the tables in your model relate. The following table defines the meaning of each color and indicates how you can open the underlying table information from your ...Existing connection lines are highlighted when you use a pointer device to hover on different database ...
https://dev.mysql.com/doc/workbench/en/wb-relationship-tools.html
Typically this occurs where an intermediary table is created to resolve a many-to-many relationship. In such cases, the primary key is usually a composite key made up of the primary keys from the two original tables. A non-identifying relationship: ...Click on the appropriate tool for the type of relationship you wish to ...
https://dev.mysql.com/doc/refman/9.7/en/archive-storage-engine.html
The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small footprint. When you create an ARCHIVE table, the storage engine creates files with names that begin with the table name. The ...To ...
https://dev.mysql.com/doc/refman/9.7/en/bug-reports.html
If a database table is related to the problem, include the output from the SHOW CREATE TABLE db_name.tbl_name statement in the bug report. This is a very easy way to get the definition of any table in a database. You should also include the output ... Before posting a bug report about a problem, please try to verify that it is a bug and that it has not been reported already: Start by searching the MySQL online manual at ...
https://dev.mysql.com/doc/refman/9.7/en/condition-filtering.html
In join processing, prefix rows are those rows passed from one table in a join to the next. In general, the optimizer attempts to put tables with low prefix counts early in the join order to keep the number of row combinations from increasing ...
https://dev.mysql.com/doc/mysql-enterprise-backup/9.7/en/meb-files-backed-up-summary.html
The following table shows the different types of files that are included in a single-file backup image or a directory backup. Table 1.1 Types of Files in a Backup File Name, Pattern, or Extension Relation to Original Data Files Notes ibdata* The ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ndb-api-statistics.html
Such actions include starting and closing (or aborting) transactions; primary key and unique key operations; table, range, and pruned scans; threads blocked while waiting for the completion of various operations; and data and events sent and ... A ...
https://dev.mysql.com/doc/refman/9.7/en/binary-log-mixed.html
When one or more tables with AUTO_INCREMENT columns are updated and a trigger or stored function is invoked. (Bug #28086) When one of the tables involved is a log table in the mysql database. In MySQL 9.7, operations on temporary tables are not ...