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/binary-log.html
Running a server with binary logging enabled makes performance slightly slower. The safest value for sync_binlog is 1 (the default), but this is also the slowest. The binary log contains “events” that describe database changes such as table ...
https://dev.mysql.com/doc/refman/8.0/en/charset-connection.html
The client sends SQL statements, such as queries, over the session connection. A “connection” is what a client program makes when it connects to the server, to begin a session within which it interacts with the server. The server sends ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-sets.html
This section describes the collations available for Unicode character sets and their differentiating properties. MySQL supports multiple Unicode character sets: utf8mb4: A UTF-8 encoding of the Unicode character set using one to four bytes per ...
https://dev.mysql.com/doc/refman/8.0/en/condition-filtering.html
In join processing, prefix rows are those rows passed from one table in a join to the next. In general, the optimizer attempts to put tables with low prefix counts early in the join order to keep the number of row combinations from increasing ...
https://dev.mysql.com/doc/refman/8.0/en/create-logfile-group.html
CREATE LOGFILE GROUP logfile_group ADD UNDOFILE 'undo_file' [INITIAL_SIZE [=] initial_size] [UNDO_BUFFER_SIZE [=] undo_buffer_size] [REDO_BUFFER_SIZE [=] redo_buffer_size] [NODEGROUP [=] nodegroup_id] [WAIT] [COMMENT [=] 'string'] ENGINE [=] ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
Example queries are show here: mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_FOREIGN \G *************************** 1. MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help ...
https://dev.mysql.com/doc/refman/8.0/en/declare-handler.html
statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... HANDLER statement specifies a handler that deals ...
https://dev.mysql.com/doc/refman/8.0/en/diagnostics-area.html
SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a diagnostics area stack, containing a diagnostics area for each nested execution context. Standard SQL also supports GET STACKED DIAGNOSTICS syntax ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-configuration.html
In MySQL 8.0, error logging uses the MySQL component architecture described at Section 7.5, “MySQL Components”. The error log subsystem consists of components that perform log event filtering and writing, as well as a system variable that ...
https://dev.mysql.com/doc/refman/8.0/en/explain-for-connection.html
To obtain the execution plan for an explainable statement executing in a named connection, use this statement: EXPLAIN [options] FOR CONNECTION connection_id; EXPLAIN FOR CONNECTION returns the EXPLAIN information that is currently being used to ...