PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-optimization.html
Performance Schema indexes are predefined and cannot be dropped, added, or altered. Applications that monitor databases may make frequent use of Performance Schema tables. To write queries for these tables most efficiently, take advantage of their ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-tls-channel-status-table.html
Connection interface TLS properties are set at server startup, and can be updated at runtime using the ALTER INSTANCE RELOAD TLS statement. The tls_channel_status table (available as of MySQL 8.0.21) provides information about connection interface ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-authentication.html
The Default Authentication Plugin The CREATE USER and ALTER USER statements have syntax for specifying how an account authenticates. To avoid this problem, the protocol implementation used by the client should have its own default plugin and should ... When a client connects to the MySQL server, the server uses the user name provided by the client and the client host to select the appropriate account row from the mysql.user system ...
https://dev.mysql.com/doc/refman/8.0/en/preface.html
Conversion to other formats is allowed as long as the actual content is not altered or edited in any way. This is the Reference Manual for the MySQL Database System, version 8.0, through release 8.0.45. Differences between minor versions of MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/processlist-access.html
Note As of MySQL 8.0.22, an alternative implementation for SHOW PROCESSLIST is available based on the Performance Schema processlist table, which, like the threads table, does not require a mutex and has better performance characteristics. The ...
https://dev.mysql.com/doc/refman/8.0/en/proxy-users.html
As an alternative to proxy users, DBAs may find that roles provide a suitable way to map users onto specific sets of named privileges. Use the CREATE USER statement to associate an account with an authentication plugin, or ALTER USER to change its ...The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking ...
https://dev.mysql.com/doc/refman/8.0/en/replace.html
When modifying an existing table that is not partitioned to accommodate partitioning, or, when modifying the partitioning of an already partitioned table, you may consider altering the table's primary key (see Section 26.6.1, “Partitioning Keys, ... REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | VALUE} (value_list) [, (value_list)] ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs-status.html
Otherwise, the repositories were created as files in the data directory named master.info and relay-log.info, or with alternative names and locations specified by the --master-info-file option and relay_log_info_file system variable. A replica ...
https://dev.mysql.com/doc/refman/8.0/en/replication-encrypted-connections.html
For example: mysql> CREATE USER 'repl'@'%.example.com' IDENTIFIED BY 'password' -> REQUIRE SSL; mysql> GRANT REPLICATION SLAVE ON *.* -> TO 'repl'@'%.example.com'; If you have an existing replication user account on the source, you can add REQUIRE ... To use an encrypted connection for the transfer of the binary log required during replication, both the source and the replica servers must support encrypted network ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-memory.html
A change in max_heap_table_size takes effect for MEMORY tables that are created or updated using ALTER TABLE ... When a replication source server shuts down and restarts, its MEMORY tables become empty. To replicate this effect to replicas, the ...