PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/optimizer-statistics.html
Here is a sample histogram object: { "buckets": [ [ 1, 0.3333333333333333 ], [ 2, 0.6666666666666666 ], [ 3, 1 ] ], "null-values": 0, "last-updated": "2017-03-24 13:32:40.000000", "sampling-rate": 1, "histogram-type": "singleton", ... The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-slavebaseconfig.html
Updates received from A must be logged by B to its binary log, in order to be passed on to C. In addition to binary logging, this replication topology requires the system variable log_replica_updates (from MySQL 8.0.26) or log_slave_updates (before ... Each replica must have a unique server ID, as specified by the server_id system ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-examples.html
Operations to watch out for include transactions involving multi-table UPDATE statements, triggers, cascading foreign keys, stored functions that update multiple tables, and DML statements that invoke stored functions that update one or more tables.
https://dev.mysql.com/doc/refman/8.0/en/replication-threads-monitor-main.html
row *************************** Id: 2 User: root Host: localhost:32931 db: NULL Command: Binlog Dump Time: 94 State: Has sent all binlog to slave; waiting for binlog to be updated Info: NULL Here, thread 2 is a Binlog Dump thread that services a ...
https://dev.mysql.com/doc/refman/8.0/en/source-thread-states.html
This enables monitoring tools that rely on the old names to continue working until they can be updated to use the new names. Master has sent all binlog to slave; waiting for more updates From MySQL 8.0.26: Source has sent all binlog to replica; ...
https://dev.mysql.com/doc/refman/8.0/en/fido-pluggable-authentication.html
You need to understand the release model for MySQL innovation and long-term support (LTS) versions before you proceed with an upgrade. When the client program connects, the server places the client session in sandbox mode if the device must be ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html
It uses Electronic Codebook (ECB) block encryption mode for tablespace key encryption and Cipher Block Chaining (CBC) block encryption mode for data encryption. Enable the stage/innodb/alter tablespace (encryption) instrument: mysql> USE ... InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/alter-database.html
On the other hand, for a function called within a SELECT, execution of the function body happens in prelocked mode. alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | ...
https://dev.mysql.com/doc/refman/8.0/en/optimizer-hints.html
The parser recognizes optimizer hint comments after the initial keyword of SELECT, UPDATE, INSERT, REPLACE, and DELETE statements. The RESOURCE_GROUP hint must appear after the initial statement keyword (SELECT, INSERT, REPLACE, UPDATE, or DELETE).
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-restrictions.html
When using GTIDs, updates to tables using nontransactional storage engines such as MyISAM cannot be made in the same statement or transaction as updates to tables using transactional storage engines such as InnoDB. This restriction is due to the ...