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/fido-pluggable-authentication.html
The file must be located in the directory named by the plugin_dir system variable. Table 8.27 Plugin and Library Names for FIDO Authentication Plugin or File Plugin or File Name Server-side plugin authentication_fido Client-side plugin ...The file ... Note FIDO pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.0/en/general-thread-states.html
This state is used even if the table could not be created due to some error. closing tables The thread is flushing the changed table data to disk and closing the used tables. Actions taken by the server in this state include flushing the binary log ... The following list describes thread State values that are associated with general query processing and not more specialized activities such as ...
https://dev.mysql.com/doc/refman/8.0/en/show-warnings.html
SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the conditions (errors, warnings, and notes) resulting from executing a statement in the current session. If ...
https://dev.mysql.com/doc/refman/8.0/en/nonpersistible-system-variables.html
SET PERSIST and SET PERSIST_ONLY enable global system variables to be persisted to the mysqld-auto.cnf option file in the data directory (see Section 15.7.6.1, “SET Syntax for Variable Assignment”). A global system variable might involve ...
https://dev.mysql.com/doc/refman/8.0/en/online-ddl-parallel-thread-configuration.html
The number of parallel threads that sort and load data is controlled by the innodb_ddl_threads variable, introduced in MySQL 8.0.27. The actual number of threads that scan the clustered index is the number defined by the innodb_parallel_read_threads ...The maximum setting is 256, which is the maximum number for all ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html
User credentials set using CHANGE REPLICATION SOURCE TO | CHANGE MASTER TO are stored in plain text in the replication metadata repositories on the server, but user credentials specified on START GROUP_REPLICATION are saved in memory only, and are ...What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 ...For ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-row-events.html
The following examples illustrate how mysqlbinlog displays row events that specify data modifications. Omitting extraneous lines, the output for the row events produced by the preceding statement sequence looks like this: $> mysqlbinlog log_file ... The output contains lines beginning with ###: $> mysqlbinlog -v log_file ...These correspond to events ...# at 218 #080828 15:03:08 server id 1 end_log_pos 258 Write_rows: table id 17 flags: STMT_END_F BINLOG ' ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-functions-general-purpose.html
The keyring functions are contained in a plugin library file, which also contains a keyring_udf plugin that must be enabled prior to function invocation. For these functions to be used, a keyring plugin such as keyring_file or keyring_okv, or a ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-server-clients.html
Start the client with --protocol=TCP to connect using TCP/IP, --protocol=SOCKET to connect using a Unix socket file, --protocol=PIPE to connect using a named pipe, or --protocol=MEMORY to connect using shared memory. For the other types of ...For ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search.html
For large data sets, it is much faster to load your data into a table that has no FULLTEXT index and then create the index after that, than to load data into a table that has an existing FULLTEXT index. The search string must be a string value that ...Full-text indexes can be used only with InnoDB or MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT ... MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY ...