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/upgrading-from-previous-series.html
However, it also has compatibility implications that may affect existing MySQL installations: Clients and connectors that have not been updated to know about caching_sha2_password may have trouble connecting to a MySQL 8.0 server configured with ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-backups-read-only.html
Note The instructions in this section place the server to be backed up in a state that is safe for backup methods that get the data from the server, such as mysqldump (see Section 6.5.4, “mysqldump — A Database Backup Program”). This server is ...You should not attempt to use these instructions to make a binary backup by copying files directly because the server may still have modified data cached in memory and not flushed to ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-reference.html
read_firewall_groups(group, mode, user) This aggregate function updates the firewall group profile cache through a SELECT statement on the mysql.firewall_groups table. Firewall Account Profile Functions These functions perform management operations ...The mysql.firewall_groups table lists names and operational modes of registered firewall group ...
https://dev.mysql.com/doc/refman/8.0/en/json.html
Partial Updates of JSON Values In MySQL 8.0, the optimizer can perform a partial, in-place update of a JSON column instead of removing the old document and writing the new document in its entirety to the column. This optimization can be performed ...
https://dev.mysql.com/doc/refman/8.0/en/server-options.html
mysqld_safe reads options from the [mysqld], [server], [mysqld_safe], and [safe_mysqld] groups. For more precise control over the server SQL mode, use the --sql-mode option instead. See Section 1.6, “MySQL Standards Compliance”, and Section ...
https://dev.mysql.com/doc/refman/8.0/en/lock-tables.html
Locks may be used to emulate transactions or to get more speed when updating tables. For cascading updates, a shared-nothing write lock (LOCK TABLES WRITE) is taken on related tables that are involved in the operation. WRITE locks normally have ...
https://dev.mysql.com/doc/refman/8.0/en/analyze-table.html
ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ... [WITH N BUCKETS] ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [USING DATA 'json_data'] ANALYZE [NO_WRITE_TO_BINLOG ...ANALYZE TABLE generates table statistics: ANALYZE TABLE without any HISTOGRAM clause performs a key distribution analysis and stores the distribution for the named table or ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html
--idempotent Command-Line Format --idempotent Type Boolean Default Value true Tell the MySQL Server to use idempotent mode while processing updates; this causes suppression of any duplicate-key or key-not-found errors that the server encounters in ...mysqlbinlog sets the value of pseudo_replica_mode or pseudo_slave_mode to true before executing any SQL ... The ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-mysql-cluster.html
What is the difference between using NDB Cluster versus using MySQL Replication? In traditional MySQL replication, a source MySQL server updates one or more replicas. If a transaction-safe engine such as InnoDB is being used, a transaction is either ... In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-filter-definitions.html
SELECT (for table referenced in REPLACE clause LOAD DATA LOAD XML update event: UPDATE UPDATE ... WHERE (for tables referenced in UPDATE clause) Blocking Execution of Specific Events event items can include an abort item that indicates whether to ...