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/mysql-enterprise.html
Like MySQL Community Edition, MySQL Enterprise Edition includes MySQL Server, a fully integrated transaction-safe, ACID-compliant database with full commit, rollback, crash-recovery, and row-level locking capabilities. In addition, MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.0/en/outer-join-optimization.html
MySQL implements an A LEFT JOIN B join_specification as follows: Table B is set to depend on table A and all tables on which A depends. Table A is set to depend on all tables (except B) that are used in the LEFT JOIN condition. The LEFT JOIN ...
https://dev.mysql.com/doc/refman/8.0/en/packet-too-large.html
For example, to set the size for the server to 128MB, add the following lines in an option file: [mysqld] max_allowed_packet=128M It is safe to increase the value of this variable because the extra memory is allocated only when needed. If you ... A ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-load-data.html
LOAD DATA is considered unsafe for statement-based logging (see Section 19.2.1.3, “Determination of Safe and Unsafe Statements in Binary Logging”). When binlog_format=STATEMENT is set, note that LOAD DATA does not generate a warning, unlike ...
https://dev.mysql.com/doc/refman/8.0/en/reset-master.html
For a server where GTIDs are in use (gtid_mode is ON), issuing RESET MASTER resets the GTID execution history. The behavior of RESET MASTER when used while replicas are running is undefined (and thus unsupported), whereas PURGE BINARY LOGS may be ...
https://dev.mysql.com/doc/refman/8.0/en/security-against-attack.html
For example: [mysqld] user=mysql This causes the server to start as the designated user whether you start it manually or by using mysqld_safe or mysql.server. To make FILE-privilege operations a bit safer, files generated with SELECT ... This can be ... When you connect to a MySQL server, you should use a ...
https://dev.mysql.com/doc/refman/8.0/en/security-options.html
The following table shows mysqld options and system variables that affect security. For descriptions of each of these, see Section 7.1.7, “Server Command Options”, and Section 7.1.8, “Server System Variables”.
https://dev.mysql.com/doc/refman/8.0/en/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...
https://dev.mysql.com/doc/refman/8.0/en/stop-group-replication.html
To be completely safe, ensure that your applications can no longer connect to the instance before issuing this statement to avoid any chance of stale reads. This statement requires the GROUP_REPLICATION_ADMIN privilege (or the deprecated SUPER ...
https://dev.mysql.com/doc/refman/8.0/en/system-schema.html
server_cost, engine_cost: The optimizer cost model uses tables that contain cost estimate information about operations that occur during query execution. It contains tables that store information required by the MySQL server as it runs. A broad ...