PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-operations.html
Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this section. Note The byte length of a VARCHAR column is dependant on the byte length of the character set. You can also drop a ...Index Operations Primary Key Operations Column Operations Generated Column Operations Foreign Key Operations Table Operations Tablespace Operations Partitioning Operations Index Operations The following table provides an overview of online DDL support for index ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html
Note InnoDB Cluster uses Group Replication, but the default values of the Group Replication system variables may differ from the defaults documented in this section. Note that the standard SQL client connection is not automatically included on a ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-reference.html
| +-----------------------------------------------------------------------+ mysql> SELECT audit_log_read('null'); +------------------------+ | audit_log_read('null') | +------------------------+ | null | +------------------------+ Notes: Prior to ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-usage.html
Note The FIREWALL_EXEMPT, FIREWALL_ADMIN, and FIREWALL_USER privileges can be granted only while the firewall is installed because the MYSQL_FIREWALL plugin defines those privileges. Note Due to the advantages of group profiles over account ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
Note Connections from data nodes to management nodes is done using the ndb_mgmd management port (the management server's PortNumber) so outgoing connections to that port from any data nodes should always be permitted. Note This directory must exist ... The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data ...
https://dev.mysql.com/doc/refman/8.0/en/storage-engines.html
The following table provides an overview of some storage engines provided with MySQL, with clarifying notes following the table. Storage engines are MySQL components that handle the SQL operations for different table types. InnoDB is the default ...
https://dev.mysql.com/doc/refman/8.0/en/atomic-ddl.html
Note The redo logs for changes to the mysql.innodb_ddl_log table are flushed to disk immediately regardless of the innodb_flush_log_at_trx_commit setting. An atomic DDL statement combines the data dictionary updates, storage engine operations, and ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html
Certain options might require other privileges as noted in the option descriptions. Note A dump made using PowerShell on Windows with output redirection creates a file that has UTF-16 encoding: mysqldump [options] > dump.sql However, UTF-16 is not ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
Note Running MySQL server on a 4K sector hard drive on Windows is not supported with unbuffered. innodb_log_file_size Command-Line Format --innodb-log-file-size=# Deprecated 8.0.30 System Variable innodb_log_file_size Scope Global Dynamic No SET_VAR ... InnoDB Startup Options InnoDB System Variables System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html
Note mysqlpump is deprecated as of MySQL 8.0.34; expect it to be removed in a future version of MySQL. Certain options might require other privileges as noted in the option descriptions. Note A dump made using PowerShell on Windows with output ...