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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/session-state-tracking.html
A client can enable these trackers to receive notification of changes to its session state. Uses for Session State Trackers Available Session State Trackers C API Session State Tracker Support Test Suite Session State Tracker Support Uses for ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-table.html
row *************************** Table: t1 Create Table: CREATE TABLE `t1` ( `c1` int NOT NULL, PRIMARY KEY (`c1`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT When creating a table with strict mode disabled, ... SHOW CREATE TABLE tbl_name Shows the CREATE TABLE statement that creates the named ...