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/performance-schema-data-locks-table.html
row *************************** ENGINE: INNODB ENGINE_LOCK_ID: 139664434886512:1059:139664350547912 ENGINE_TRANSACTION_ID: 2569 THREAD_ID: 46 EVENT_ID: 12 OBJECT_SCHEMA: test OBJECT_NAME: t1 PARTITION_NAME: NULL SUBPARTITION_NAME: NULL INDEX_NAME: ...For information about which lock requests are blocked by which held locks, see Section 29.12.13.2, “The data_lock_waits ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-status-by-worker-table.html
Before MySQL 8.0.13, these columns were not reset on a replica that was operating in single-threaded mode, only on a multithreaded replica. This table provides details of the transactions handled by applier threads on a replica or Group Replication ...
https://dev.mysql.com/doc/refman/8.0/en/plugin-loading.html
For example, if the plugin implements a storage engine, existing tables for the storage engine become inaccessible, and attempts to create new tables for the storage engine result in tables that use the default storage engine unless the ... Server ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-rounding.html
Such truncation is not an error, even in strict SQL mode (see Section 14.24.3, “Expression Handling”). This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and ...
https://dev.mysql.com/doc/refman/8.0/en/program-options.html
The following command runs mysql in “no column names” mode: mysql --column-names --skip-column-names MySQL programs determine which options are given first by examining environment variables, then by processing option files, and then by checking ... There are several ways to specify options for MySQL programs: List the options on the command line following the program ...
https://dev.mysql.com/doc/refman/8.0/en/replication-binlog-encryption-scope.html
From MySQL 8.0.17, when binary log encryption is active on the server, temporary files used to hold the binary log cache are encrypted using AES-CTR (AES Counter mode) for stream encryption. Note If you use LOAD DATA when binlog_format=STATEMENT is ...Existing binary log files and relay log files that were present on the server when you started encryption are not ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-assign-anon.html
If it is possible to enable GTIDs on the replication source server, as described in Section 19.1.4, “Changing GTID Mode on Online Servers”, use that approach instead. The replica must have gtid_mode=ON set, and this cannot be changed afterwards, ... From MySQL 8.0.23, you can set up replication channels to assign a GTID to replicated transactions that do not already have ...
https://dev.mysql.com/doc/refman/8.0/en/replication-upgrade.html
Changes affecting operations in strict SQL mode (STRICT_TRANS_TABLES or STRICT_ALL_TABLES) may result in replication failure on an upgraded replica. When the server is running with global transaction identifiers (GTIDs) enabled (gtid_mode=ON), do ...
https://dev.mysql.com/doc/refman/8.0/en/reusing-ssl-sessions.html
Table 8.15 System and Status Variables for Session Reuse System Variable Name Corresponding Status Variable Name ssl_session_cache_mode Ssl_session_cache_mode ssl_session_cache_timeout Ssl_session_cache_timeout Note When the value of the ... As of ...
https://dev.mysql.com/doc/refman/8.0/en/server-configuration-validation.html
As of MySQL 8.0.16, MySQL Server supports a --validate-config option that enables the startup configuration to be checked for problems without running the server in normal operational mode: mysqld --validate-config If no errors are found, the ...If ...