PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-best-practices.html
Specify a primary key for every table using the most frequently queried column or columns, or an auto-increment value if there is no obvious primary key. Use joins wherever data is pulled from multiple tables based on identical ID values from those ...Adding foreign keys ensures that referenced columns are indexed, which can improve ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-storage-layout.html
Once your data reaches a stable size, or a growing table has increased by tens or some hundreds of megabytes, consider using the OPTIMIZE TABLE statement to reorganize the table and compact any wasted space. The reorganized tables require less disk ...This is a straightforward technique that can improve performance when other techniques such as improving index usage or tuning application code are not ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-lifecycle.html
A GTID is also assigned to the creation, alteration, or deletion of a database, and of a non-table database object such as a procedure, function, trigger, event, view, user, role, or grant. Whenever the binary log is rotated or the server is shut ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-select-into-table.html
For example: INSERT INTO tbl_temp2 (fld_id) SELECT tbl_temp1.fld_order_id FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100; Alternatively, you can use SELECT ... The same syntax can also be used inside stored routines using cursors and local ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-information-schema-tables.html
The following sections describe the INFORMATION_SCHEMA tables associated with MySQL Enterprise Firewall (see Section 6.4.6, “MySQL Enterprise Firewall”). These tables are available only if the appropriate firewall plugins are enabled.
https://dev.mysql.com/doc/refman/5.7/en/general-information-schema-tables.html
The following sections describe what may be denoted as the “general” set of INFORMATION_SCHEMA tables. These are the tables not associated with particular storage engines, components, or plugins.
https://dev.mysql.com/doc/refman/5.7/en/information-schema-character-sets-table.html
The CHARACTER_SETS table has these columns: CHARACTER_SET_NAME The character set name. MAXLEN The maximum number of bytes required to store one character. Notes Character set information is also available from the SHOW CHARACTER SET statement. The ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-collation-character-set-applicability-table.html
The COLLATION_CHARACTER_SET_APPLICABILITY table indicates what character set is applicable for what collation. CHARACTER_SET_NAME The name of the character set with which the collation is associated. Notes The COLLATION_CHARACTER_SET_APPLICABILITY ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-collations-table.html
The COLLATIONS table provides information about collations for each character set. CHARACTER_SET_NAME The name of the character set with which the collation is associated. IS_DEFAULT Whether the collation is the default for its character set.
https://dev.mysql.com/doc/refman/5.7/en/information-schema-optimizer-trace-table.html
The OPTIMIZER_TRACE table provides information produced by the optimizer tracing capability for traced statements. The OPTIMIZER_TRACE table has these columns: QUERY The text of the traced statement. MISSING_BYTES_BEYOND_MAX_MEM_SIZE Each ...